Skip site navigation (1) Skip section navigation (2)

BUG #1214: ecpg regression in 8.0.0beta1

From: "PostgreSQL Bugs List" <pgsql-bugs(at)postgresql(dot)org>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #1214: ecpg regression in 8.0.0beta1
Date: 2004-08-11 21:59:07
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      1214
Logged by:          R. Scott Bailey

Email address:      scott(dot)bailey(at)eds(dot)com

PostgreSQL version: 7.5 Dev

Operating system:   Tru64 UNIX V5.1B

Description:        ecpg regression in 8.0.0beta1


The following code snippet does not compile under 8.0.0beta1:

--- extract from load-day.pgc ---

exec sql CREATE TEMPORARY TABLE OverallData (Class, Parameter, DataVal)
  AS SELECT Class, Paramter, SUM(DataVal)
  FROM PatrolData JOIN Metrics ON Parameter = MetricName
  WHERE Aggregate = 1
  GROUP BY Class, Parameter, RSBMIN(Tstamp) ;

--- end of extract ---

I get this:
# ecpg -t load-day.pgc
load-day.pgc:200: ERROR: syntax error at or near "SELECT"

Line 200 is the second line of the snippet above, if you couldn't guess 
that. :-) This compiled cleanly under 7.4.3 and prior versions. For thrills, 
I tried typing this command manually in psql and it worked fine. I'd be 
happy to send you more source code and/or database metadata but it doesn't 
feel to me like that is central this issue, since theoretically the ecpg 
preprocessor has no real knowledge of the underlying database. 

For what it may be worth, I have a number of programs I have been 
recompiling and it appears to me that the common factor in what works and 
what doesn't is that "CREATE TEMPORARY TABLE ... AS SELECT ..." seems to 
fail and programs that do not contain this construct compile successfully. 

Hope this helps,


pgsql-bugs by date

Next:From: Clifford ClarkDate: 2004-08-11 22:08:20
Subject: 8.0.0 beta failed to build on mac os x
Previous:From: PostgreSQL Bugs ListDate: 2004-08-11 21:56:24
Subject: BUG #1213: version 8.0 install error in beta1 msi

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group