From: | Tomas Psika <tomas(dot)psika(at)gmail(dot)com> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | notice on explicit primary key or index name |
Date: | 2009-09-19 21:10:54 |
Message-ID: | 4AB548DE.1060909@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Hi,
when primary key or unique index is created using explicit name, strange
notice will say that implicit name was generated. But it didnt.
# select version();
PostgreSQL 8.4.1 on i686-pc-linux-gnu, compiled by GCC
i686-pc-linux-gnu-gcc (Gentoo 4.3.4 p1.0, pie-10.1.5) 4.3.4, 32-bit
# create table dummy(x integer, y integer);
CREATE TABLE
# alter table dummy add constraint pk_dummy_x primary key (x);
NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index
"pk_dummy_x" for table "dummy"
ALTER TABLE
Maybe problem in src/backend/commands/indexcmds.c. Untested patch attached.
Regards, Tomas Psika
Attachment | Content-Type | Size |
---|---|---|
implicit_name.patch | text/plain | 1.3 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Pasquale | 2009-09-19 21:48:32 | BUG #5067: vacuum problem |
Previous Message | Tom Lane | 2009-09-19 19:53:41 | Re: BUG #5066: plperl issues with perl_destruct() and END blocks |