Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

Re: DRI in Docs?



On 4/29/07, Rich Shepard <rshepard(at)appl-ecosys(dot)com> 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.



Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group