Author: wikipedia

Description:
When restoring a dump of wikipedia into PostgreSQL with mwdump, the first lines are :

ALTER TABLE revision DISABLE TRIGGER ALL;ALTER TABLE page DISABLE TRIGGER ALL;;

this will result in :

ERROR: permission denied: "RI_ConstraintTrigger_XXXXX" is a system trigger
ERROR: permission denied: "RI_ConstraintTrigger_XXXXX" is a system trigger

because some triggers are managed by the database server itself and cannot be disabled by any one, except the super user. However there is a way [1] to delay the constraints applications in order to load a whole bunch of data in the database and do not need to be super-user :

At the beggining : SET CONSTRAINTS ALL DEFERRED
At the end : SET CONSTRAINTS ALL IMMEDIATE

[1] http://kopongo.com/2008/7/25/postgres-ri_constrainttrigger-error

Version: unspecified
Severity: normal