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

Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)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