Re: Some newbie question

From: Jeff Davis <pgsql(at)j-davis(dot)com>
To: Ritesh Nadhani <riteshn(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Some newbie question
Date: 2006-10-20 00:26:04
Message-ID: 1161303965.8476.35.camel@dogma.v10.wvs
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message John D. Burger 2006-10-20 01:31:22 SQL function inlining
Previous Message Tom Lane 2006-10-20 00:20:33 Re: VACUUM and open transactions