Re: unique across two tables

> 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.