On Wed, 01 Oct 2008 08:32:16 -0600 Bill Thoen <bthoen@xxxxxxxxxx> wrote: > CREATE TABLE farm2 (LIKE farms); > INSERT INTO farm2 (farm_id, fips_cd, farm_nbr, prog_year) SELECT > farm_id, fips_cd, farm_nbr, '2007' FROM farms; > DROP TABLE farms; > ALTER TABLE farm2 RENAME TO farms; > CREATE UNIQUE INDEX farms_id_key ON farms(farm_id); > CREATE UNIQUE INDEX farms_fips_nbr_key ON farms(fips_cd,farm_nbr); Is this kind of stuff going to affect any reference to the farm table? eg. inside functions, triggers etc? what if: create table farm_rel ( farm_id [sometype] references farm(farm_id) on delete cascade, ... ); and I alter table farm rename to farm_t; alter table farm2 rename to farm; drop table farm_t; or similar situations... where could I incur in troubles using RENAME (for tables, columns etc...)? thanks -- Ivan Sergio Borgonovo http://www.webthatworks.it
