Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-interfacespgsql-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

pgsql-bugs by date

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

pgsql-interfaces by date

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

pgsql-patches by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group