Re: Weird message when creating PK constraint named like table

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: r d <rd0002(at)gmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Weird message when creating PK constraint named like table
Date: 2012-01-11 23:24:05
Message-ID: 28874.1326324245@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

r d <rd0002(at)gmail(dot)com> writes:
> The SQLSTATE 42P07 is described in the manual as only as "table undefined",
> and it is not clear if the intent is to allow or
> disallow the creation of a constraint called the same as the table in
> Postgresql.

Where do you see that? In Appendix A that code is listed as
"duplicate_table", which is exactly what the problem is (well, as long
as you know that tables and indexes share the same namespace in PG).

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2012-01-12 00:01:01 Re: Botched estimation in eqjoinsel_semi for cases without reliable ndistinct
Previous Message Jaime Casanova 2012-01-11 22:59:52 Re: BUG #6394: Transacciones concurrentes