Re: Create Primary Key?

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: "D'Arcy J(dot)M(dot) Cain" <darcy(at)druid(dot)net>
Cc: Webb Sprague <wsprague100(at)yahoo(dot)com>, pgsql-sql(at)postgresql(dot)org
Subject: Re: Create Primary Key?
Date: 2000-08-30 14:52:07
Message-ID: Pine.BSF.4.10.10008300743050.60082-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


On Wed, 30 Aug 2000, D'Arcy J.M. Cain wrote:

> Thus spake Stephan Szabo
> > We don't currently support the SQL syntax for adding
> > a PK to a table. However, if you have the columns
> > as NOT NULL already, adding a unique index to the
> > columns in question has the same general effect.
>
> Except for interfaces such as PyGreSQL that recognize the primary key
> and use it.

True. You'd have to see what it was doing to determine the primary key
and try to do the same things.

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Normunds 2000-08-30 15:54:51 function
Previous Message D'Arcy J.M. Cain 2000-08-30 11:42:48 Re: Create Primary Key?