Re: BUG #14534: renaming table error

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: balazs(at)obiserver(dot)hu
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #14534: renaming table error
Date: 2017-02-07 18:49:01
Message-ID: 14248.1486493341@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

balazs(at)obiserver(dot)hu writes:
> test=# create table test.testtable (id bigserial not null primary key, t
> text not null);
> CREATE TABLE
> test=# alter table test.testtable rename to _testtable;
> ERROR: type "_testtable" already exists

> There is no, believe me!

Yes, there is ... it's the name given to the array type over the
table's composite type.

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2017-02-07 18:54:31 Re: BUG #14526: no unique or exclusion constraint matching the ON CONFLICT
Previous Message balazs 2017-02-07 18:44:09 BUG #14534: renaming table error