Postgres Pro
Downloads
Home   >   mailing lists

Re: EXEC SQL INCLUDE syntax - Mailing list pgsql-interfaces

From Michael Meskes
Subject Re: EXEC SQL INCLUDE syntax
Date
Msg-id 20031021074717.GA1197@feivel.fam-meskes.de
Whole thread Raw
In response to Re: EXEC SQL INCLUDE syntax  (Andrew S Halper <ashalper@usgs.gov>)
Responses Re: EXEC SQL INCLUDE syntax  (Andrew S Halper <ashalper@usgs.gov>)
List pgsql-interfaces
Tree view 
On Mon, Oct 20, 2003 at 01:50:08PM -0700, Andrew S Halper wrote:
> Changing the single quotes to double quotes worked with the Ingres  
> preprocessor, but not with ecpg:
> 
> natasha:~/nwis-4.4/common/db/midas-tools> ls -l master_table.sc
> -rw-r--r--    1 ashalper nwdba         158 Oct 20 13:46 master_table.sc
> natasha:~/nwis-4.4/common/db/midas-tools> ecpg drop_table.sc
> drop_table.sc:37: ERROR: Cannot open include file "master_table.sc" in line 
> 37

It seems ecpg parsed the statement correctly but could not find the
file. IIRC double quotes mean to not search all include paths but take
"." instead.

Michael
-- 
Michael Meskes
Email: Michael at Fam-Meskes dot De
ICQ: 179140304, AIM/Yahoo: michaelmeskes, Jabber: meskes@jabber.org
Go SF 49ers! Go Rhein Fire! Use Debian GNU/Linux! Use PostgreSQL!

pgsql-interfaces by date:

Previous
From: Andrew S Halper
Date:
Subject: Re: EXEC SQL INCLUDE syntax
Next
From: Andrew S Halper
Date:
Subject: Re: EXEC SQL INCLUDE syntax