semicolons separating statements in a rule action body confuses parseQuery()

From: Jolly Chen <jolly(at)gauntletsystems(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: semicolons separating statements in a rule action body confuses parseQuery()
Date: 2005-11-03 00:26:11
Message-ID: 8B827CA7-F423-4073-828C-A84C0338EA53@gauntletsystems.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

using jdbc-8.0-313 against 8.0.4,

the driver gets confused when parsing rule definition statements with
embedded semicolons such as :

"create rule r1 as on insert to foo do (delete from bar; insert into
bar select * from foo; ); "

the following patch shows a possible quick fix for
QueryExecutorImpl.parseQuery() in org/postgresql/core/v3/
QueryExecutorImpl.java

69d68
< int inParen = 0;
77,82d75
< case '(':
< if (!inSingleQuotes && !inDoubleQuotes) inParen++;
< break;
< case ')':
< if (!inSingleQuotes && !inDoubleQuotes) inParen--;
< break;
105c98
< if (!inSingleQuotes && !inDoubleQuotes && inParen
== 0)
---
> if (!inSingleQuotes && !inDoubleQuotes)

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Russell Francis 2005-11-03 02:31:00 Network datatype extensions try 2
Previous Message Michael Dean 2005-11-02 23:30:14 postgres and ofbiz