Re: [pgsql-jdbc] dollar-quoted CREATE FUNCTION statement fails to execute (SimpleQuery splitting invalid)

Thanks for your answer Tom.

It's too bad that the driver doesn't support this...
I have no idea how difficult would it be to include such an improvement.
However, do you think there is a chance to see this in one of the next releases ?

Needless to say it would be greatly appreciated, at least by one user :-)

Regards,

Gregory

-----Message d'origine-----
De : Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
Envoyé : mardi 22 août 2006 15:10
À : Grégory Chazalon
Cc : pgsql-jdbc(at)postgresql(dot)org
Objet : Re: [JDBC] [pgsql-jdbc] dollar-quoted CREATE FUNCTION statement fails to execute (SimpleQuery splitting invalid)

=?iso-8859-1?Q?Gr=E9gory_Chazalon?= <Gregory(dot)Chazalon(at)advestigo(dot)com> writes:
> I've encountered a strange behavior of the JDBC driver 8.1.407 with PostgreSQL 8.1.4 (windows platform). I really suspect this is a bug inside the driver implementation, that's reason why I write this post.

Last I heard, the JDBC driver hadn't been taught about dollar quoting at all, so it's not surprising that a DQ literal within a query would confuse it.

This ought to get fixed sometime ...

regards, tom lane