Upgrade to 7.3. Cluster has been redesigned to be much more user friendly -- not to mention transaction safe.
On Wed, 2003-01-08 at 15:21, [EMAIL PROTECTED] wrote: > 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 -- Rod Taylor <[EMAIL PROTECTED]> PGP Key: http://www.rbt.ca/rbtpub.asc
signature.asc
Description: This is a digitally signed message part
