On Sun, 29 Apr 2007, Alexander Staubo wrote:
> We could be talking about different things, though. What Joe Celko is
> probably talking about is referential integrity as defined in a schema
> using foreign keys, as opposed to, say, triggers. Eg.,
Alexander,
I think you are correct. So much of his references are to MS SQL Server
that his use of DRI is probably in that context.
> PostgreSQL supports the ANSI SQL syntax for declaring foreign keys.
Yup. Used 'em for years.
Thanks,
Rich
--
Richard B. Shepard, Ph.D. | The Environmental Permitting
Applied Ecosystem Services, Inc. | Accelerator(TM)
<http://www.appl-ecosys.com> Voice: 503-667-4517 Fax: 503-667-8863