table name - TypeCreate error

From: "Felipe Nievinski" <fnievinski(at)terra(dot)com(dot)br>
To: pgsql-sql(at)postgresql(dot)org
Subject: table name - TypeCreate error
Date: 2002-01-24 13:20:26
Message-ID: GQG2E2$IU_ZNmw5Dgafi3cqvSzdlXfmVYPxmOdR6Yi5@terra.com.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi.

Please, I would like to know why I can't create a table with a name
equal of a type name.

For example, when a try this:
CREATE TABLE time (id int);
I get the following error message:
ERROR: TypeCreate: type time already defined

I would expect to be able to create a table with any name different
than others tables' name.

Thank you in advance,
Felipe.

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Radu-Adrian Popescu 2002-01-24 13:37:43 Re: table name - TypeCreate error
Previous Message Murray Prior Hobbs 2002-01-24 03:13:53 Re: Red Hat 7.2 Regression failures (Re: pltcl build problem on FreeBSD (was: Re: pltlc and pltlcu problems))