Re: [GENERAL] ALTER TABLE RENAME and primary key

2006-12-13 Thread Bruce Momjian
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

Re: [GENERAL] ALTER TABLE RENAME and primary key

2006-12-09 Thread Raymond O'Donnell
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

[GENERAL] ALTER TABLE RENAME and primary key

2006-12-09 Thread brian
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'). There's a sec