pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedECPG fetch broken after upgrade to 6.5
5+ messages / 2 participants
[nested] [flat]
* ECPG fetch broken after upgrade to 6.5
@ 1999-06-23 22:52 Phil Moors <pmoors@phillips.com>
0 siblings, 3 replies; 5+ messages in thread
From: Phil Moors @ 1999-06-23 22:52 UTC (permalink / raw)
To: pgsql-interfaces
Hi!
Has anyone else had this problem? I have two programs that ECPG processes
flawlessly under 6.4. However, under 6.5, I get:
ml1.sql:364: parse error
line 364 is: EXEC SQL FETCH pick_ip INTO :tWatMacAddress;
Also of note:
One of my programs contained no SQL code. However, I tend to run it through ecpg
out of habit. The old version would (correctly) leave things alone. However, the
new version grabs double slashes, even if they are embedded in within double
quotes. It turned these two lines:
printf("<FORM METHOD=POST ACTION=\"http://pm2/cgi-bin/macs/ml1\">\n");
printf("Select the type of address, enter it into the form and \n");
Into this (all one line):
printf("<FORM METHOD=POST ACTION=\"http: printf("Select the type of
address, enter it into the form and \n");
TIA
Phil
--
pmoors@phillips.com | Speaking for himself only.
--------------------------------------------------------
cat /dev/coffee | /dev/cup | /dev/mouth | /dev/nose > /dev/keyboard
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: [INTERFACES] ECPG fetch broken after upgrade to 6.5
@ 1999-06-24 06:52 Michael Meskes <meskes@postgresql.org>
parent: Phil Moors <pmoors@phillips.com>
2 siblings, 0 replies; 5+ messages in thread
From: Michael Meskes @ 1999-06-24 06:52 UTC (permalink / raw)
To: Phil Moors <pmoors@phillips.com>; +Cc: pgsql-interfaces
On Wed, Jun 23, 1999 at 06:52:05PM -0400, Phil Moors wrote:
> ml1.sql:364: parse error
>
> line 364 is: EXEC SQL FETCH pick_ip INTO :tWatMacAddress;
That one is correct since the stabdard syntax is:
EXEC SQL FETCH IN pick_ip INTO :tWatMacAddress;
> Also of note:
>
> One of my programs contained no SQL code. However, I tend to run it through ecpg
> out of habit. The old version would (correctly) leave things alone. However, the
> new version grabs double slashes, even if they are embedded in within double
> quotes. It turned these two lines:
>
> printf("<FORM METHOD=POST ACTION=\"http://pm2/cgi-bin/macs/ml1\">\n");
> printf("Select the type of address, enter it into the form and \n");
>
> Into this (all one line):
>
> printf("<FORM METHOD=POST ACTION=\"http: printf("Select the type of
> address, enter it into the form and \n");
This looks like a bug. I have to check that.
Michael
--
Michael Meskes | Go SF 49ers!
Th.-Heuss-Str. 61, D-41812 Erkelenz | Go Rhein Fire!
Tel.: (+49) 2431/72651 | Use Debian GNU/Linux!
Email: Michael.Meskes@gmx.net | Use PostgreSQL!
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: [INTERFACES] ECPG fetch broken after upgrade to 6.5
@ 1999-06-24 12:06 Michael Meskes <meskes@postgresql.org>
parent: Phil Moors <pmoors@phillips.com>
2 siblings, 0 replies; 5+ messages in thread
From: Michael Meskes @ 1999-06-24 12:06 UTC (permalink / raw)
To: pgsql-interfaces
On Wed, Jun 23, 1999 at 06:52:05PM -0400, Phil Moors wrote:
> printf("<FORM METHOD=POST ACTION=\"http://pm2/cgi-bin/macs/ml1\">\n");
Got it. It interprets // as a start of a comment. Any idea how to make the
lex code parse this correctly? I will definitely think about it.
Michael
--
Michael Meskes | Go SF 49ers!
Th.-Heuss-Str. 61, D-41812 Erkelenz | Go Rhein Fire!
Tel.: (+49) 2431/72651 | Use Debian GNU/Linux!
Email: Michael.Meskes@gmx.net | Use PostgreSQL!
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: [INTERFACES] ECPG fetch broken after upgrade to 6.5
@ 1999-06-24 13:10 Michael Meskes <meskes@postgresql.org>
parent: Phil Moors <pmoors@phillips.com>
2 siblings, 1 reply; 5+ messages in thread
From: Michael Meskes @ 1999-06-24 13:10 UTC (permalink / raw)
To: pgsql-interfaces
On Wed, Jun 23, 1999 at 06:52:05PM -0400, Phil Moors wrote:
> printf("<FORM METHOD=POST ACTION=\"http://pm2/cgi-bin/macs/ml1\">\n");
> printf("Select the type of address, enter it into the form and \n");
The problem was the quoted ". I've fixed this and will commit my changes
asap.
Michael
--
Michael Meskes | Go SF 49ers!
Th.-Heuss-Str. 61, D-41812 Erkelenz | Go Rhein Fire!
Tel.: (+49) 2431/72651 | Use Debian GNU/Linux!
Email: Michael.Meskes@gmx.net | Use PostgreSQL!
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: [INTERFACES] ECPG fetch broken after upgrade to 6.5
@ 1999-06-24 15:05 Phil Moors <pmoors@phillips.com>
parent: Michael Meskes <meskes@postgresql.org>
0 siblings, 0 replies; 5+ messages in thread
From: Phil Moors @ 1999-06-24 15:05 UTC (permalink / raw)
To: ; +Cc: pgsql-interfaces
Michael Meskes wrote:
>
> On Wed, Jun 23, 1999 at 06:52:05PM -0400, Phil Moors wrote:
> > printf("<FORM METHOD=POST ACTION=\"http://pm2/cgi-bin/macs/ml1\">\n");
> > printf("Select the type of address, enter it into the form and \n");
>
> The problem was the quoted ". I've fixed this and will commit my changes
> asap.
>
> Michael
Michael,
Thank you very much for your time and assistance.
Phil
--
pmoors@phillips.com | Speaking for himself only.
--------------------------------------------------------
Every definition is dangerous. --Erasmus
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~1999-06-24 15:05 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-06-23 22:52 ECPG fetch broken after upgrade to 6.5 Phil Moors <pmoors@phillips.com>
1999-06-24 06:52 ` Michael Meskes <meskes@postgresql.org>
1999-06-24 12:06 ` Michael Meskes <meskes@postgresql.org>
1999-06-24 13:10 ` Michael Meskes <meskes@postgresql.org>
1999-06-24 15:05 ` Phil Moors <pmoors@phillips.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox