Re: Some newbie question - Mailing list pgsql-general

From Jeff Davis
Subject Re: Some newbie question
Date
Msg-id 1161303965.8476.35.camel@dogma.v10.wvs
Whole thread Raw
In response to Re: Some newbie question  (Ritesh Nadhani <riteshn@gmail.com>)
List pgsql-general
On Thu, 2006-10-19 at 19:05 -0500, Ritesh Nadhani wrote:
> Thanks.
>
> So the implicit value means that PG gave it a name?
>

Right, when you declare a column to be a primary key, PostgreSQL must
create an index to enforce the unique constraint. This index must have
some kind of name, so PostgreSQL makes up a name, and the NOTICE is just
to let you know the name of the index that it's creating.

Regards,
    Jeff Davis


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: VACUUM and open transactions
Next
From: "John D. Burger"
Date:
Subject: SQL function inlining