Received: from snigglefritz.expressus.com (dhcphost11.expressus.com [64.114.34.80]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f0FIwi095811 for ; Mon, 15 Jan 2001 13:58:44 -0500 (EST) (envelope-from jkakar@expressus.com) Received: (from jkakar@localhost) by snigglefritz.expressus.com (8.11.1/8.11.1/Debian 8.11.0-6) id f0FIwg901395 for pgsql-sql@postgresql.org; Mon, 15 Jan 2001 10:58:42 -0800 From: jkakar@expressus.com Date: Mon, 15 Jan 2001 10:58:32 -0800 To: pgsql-sql@postgresql.org Subject: Weird script problems solved... Message-ID: <20010115105832.A575@expressus.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.3.12i X-Archive-Number: 200101/149 X-Sequence-Number: 810 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@expressus.com 708-1641 Lonsdale Avenue V: (604) 903-6999 North Vancouver, BC, V7M 2J5