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

Re: EXEC SQL INCLUDE syntax

From: Andrew S Halper <ashalper(at)usgs(dot)gov>
To: Michael Meskes <meskes(at)postgresql(dot)org>
Cc: Andrew S Halper <ashalper(at)usgs(dot)gov>,pgsql-interfaces(at)postgresql(dot)org
Subject: Re: EXEC SQL INCLUDE syntax
Date: 2003-10-21 16:32:51
Message-ID: 20031021163251.GA5795@natasha.daztcn.wr.usgs.gov (view raw or flat)
Thread:
Lists: pgsql-interfaces
On 2003.10.21 00:47, Michael Meskes wrote:
> 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.

I must be doing something wrong because I can't get ecpg to include anything  
with double quotes around it.  I guess I'll just put something in the Makefile  
to strip the single quotes out of the Ingres includes.

I'll send you the two files off-list and you can experiment with it if you  
like.

Andy

In response to

pgsql-interfaces by date

Next:From: creidDate: 2003-10-23 20:01:11
Subject: LIBPQ
Previous:From: Michael MeskesDate: 2003-10-21 07:47:17
Subject: Re: EXEC SQL INCLUDE syntax

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