Re: ecpg error (19th Feb cvsup) - Mailing list pgsql-hackers

From Michael Meskes
Subject Re: ecpg error (19th Feb cvsup)
Date
Msg-id 199802200839.JAA24004@gauss.topsystem.de
Whole thread Raw
In response to ecpg error (19th Feb cvsup)  (Keith Parks <emkxp01@mtcc.demon.co.uk>)
List pgsql-hackers
Keith Parks writes:
> Hi,
>
> I've a new problem with ecpg.
>
> The latest source fails to process test2.pgc.
>
> Seems like it's choking on the new "whenever" clauses.
>
> [postgres@sparclinux test]$ make
> ecpg test2.pgc
> parse error in line 8
> make: *** [test2.c] Error 1

Oops! ecpg is correct the statement in line 8 isn't. The correct syntax is

exec sql whenever sqlerror do db_error(msg);

Note the 'do'.

I will send a patch later.

Michael

--
Dr. Michael Meskes, Project-Manager    | topsystem Systemhaus GmbH
meskes@topsystem.de                    | Europark A2, Adenauerstr. 20
meskes@debian.org                      | 52146 Wuerselen
Go SF49ers! Go Rhein Fire!             | Tel: (+49) 2405/4670-44
Use Debian GNU/Linux!                  | Fax: (+49) 2405/4670-10

pgsql-hackers by date:

Previous
From: "Vadim B. Mikheev"
Date:
Subject: Re: [HACKERS] odd error creating index in -current...
Next
From: Michael Meskes
Date:
Subject: Re: [HACKERS] RE: New ecgp code problem.