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