Thread: Bug #557: triggers tablename are not rename if table are renamed.
Bug #557: triggers tablename are not rename if table are renamed.
From
pgsql-bugs@postgresql.org
Date:
Søren laursen (soeren.laursen@scrooge.dk) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description triggers tablename are not rename if table are renamed. Long Description I had a database where I during development created a new table to test a new design. On this table postgresql automaticcreated triggers because it used foreign keys. After the test went ok, I rename the table to it "production name". During al test went ok - apparently. But today during a update run (Importing data via XML) I got complains about missing Relations where to old table name wasissued. I did a dump at (pg_dump) and looked at it and in the end I found that the triggers for example: CREATE CONSTRAINT TRIGGER "<unnamed>" AFTER INSERT OR UPDATE ON "alternativhold" NOT DEFERRABLE INITIALLY IMMEDIATE FOREACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('<unnamed>', 'nyalternativhold', 'hold', 'UNSPECIFIED', 'holdnr', 'holdnr'); contains a reference to the old table name nyalternativhold. I deleted the 3 triggers and the systems runs again. Best regards Søren, Sample Code No file was uploaded with this report
pgsql-bugs@postgresql.org writes: > triggers tablename are not rename if table are renamed. 7.2 does this correctly. regards, tom lane