On 07/31/2014 01:16 PM, Marti Raudsepp wrote:
On Thu, Jul 31, 2014 at 9:38 PM, Kynn Jones <kynnjo@gmail.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
