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

Re: EXEC SQL INCLUDE syntax

From: Michael Meskes <meskes(at)postgresql(dot)org>
To: Andrew S Halper <ashalper(at)usgs(dot)gov>
Cc: pgsql-interfaces(at)postgresql(dot)org
Subject: Re: EXEC SQL INCLUDE syntax
Date: 2003-10-21 07:47:17
Message-ID: 20031021074717.GA1197@feivel.fam-meskes.de (view raw or flat)
Thread:
Lists: pgsql-interfaces
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(at)jabber(dot)org
Go SF 49ers! Go Rhein Fire! Use Debian GNU/Linux! Use PostgreSQL!

In response to

Responses

pgsql-interfaces by date

Next:From: Andrew S HalperDate: 2003-10-21 16:32:51
Subject: Re: EXEC SQL INCLUDE syntax
Previous:From: Andrew S HalperDate: 2003-10-20 20:50:08
Subject: Re: EXEC SQL INCLUDE syntax

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