question on renaming a foreign key

From: Jonathan Vanasco <postgres(at)2xlp(dot)com>
To: pgsql general <pgsql-general(at)postgresql(dot)org>
Subject: question on renaming a foreign key
Date: 2006-10-11 20:53:53
Message-ID: 05248EA4-C1AA-45BE-A203-FB87CA94C2B8@2xlp.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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 ?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jeff Davis 2006-10-11 21:02:08 Re: Is it possible to return custom type as proper ROW?
Previous Message Scott Marlowe 2006-10-11 20:29:58 Re: Newbie question about importing text files...