Re: [BUGS] BUG #2171: Differences compiling plpgsql in

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: andrew5(at)ece(dot)cmu(dot)edu, PostgreSQL-patches <pgsql-patches(at)postgresql(dot)org>
Subject: Re: [BUGS] BUG #2171: Differences compiling plpgsql in
Date: 2006-02-02 18:36:41
Message-ID: 1138905401.5342.15.camel@swithin
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-interfaces pgsql-patches

On Wed, 2006-02-01 at 23:48 -0500, Bruce Momjian wrote:
> I have researched your report, and you are right, there are two ecpg
> bugs here. First, dollar quoting uses single-quotes internally to do
> the quoting, but it does not double any single-quotes in the
> dollar-quoted string.
>

As a matter of curiosity, why does ecpg handle dollar quoting like that?
psql, for example, happily just passes a dollar quoted string through to
the backend, without any need to convert it to a conventionally quoted
string.

cheers

andrew

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2006-02-02 21:41:01 Re: [BUGS] BUG #2171: Differences compiling plpgsql in
Previous Message Tom Lane 2006-02-02 14:49:33 Re: Bug in query planer ?

Browse pgsql-interfaces by date

  From Date Subject
Next Message Tom Lane 2006-02-02 21:41:01 Re: [BUGS] BUG #2171: Differences compiling plpgsql in
Previous Message Bruce Momjian 2006-02-02 04:48:45 Re: [BUGS] BUG #2171: Differences compiling plpgsql in ecpg and psql

Browse pgsql-patches by date

  From Date Subject
Next Message Mark Woodward 2006-02-02 19:05:03 Re: Multiple logical databases
Previous Message Bruce Momjian 2006-02-02 17:48:37 Re: Some platform-specific MemSet research