Received: from sss.pgh.pa.us (sss.pgh.pa.us [209.114.132.154]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f03128722023 for ; Tue, 2 Jan 2001 20:02:08 -0500 (EST) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.1/8.11.1) with ESMTP id f0312iB14827; Tue, 2 Jan 2001 20:02:44 -0500 (EST) To: jkakar@expressus.com cc: pgsql-sql@postgresql.org Subject: Re: Weird problem with script... In-reply-to: <20010102160118.A5985@expressus.com> References: <20010102160118.A5985@expressus.com> Comments: In-reply-to jkakar@expressus.com message dated "Tue, 02 Jan 2001 16:01:18 -0800" Date: Tue, 02 Jan 2001 20:02:44 -0500 Message-ID: <14824.978483764@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200101/24 X-Sequence-Number: 685 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