Re: Problems with semicolon trying to create a trigger function via jdbc

Collin Peters <cpeters@intouchtechnology.com> writes:
> I have some framework code that needs to dynamically generate a
> function.� There seems to be a problem where the SQL gets truncated at
> the first semicolon encountered in the function.� I have tried this
> with a very simple function and duplicated it.

Not really an expert, but there are some versions of the jdbc driver
that don't understand dollar-quoted strings --- try using more
conventional quoting and see if it works.

            regards, tom lane