On 4/29/07, Rich Shepard <rshepard@xxxxxxxxxxxxxxx> wrote:
I cannot find a discussion of the meaning and use of Declarative Referential Integrity (DRI) in the on-line docs ToC or Index. Please tell me in which chapter/section this is covered.
The closest counterpart to MS SQL Server's DRI is the "references" permission: http://www.postgresql.org/docs/8.2/interactive/sql-grant.html Note, however, that PostgreSQL doesn't have column-level permissions, so this is by table only:
Currently, PostgreSQL does not support granting or revoking privileges for individual columns of a table. One possible workaround is to create a view having just the desired columns and then grant privileges to that view.
Alexander.
