Boris Folgmann ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is.
Short Description CLUSTER does not rebuild referential integrity triggers Long Description I've got the following behaviour using pgsql 7.2.2 on Linux: When clustering a table with CLUSTER I get NOTICE: DROP TABLE implicitly drops referential integrity trigger from table .... for every RI_ConstraintTrigger. The bad thing is that the Trigger is not being reconstructed when the CLUSTER is finished. Sample Code \d table_with_ri_triggers cluster some_index on table_with_ri_triggers \d table_with_ri_triggers -> see that ri_triggers are vanished. No file was uploaded with this report ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html