Bug #867: CLUSTER does not rebuild referential integrity triggers

Boris Folgmann (boris@folgmann.de) 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
badthing 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