| 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: | Whole Thread | Raw Message | 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 |