Received: from www-uk-05.digiserve.com ([195.172.23.63]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f03AZs770791 for ; Wed, 3 Jan 2001 05:35:54 -0500 (EST) (envelope-from dev@archonet.com) Received: from mainbox.archonet.com (mwynhau.demon.co.uk [193.237.186.96]) by www-uk-05.digiserve.com (8.9.1/8.9.1) with ESMTP id KAA02958 for ; Wed, 3 Jan 2001 10:36:41 GMT Received: from client (client.archonet.com [192.168.1.16]) by mainbox.archonet.com (Postfix) with SMTP id 88CF52A01E for ; Wed, 3 Jan 2001 10:22:07 +0000 (GMT) Message-ID: <019501c0756f$05881d40$1001a8c0@archonet.com> From: "Richard Huxton" To: References: <20010102160118.A5985@expressus.com> <14824.978483764@sss.pgh.pa.us> Subject: Re: Weird problem with script... Date: Wed, 3 Jan 2001 10:22:03 -0000 MIME-Version: 1.0 Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 X-Archive-Number: 200101/29 X-Sequence-Number: 690 ----- Original Message ----- From: "Tom Lane" To: Cc: Sent: Wednesday, January 03, 2001 1:02 AM Subject: Re: [SQL] Weird problem with script... > jkakar@expressus.com writes: > > I'm building a script to create the tables in my database. Everything > > works fine except one thing with this part of my script: > > > create table tbl_resume_free_text_type ( > > type_id int, > > type text > > ); > > > -- insert into tbl_resume_free_text_type (type_id, type) values (1, 'Hobbies'); > > -- insert into tbl_resume_free_text_type (type_id, type) values (2, 'Special Talents'); > > > If I uncomment the two insert statements I get an error message > > stating that tbl_resume_free_text_type doesn't exist. > > Odd. The three statements work just fine for me when executed by hand > in 7.0.3. Anyone else able to reproduce a problem? > > regards, tom lane Works fine on 7.0.0 putting them in a text file and doing psql < filename Jamu - how are you executing this? - Richard