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