Обсуждение: Bug #911: pg_dump/pg_restore fails when using triggers/rules on tables including large objects

Joseph Tate (jtate@mi-corporation.com) reports a bug with a severity of 2
The lower the number the more severe it is.

Short Description
pg_dump/pg_restore fails when using triggers/rules on tables including large objects

Long Description
If a table has a large object referenced in a column, but also has a rule/trigger that fires on an update of that
column,the trigger/rule will fire when the OIDs are being "fixed up".  Triggers and rules should be disabled before
fixingOID cross references.
 

This is where the error occurs
"pg_restore: fixing up large object cross-reference for session_data
pg_restore: fixing large object cross-references for session_data.rendered_ink"
The rule on the session_data table then fires and when it fails, it aborts the restore process, leaving the database in
anonly partially usable state.
 

FYI I'm using the 7.2 version of pg_dump and pg_restore.  If this has been fixed, I apologize for the mail.

Sample Code


No file was uploaded with this report