Re: notice on explicit primary key or index name - Mailing list pgsql-bugs

From Tom Lane
Subject Re: notice on explicit primary key or index name
Date
Msg-id 6531.1253398825@sss.pgh.pa.us
Whole thread Raw
In response to notice on explicit primary key or index name  (Tomas Psika <tomas.psika@gmail.com>)
List pgsql-bugs
Tomas Psika <tomas.psika@gmail.com> writes:
> when primary key or unique index is created using explicit name, strange
> notice will say that implicit name was generated. But it didnt.

> # 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"

The index is what's implicit, not the name.

            regards, tom lane

pgsql-bugs by date:

Previous
From: "Pasquale"
Date:
Subject: BUG #5067: vacuum problem
Next
From: Tom Lane
Date:
Subject: Re: BUG #5067: vacuum problem