Re: CHECK constraint on multiple tables

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: CHECK constraint on multiple tables
Date: 2009-09-14 17:00:37
Message-ID: h8lsrk$g9g$1@ger.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Mario Splivalo wrote on 14.09.2009 16:20:
>> Have you considered refactoring so there's only one table?
>
> Unfortunately I can't do that, due to the
> object-relational-mapper-wrapper-mambo-jumbo.
>
You could still refactor that into one single table, then create two updateable views with the names that the dreaded OR mapper expects. That would enable you to have a proper unique check on the base table, and you OR mapper still sees two tables that it can update.

Thomas

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message A. Kretschmer 2009-09-15 07:49:57 Re: ordered by join? ranked aggregate? how to?
Previous Message wstrzalka 2009-09-14 14:25:33 ordered by join? ranked aggregate? how to?