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@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