Re: ecpg error (19th Feb cvsup)

Michael Meskes <meskes@topsystem.de>

From: Michael Meskes <meskes@topsystem.de>
To: emkxp01@mtcc.demon.co.uk
Cc: pgsql-hackers@postgresql.org (PostgreSQL Hacker)
Date: 1998-02-20T08:39:25Z
Lists: 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