DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:in-reply-to:references:date:message-id:subject:from:to
	:cc:content-type:content-transfer-encoding;
	b=aUBYHgaTSrbURGjNhj3kthGI+WZi0XJVCKA8oEa57QMlsOnc3D/ebDb/D0C2nlwjQs
	a/YnmugVQoGNbqLxPt8MV+AgWn7Aj/Z0Yr9yYXOgFsyMPUXi4Gi5Z7ng10J1tTKi0xL/
	+RzzdkybhkYPoY0EsKP3oAud2w+mQM/XBN1I8=
MIME-Version: 1.0
In-Reply-To: <87hbqo11yg.fsf@kolob.sebmags.homelinux.org>
References: <87hbqo11yg.fsf@kolob.sebmags.homelinux.org>
Date: Fri, 15 Jan 2010 12:34:15 +0900
Message-ID: <1d581afe1001141934x2c525992w2e4bcf40a3113207@mail.gmail.com>
Subject: Re: rename primary key
From: Ian Barwick <barwick@gmail.com>
To: Seb <spluque@gmail.com>
Cc: pgsql-sql@postgresql.org
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

2010/1/15 Seb <spluque@gmail.com>:
> Hi,
>
> Is it possible to rename a primary key? =C2=A0I learnt that to rename for=
eign
> keys one has to drop it and recreate with the new name, or add a new new
> and drop the old one. =C2=A0What is the approach for primary keys? =C2=A0=
Thanks.

Is this what you mean?


psql (8.4.2)
You are now connected to database "test".
test=3D# CREATE TABLE foo (id serial primary key);
NOTICE:  CREATE TABLE will create implicit sequence "foo_id_seq" for
serial column "foo.id"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
"foo_pkey" for table "foo"
CREATE TABLE
test=3D# \d foo
                         Table "public.foo"
 Column |  Type   |                    Modifiers
--------+---------+--------------------------------------------------
 id     | integer | not null default nextval('foo_id_seq'::regclass)
Indexes:
    "foo_pkey" PRIMARY KEY, btree (id)

test=3D# ALTER INDEX foo_pkey RENAME to bar_fkey;
ALTER INDEX
test=3D# \d foo
                         Table "public.foo"
 Column |  Type   |                    Modifiers
--------+---------+--------------------------------------------------
 id     | integer | not null default nextval('foo_id_seq'::regclass)
Indexes:
    "bar_fkey" PRIMARY KEY, btree (id)

test=3D#


Ian Barwick