Weird script problems solved...

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

Browse pgsql-sql by date

  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