> 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. ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
