Re: How to union tables and have a field with UNIQUE constraint? - Mailing list pgsql-sql

From Tom Lane
Subject Re: How to union tables and have a field with UNIQUE constraint?
Date
Msg-id 1002.1010100401@sss.pgh.pa.us
Whole thread Raw
In response to Re: How to union tables and have a field with UNIQUE constraint?  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List pgsql-sql
Stephan Szabo <sszabo@megazone23.bigpanda.com> writes:
>> Since triggers on a view won't do anything either, I don't see how one
>> could expect REFERENCES to a view to work.  The system ought to reject
>> all this stuff as unimplemented.

> I think that the insert/update on the fk table will work, but yeah, the
> parts on the pk table won't, so that's no good.  I wouldn't want to
> bother for 7.2, but putting in something to make it so you can't reference
> a view is probably a good idea, at least until we can work out a way
> to make constraints on views work.

Investigation showed that there were a couple of other utility
statements that were also missing adequate checks on permissions and
table type.  I've applied patches.
        regards, tom lane


pgsql-sql by date:

Previous
From: Richard Rowell
Date:
Subject: top?
Next
From: Stephan Szabo
Date:
Subject: Re: top?