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

From: Michael Meskes <meskes(at)postgresql(dot)org>
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>, PostgreSQL-interfaces <pgsql-interfaces(at)postgresql(dot)org>
Subject: Re: [BUGS] BUG #2171: Differences compiling plpgsql in ecpg and psql
Date: 2006-02-09 08:14:56
Message-ID: 200602090914.58790.meskes@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-interfaces pgsql-patches

> > Actually ecpg should not translate dollar quoting at all. I'm going to
> > fix this. Dollar quotes will then be send to the backend with
> > translation and the backend takes care of the rest.
>
> Well, CVS version before I modified it had "dolq" stuff in the lexer to
> handle dollar quotes and pass it as SCONST to the parser.

Yes, I know. This was buggy from the get go on IMO. :-)

> > Not sure, but there appears to be a bug in the routine that outputs a
> > statement. I will change that one as well and would ask you to just
> > check again. It seems to me that this also fixes your problem. I tried
> > with the one test case in this email and it seems to work. But then I'm
> > currently travelling and do not have that much spare time to test.
>
> The problem is that output.c does:
>
> printf("abc
> def");
>
> While some compilers are OK with that, others are not. I changed it to
> output:
>
> printf("abc\n\
> def");

Okay, will look into this again.

Michael
--
Michael Meskes
Email: Michael at Fam-Meskes dot De, Michael at Meskes dot (De|Com|Net|Org)
ICQ: 179140304, AIM/Yahoo: michaelmeskes, Jabber: meskes(at)jabber(dot)org
Go SF 49ers! Go Rhein Fire! Use Debian GNU/Linux! Use PostgreSQL!

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Ian Moore 2006-02-09 11:26:46 BUG #2250: JSTL parameterized queries inserting numeric values
Previous Message Satheesh 2006-02-09 05:09:20 BUG #2249: unsupported frontend protocol

Browse pgsql-interfaces by date

  From Date Subject
Next Message Christoph Zwerschke 2006-02-11 10:59:37 Finding the pqlib version
Previous Message Micah Desjardins 2006-02-09 00:03:04 Apache 2.2 and mod_authn_dbd

Browse pgsql-patches by date

  From Date Subject
Next Message Stephen Frost 2006-02-09 18:27:41 Re: [HACKERS] Krb5 & multiple DB connections
Previous Message Tom Lane 2006-02-09 03:41:44 Re: [PATCHES] date overflows