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 f0300d716279 for ; Tue, 2 Jan 2001 19:00:40 -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 f0301J905994 for pgsql-sql@postgresql.org; Tue, 2 Jan 2001 16:01:19 -0800 From: jkakar@expressus.com Date: Tue, 2 Jan 2001 16:01:18 -0800 To: pgsql-sql@postgresql.org Subject: Weird problem with script... Message-ID: <20010102160118.A5985@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/22 X-Sequence-Number: 683 Hi, 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. With the lines commented out the table gets created (and the rest of the script runs error-free) and I can manually insert these rows afterwards without a problem... I'm running PSQL 7.0.3. Any ideas? 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