PostgreSQL JDBC - Re: semicolons separating statements in a rule action body

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Re: semicolons separating statements in a rule action body

Kris Jurka

2005-11-08, 4:12 pm

On Wed, 2 Nov 2005, Jolly Chen wrote:

> 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

Patch applied to 8.0 and head cvs branches. For future reference we
prefer context diffs (diff -c) patches.

Kris Jurka

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

Sponsored Links