| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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!
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew S Halper | 2003-10-21 16:32:51 | Re: EXEC SQL INCLUDE syntax |
| Previous Message | Andrew S Halper | 2003-10-20 20:50:08 | Re: EXEC SQL INCLUDE syntax |