"cannot create TABLE_NAME" error

From: Daniel Stolk <stolkd(at)email(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: "cannot create TABLE_NAME" error
Date: 2000-04-05 21:30:35
Message-ID: 38EBB07B.607BC26@email.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

When I try to create a table and it already exists, I get the error:
"relation 'TABLE_NAME' already exists". However, I tried to create a
table like this:

CREATE table alpx_ (word text not null, field text
not null, expDate date, postingId int4 not null, mall text not
null, sellBuy text not null, datePosted date not null);

and I got the error: "cannot create alpx_"

I was using the 'Pg' module with perl to access the database. Why would
I get this kind of error?

Thanks, Daniel Stolk

Browse pgsql-general by date

  From Date Subject
Next Message Peter Eisentraut 2000-04-06 00:02:16 Re: doing backups
Previous Message Charles Tassell 2000-04-05 21:00:23 SQL Special Characters