sorry for not coming back to this earlier. Yeah, this is no real solution.
I thought about checking the character directly before the dollar quote.
But I have not had the time to look at the grammer if that is enough to fix
all error cases... I will do so tomorrow.
Kris Jurka schrieb:
> On Tue, 10 Jul 2007, Michael Paesold wrote:
>> Tom Lane schrieb:
>>> Kris Jurka <books(at)ejurka(dot)com> writes:
>>>> On Mon, 9 Jul 2007, Altaf Malik wrote:
>>>>> PreparedStatement pstmt = con.prepareStatement("insert into a$b$c
>>>>> values( ? , ?)");
>>>> This is a bug in dollar quote parsing. It assumes that any
>>>> potential dollar quote start will have an end tag.
>>> If it thinks that's a dollar quote start, it's wrong already... that's
>>> a perfectly valid table name. (Although personally I'd suggest that the
>>> OP avoid dollar signs in identifiers, since they're none too portable.)
>> I guess I missed that case when implementing dollar quoting in the
>> driver. I will have a look at it shortly.
> Did you ever get a chance to look at this? The attached patch fixes the
> original complaint by ensuring that the ending tag exists, but as Tom
> pointed out that's still not good enough as the second attached test
> case demonstrates.
> Kris Jurka
In response to
pgsql-jdbc by date
|Next:||From: Dominik Heller||Date: 2007-10-17 13:56:58|
|Subject: Getting started with jdbc3 and eclipse|
|Previous:||From: Tore Halset||Date: 2007-10-16 08:29:19|
|Subject: Re: text metadata|