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@sss.pgh.pa.us]
Envoyé : mardi 22 août 2006 15:10
À : Grégory Chazalon
Cc : pgsql-jdbc@postgresql.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.Chazalon@advestigo.com> writes:
> I've encountered a strange behavior of the JDBC driver 8.1.407 with PostgreSQL 8.1.4 (windows platform). I really
suspectthis 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
withina query would confuse it.
This ought to get fixed sometime ...
regards, tom lane