Re: Asserting existing key to be primary

From: "Merlin Moncure" <merlin(dot)moncure(at)rcsonline(dot)com>
To: "Chris Browne" <cbbrowne(at)acm(dot)org>
Cc: <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Asserting existing key to be primary
Date: 2004-08-13 17:28:44
Message-ID: 6EE64EF3AB31D5448D0007DD34EEB3412A7459@Herge.rcsinc.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> Is there a way to do that without too much (mwahahhaha! fiddling with
> pg_class!!!) trickery?

esp=# alter table test add primary key(id);
NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index
"test_pkey" for table "test"
ALTER TABLE

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2004-08-13 17:53:16 Re: Postgres development model (was Re: CVS comment)
Previous Message Manfred Spraul 2004-08-13 17:20:15 Re: hot spare / log shipping work on