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 <[EMAIL PROTECTED]> URL: http://www.toodarkpark.org "The distance between insanity and genius is measured only by success."
