In the CLUSTER description it says:
"The table is actually copied to a temporary table in index order, then
renamed back to the original name. For this reason, all grant permissions
and other indexes are lost when clustering is performed."
It sure seems to me that rules would get lost along the way with this as
well (when the original table is dropped). There is no real work around
other than recreating the rules.
-Peter
On Mon, 25 Oct 1999, Jacques B. Dimanche wrote:
> Hello There,
>
> I noticed that if I have rules set on a table and if I do a cluster
> index-name on the table, it deletes all the rules. Is this normal? I am
> just wondering as I would like to cluster the data occasionally. I am not
> sure if this is a bug, or it is supposed to drop all the rules. If the
> latter is the case, are there any other operations that would drop the rules?
>
>
> Sincerely Yours,
>
> Jacques Dimanche
> VP of Research and Development
> Tridel Technologies, Inc.
>
> ************
>
>
--
Peter Eisentraut Sernanders vaeg 10:115
[EMAIL PROTECTED] 75262 Uppsala
http://yi.org/peter-e/ Sweden
************
