notice on explicit primary key or index name

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

Responses

Browse pgsql-bugs by date

  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