Re: unique across two tables - Mailing list pgsql-general

From David Johnston
Subject Re: unique across two tables
Date
Msg-id 026301cc30f9$b341ddd0$19c59970$@yahoo.com
Whole thread Raw
In response to Re: unique across two tables  (Merlin Moncure <mmoncure@gmail.com>)
Responses Re: unique across two tables
Re: unique across two tables
List pgsql-general
> 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.



pgsql-general by date:

Previous
From: Rob Sargent
Date:
Subject: Re: building 9.1 on suse-11.4 (64bit)
Next
From: Grzegorz Jaśkiewicz
Date:
Subject: Re: data compression in protocol?