From: | jkakar(at)expressus(dot)com |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | Weird script problems solved... |
Date: | 2001-01-15 18:58:32 |
Message-ID: | 20010115105832.A575@expressus.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Hi,
About a week back I'd posted a message asking for help with a script
that as far as I could tell was well formed. The problem was with 2
INSERT statements directly after the CREATE TABLE statement of the
table that I was trying to insert data into. I'd used C single/multi
line comments of the form:
/* woo */
and
/* foo
* bar
* baz
*/
throughout the script. In order to determine what the problem was I
ran the script through a C preprocessor to remove the comments.
Without comments the script worked as expected. I replaced the C
style comments with SQL '--' comments and the script also worked as
expected. Unfortunately, I didn't maintain a copy of the C commented
script to help PSQL developers but thought this important to mention
anyway.
Thanks,
Jamu.
--
Jamu Kakar (Developer) Expressus Design Studio, Inc.
jkakar(at)expressus(dot)com 708-1641 Lonsdale Avenue
V: (604) 903-6999 North Vancouver, BC, V7M 2J5
From | Date | Subject | |
---|---|---|---|
Next Message | Johann Spies | 2001-01-15 20:13:25 | pg_dump error |
Previous Message | Joern Muehlencord | 2001-01-15 18:29:42 | Adding a parameter to a trigger |