Postgres Pro
Downloads
Home   >   mailing lists

Re: Problems with semicolon trying to create a trigger function via jdbc - Mailing list pgsql-jdbc

From Tom Lane
Subject Re: Problems with semicolon trying to create a trigger function via jdbc
Date
Msg-id 24158.1269550822@sss.pgh.pa.us
Whole thread Raw
In response to Problems with semicolon trying to create a trigger function via jdbc  (Collin Peters <cpeters@intouchtechnology.com>)
List pgsql-jdbc
Tree view 
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

pgsql-jdbc by date:

Previous
From: Collin Peters
Date:
Subject: Problems with semicolon trying to create a trigger function via jdbc
Next
From: Maciek Sakrejda
Date:
Subject: Re: Problems with semicolon trying to create a trigger function via jdbc