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

Reply via email to