Re: adding primary keys

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: jason <jpoley(at)poley(dot)net>
Cc: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: adding primary keys
Date: 2001-12-06 16:06:14
Message-ID: 20011206080353.E25449-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On 3 Dec 2001, jason wrote:

> how come you can not alter a table and add a primary key after the
> table has been created?

Because it wasn't implemented for that constraint type ;) (I
think it'll work in at least some cases for 7.2)?

> any suggestions?

Check the archives for 7.1 and earlier workarounds, it's come
up fairly recently.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Stephan Szabo 2001-12-06 16:08:02 Re: duplicate templates, wrong users
Previous Message Andy Gussie 2001-12-06 14:32:12 Vacuum Fails