Stephan Szabo writes:
> With that, I do have a general question though. Are referential actions
> supposed to be limited by the permissions of the user executing the query?
> So, if you for example have write access on the pk table, but not to the
> fk table, and there is a on cascade delete relationship, should that user
> not be able to delete from the pk table?
Then you could delete records that are not in relation to the foreign keys
in your table. So I suppose not. Of course there does seem to be a very
limited range of usefulness of such a setup, but we shouldn't extrapolate
something potentially more useful from that.
--
Peter Eisentraut peter_e@gmx.net http://yi.org/peter-e/