It would also be reasonable to allow clustering individual partitions;
creating table or column constraints on some partitions and not others;

I have a session mamagement which works like that, using views now. is a table of the online sessions. It has a UNIQUE on user_id.
sessions.archive contains all the closed sessions. Obviously it does not have a UNIQUE on user_id.

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
     subscribe-nomail command to [EMAIL PROTECTED] so that your
     message can get through to the mailing list cleanly

Reply via email to