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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
