FAQ

Probably the correct way to handle this is to run the foreign key
constraint trigger as the user who created the constraint (or
something like that) rather than the user making the insert. I'm not
sure how hard that would be.
The problem is that now using both refint and GRANT/REVOKE will not work
together. Only if I have separate areas of tables, I can assure that each
user may work on his own area. But most databases have referencing tables
which parent table is read-only for the simple users and child tables are
read-write for them. My opinion is that it is neccessary to allow such
referencing. If Postgres doesn't support this, almost nobody can use
refint and ACLs together. Performance is also important, I do know...

Regards,
Zoltan

Search Discussions

Discussion Posts

Previous

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 2 of 2 | next ›
Discussion Overview
grouppgsql-hackers @
categoriespostgresql
postedJun 22, '00 at 8:44p
activeJun 24, '00 at 11:38a
posts2
users1
websitepostgresql.org...
irc#postgresql

1 user in discussion

Kovacs Zoltan Sandor: 2 posts

People

Translate

site design / logo © 2021 Grokbase