> yeah -- postgresql table inheritance [...] underpins the table inheritance feature [...] Thank you Master of the Obvious ;) I do think you meant to say it underpins the "Table Partitioning Feature" which, through the use of INSERT triggers to at least propagate the inserts to the proper tables, it indeed does. The only (obvious to me) way to really solve the problem - invisibly - is to allow for table-less unique indexes that multiple tables can share and that have a pointer to the "source" table for any particular entry in the index. The other method being discussed effectively uses a physical table to implement this behavior. David J. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general