On Wed, 4 Aug 1999, Ramanika wrote:
> I did not see this in the documentation anywhere. Does postgresql
> support referential integrity? like when creating a table REFERENCES
> table(column_id)?
not directly, no. at least not yet :) 6.6 is rumoured to have full
support.
for now you can use refint ( $PGSQL_SRC_ROOT/contrib/spi/refint.* ), which
handles referential integrity. check_primary_key() and
check_foreign_key() are the two functions involved. youd also need two
triggers, one per table.
i could've sworn this got added to the FAQ...
---
Howie <caffeine@toodarkpark.org> URL: http://www.toodarkpark.org
"The distance between insanity and genius is measured only by success."