Re: CHECK constraint on multiple tables - Mailing list pgsql-sql

From Thomas Kellerer
Subject Re: CHECK constraint on multiple tables
Date
Msg-id h8lsrk$g9g$1@ger.gmane.org
Whole thread Raw
In response to Re: CHECK constraint on multiple tables  (Mario Splivalo <mario.splivalo@megafon.hr>)
List 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
ORmapper expects. That would enable you to have a proper unique check on the base table, and you OR mapper still sees
twotables that it can update.
 

Thomas



pgsql-sql by date:

Previous
From: Mario Splivalo
Date:
Subject: Re: CHECK constraint on multiple tables
Next
From: wstrzalka
Date:
Subject: ordered by join? ranked aggregate? how to?