impossible to create a table having the same name of a sequence object - Mailing list pgsql-bugs

From pgsql-bugs@postgresql.org
Subject impossible to create a table having the same name of a sequence object
Date
Msg-id 200101031527.f03FRmQ02287@hub.org
Whole thread Raw
Responses Re: impossible to create a table having the same name of a sequence object
List 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

pgsql-bugs by date:

Previous
From: "Denis V. Osadchy"
Date:
Subject: Output of date_part('quarter', date)
Next
From: Thomas Lockhart
Date:
Subject: Re: Output of date_part('quarter', date)