Re: Pb with ecpg and include file on PG 8.0.0

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: "Valerie Schneider DSI/DEV" <valerie(dot)schneider(at)meteo(dot)fr>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Pb with ecpg and include file on PG 8.0.0
Date: 2004-09-11 07:14:54
Message-ID: 200409110714.i8B7Esv26605@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Valerie Schneider DSI/DEV wrote:
> ...
> EXEC SQL INCLUDE DbTablesUtilPg.hh;
> ...
>
> EXEC SQL PREPARE S FROM :sqlstmt;
> EXEC SQL DECLARE C_FK_COL CURSOR FOR S;
> EXEC SQL OPEN C_FK_COL;
> EXEC SQL FETCH MAX_FK IN C_FK_COL INTO :fk_id_L , :valid_L, :target_t_L;
>
> with MAX_FK a variable defined in the file
> /VALE/users/clipg/Server/Include/DbTablesUtilPg.hh :
> exec sql define MAX_FK 100;

^

I think your problem is the semicolon.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Harald Armin Massa 2004-09-11 07:32:10 Re: PostgreSQL 8.0 - very good
Previous Message Bruce Momjian 2004-09-11 07:05:28 Re: Can't run 8.0 ....