question on renaming a foreign key

Поиск
Список
Период
Сортировка
От Jonathan Vanasco
Тема question on renaming a foreign key
Дата
Msg-id 05248EA4-C1AA-45BE-A203-FB87CA94C2B8@2xlp.com
обсуждение исходный текст
Ответ на Re: Newbie question about importing text files...  (Scott Marlowe <smarlowe@g2switchworks.com>)
Ответы Re: question on renaming a foreign key  (Richard Broersma Jr <rabroersma@yahoo.com>)
Re: question on renaming a foreign key  (Brent Wood <b.wood@niwa.co.nz>)
Список 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 ?



В списке pgsql-general по дате отправления:

Предыдущее
От: Scott Marlowe
Дата:
Сообщение: Re: Newbie question about importing text files...
Следующее
От: Jeff Davis
Дата:
Сообщение: Re: Is it possible to return custom type as proper ROW?