Postgres Pro
Downloads
Home   >   mailing lists

Re: question on renaming a foreign key - Mailing list pgsql-general

From Richard Broersma Jr
Subject Re: question on renaming a foreign key
Date
Msg-id 20061011211038.82944.qmail@web31810.mail.mud.yahoo.com
Whole thread Raw
In response to question on renaming a foreign key  (Jonathan Vanasco <postgres@2xlp.com>)
Responses Re: question on renaming a foreign key  (Ron Johnson <ron.l.johnson@cox.net>)
List pgsql-general
Tree view 
> I made a  HUGE mistake, and used 'UK' as the abbreviation for the
> united kingdom ( the ISO abbv is 'GB' )
>
> I've got a database where 8 tables have an FKEY on a table
> 'location_country' , using the text 'uk' as the value -- so i've got
> 9 tables that I need to swap data out on
>
> can anyone suggest a non-nightmarish way for me to do this ?

If your tables are setup to "ON UPDATE CASCASE" then you are fine.

Just updated the main table and PostgreSQL will take care of the rest.

http://www.postgresql.org/docs/8.1/interactive/sql-createtable.html

Regards,

Richard Broersma Jr.

pgsql-general by date:

Previous
From: Jeff Davis
Date:
Subject: Re: Is it possible to return custom type as proper ROW?
Next
From: "Merlin Moncure"
Date:
Subject: strange error when inserting via a SRF into a table with a foreign key constraint