From: Andrew S Halper <ashalper@usgs.gov>
To: Michael Meskes <meskes@postgresql.org>
Cc: Andrew S Halper <ashalper@usgs.gov>
Cc: pgsql-interfaces@postgresql.org
Subject: Re: EXEC SQL INCLUDE syntax
Date: Mon, 20 Oct 2003 13:50:08 -0700
Message-ID: <20031020205008.GA7558@natasha.daztcn.wr.usgs.gov> (raw)
In-Reply-To: <20031020180107.GD2843@feivel.fam-meskes.de>
References: <20031017224220.GA1656@natasha.daztcn.wr.usgs.gov>
<20031020180107.GD2843@feivel.fam-meskes.de>
On 2003.10.20 11:01, Michael Meskes wrote:
> On Fri, Oct 17, 2003 at 03:42:20PM -0700, Andrew S Halper wrote:
> > I'm trying to port some Ingres code to PostgreSQL. For Ingres, I had this
> > bit of ESQL:
> >
> > EXEC SQL INCLUDE '../dcl/master_table.sc';
> >
> > which ecpg (2.10.0) can't digest with single quotes, and Ingres (2.5)
> esqlc
>
> > can't digest without single quotes.
>
> ecpg only accepts double quotes or no quote at all.
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
Thanks,
Andy
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: ashalper@usgs.gov, meskes@postgresql.org
Subject: Re: EXEC SQL INCLUDE syntax
In-Reply-To: <20031020205008.GA7558@natasha.daztcn.wr.usgs.gov>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox