From: | Bruce Momjian <bruce(at)momjian(dot)us> |
---|---|
To: | "Raymond O'Donnell" <rod(at)iol(dot)ie> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: ALTER TABLE RENAME and primary key |
Date: | 2006-12-13 23:59:26 |
Message-ID: | 200612132359.kBDNxRm00278@momjian.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Raymond O'Donnell wrote:
> On 9 Dec 2006 at 18:22, brian wrote:
>
> > I'd like to rename a table but am unsure how this will affect the
> > primary key. That is, the table currently being named 'service', it has a
> > pkey named 'service_id_pkey'. I'd like to change the table name to
> > 'service_provider' (which would mean i'd get 'service_provider_id_pkey').
>
> I just tried it on 8.2, and it seems that renaming the table doesn't
> rename the primary key index - you have to do it explicitely.
>
> > There's a second table that has a foreign key constraint on
> > service_id_pkey, so do i need to drop that constraint first, rename the
> > first table, then re-create the constraint using the new pkey name?
>
> Without having tried it, I don't think so - my understanding is that
> database objects are represented internally as OIDs, so renaming the
> object changes only the name and not the OID.
We worked very hard to prevent renaming from affecting the behavior of
any objects.
--
Bruce Momjian bruce(at)momjian(dot)us
EnterpriseDB http://www.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
From | Date | Subject | |
---|---|---|---|
Next Message | Manuel Sugawara | 2006-12-14 00:32:03 | Re: Slow query in 8.2.0 |
Previous Message | Tom Lane | 2006-12-13 23:52:33 | Re: Slow query in 8.2.0 |