Re: EXEC SQL INCLUDE syntax

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!