Re: Weird problem with script...

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: jkakar(at)expressus(dot)com
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Weird problem with script...
Date: 2001-01-03 01:02:44
Message-ID: 14824.978483764@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

jkakar(at)expressus(dot)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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2001-01-03 05:01:11 Re: FUNCTION returing multiple rows
Previous Message Leo Xavier 2001-01-03 00:22:14 order by day or month, etc