On 07/31/2014 01:16 PM, Marti Raudsepp wrote:
> On Thu, Jul 31, 2014 at 9:38 PM, Kynn Jones <kynnjo(at)gmail(dot)com> wrote:
>> Does PostgreSQL have a good way to enforce the uniqueness of super_id values
>> across multiple tables?
> Well that's easy: no.
>
> Regards,
> Marti
>
>
That might be a little hasty. There are conditional definitions clauses
in indices. One could apply a check such that all subs don't have the
id or on each sub such that the others don't have the id. But can be
made unnecessary if inserts to all subs work off same id generator.
rjs