Why lost all foreign key constraits after cluster? - Mailing list pgsql-sql

From Raymond Chui
Subject Why lost all foreign key constraits after cluster?
Date
Msg-id 3B4C40D5.56FB2B1F@noaa.gov
Whole thread Raw
List pgsql-sql
After I performed

cluster indexname on tablename;

All the foreign key constraints are lost on that table, why is that?
I get messages like

NOTICE: DROP TABLE implicitly drops referential integrity
trigger from table "tablename"

during cluster

I don't want to lost the foreign key constraints on the table. How do I
prevent
that? Thank you!


--Raymond


Attachment

pgsql-sql by date:

Previous
From: "Alexey V. Neyman"
Date:
Subject: No subselects in constraint (bug?)
Next
From: Tod McQuillin
Date:
Subject: Re: Select distinct and order by.