Re: [pgsql-jdbc] dollar-quoted CREATE FUNCTION statement fails

From: Dave Cramer <pg(at)fastcrypt(dot)com>
To: Michael Paesold <mpaesold(at)gmx(dot)at>
Cc: Grégory Chazalon <Gregory(dot)Chazalon(at)advestigo(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-jdbc(at)postgresql(dot)org
Subject: Re: [pgsql-jdbc] dollar-quoted CREATE FUNCTION statement fails
Date: 2006-09-28 12:54:44
Message-ID: 11DE4B3E-F76F-42C8-A5A6-2C63E14458AD@fastcrypt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc


On 28-Sep-06, at 7:13 AM, Michael Paesold wrote:

> About dollar-quoting in the JDBC driver...
>
> Tom Lane wrote:
> > 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 ...
>
> Grégory Chazalon write:
>> 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
>> :-)
>
> Me too.
>
> I guess it's just a matter of coding, right? Would the JDBC
> maintainers accept a patch for the 8.2 release of the driver?
Absolutely!
>
> Best Regards
> Michael Paesold
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
> choose an index scan if your joining column's datatypes do not
> match
>

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Scott Marlowe 2006-09-28 14:33:51 Re: Switching database inside current connection
Previous Message Michael Paesold 2006-09-28 11:13:37 Re: [pgsql-jdbc] dollar-quoted CREATE FUNCTION statement fails