impossible to create a table having the same name of a sequence object

PostgreSQL Bugs List <pgsql-bugs@postgresql.org>

From: pgsql-bugs@postgresql.org
To: pgsql-bugs@postgresql.org
Date: 2001-01-03T15:27:48Z
Lists: pgsql-bugs
jose (jose@sferacarta.com) reports a bug with a severity of 3
The lower the number the more severe it is.

Short Description
impossible to create a table having the same name of a sequence object

Long Description
prova=# \d
         List of relations
     Name     |   Type   |  Owner
--------------+----------+----------
 a            | sequence | postgres
 comuni       | table    | postgres
 distributors | table    | postgres
 films        | table    | postgres
 tablename    | table    | postgres
(5 rows)

prova=# create table a(id int);
ERROR:  Relation 'a' already exists
prova=#


Sample Code


No file was uploaded with this report