Why lost all foreign key constraits after cluster?

From: Raymond Chui <raymond(dot)chui(at)noaa(dot)gov>
To: pgsql-general(at)postgresql(dot)org(dot)pgsql-sql(at)postgresql(dot)org
Subject: Why lost all foreign key constraits after cluster?
Date: 2001-07-11 12:04:37
Message-ID: 3B4C40D5.56FB2B1F@noaa.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 Content-Type Size
raymond.chui.vcf text/x-vcard 414 bytes

Browse pgsql-sql by date

  From Date Subject
Next Message Jan Wieck 2001-07-11 12:36:09 Re: can we write to a flat file from Postgresql procedure
Previous Message rocael 2001-07-11 09:39:48 File system level backup