Re: Postgres Permissions Article
От | Paul Jungwirth |
---|---|
Тема | Re: Postgres Permissions Article |
Дата | |
Msg-id | c95aaecb-c3b8-b085-0b34-99d1f22332f1@illuminatedcomputing.com обсуждение исходный текст |
Ответ на | Re: Postgres Permissions Article ("Peter J. Holzer" <hjp-pgsql@hjp.at>) |
Список | pgsql-general |
> Also I don't understand why you wrote “You need the permission on both > tables”: Only the owner of a table can add constraints to it Ah, this piece was really helpful for me in making it click. Thanks so much! I added a couple new paragraphs to my post with a link back to this thread. I feel like it all makes sense now! :-) FYI "You need this permission on both tables" is what the docs say (https://www.postgresql.org/docs/9.6/static/sql-grant.html): > To create a foreign key constraint, it is necessary to have this privilege on both the referencing and referenced columns. Maybe it would be worth clarifying there that you need to *own* the referencing table, and you need REFERENCES on the referenced table? In any case, thanks again to you all for your help figuring this out! Paul
В списке pgsql-general по дате отправления: