Re: How to union tables and have a field with UNIQUE constraint?

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