Sender: jackson@cvrc-taco.mgh.harvard.edu
Message-ID: <376E68D7.587475D3@cvrc.mgh.harvard.edu>
Date: Mon, 21 Jun 1999 12:31:19 -0400
From: Donald Jackson <jackson@cvrc-taco.mgh.harvard.edu>
Organization: Fishman Lab, Massachusetts General Hospital
MIME-Version: 1.0
To: pgsql-interfaces@postgresql.org, pgsql-sql@postgresql.org
Subject: problems working with refint functions
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Hi,

I have been trying to set up foreign and primary key constraints for my
database using the refint package in postgres 6.5.  I compiled the
funcions in the contrib/spi directory (just did a 'make all'), then ran
the refint.source commands to declare the primary functions. This all
went ok, no error messages were generated.

I have declared the various triggers as  needed, using the
check_foreign_key and check_primary_key functions from refint.  When I
try to perform a function using these triggers, I get the following
error message:

(prelude: allele_id is the primary key and is referenced as a foreign
key by other tables/triggers)

fish_db=> delete from alleles where allele_id = '2';
ERROR:  fmgr_info: function 190689: cache lookup failed

I also run into problems when I dump the database:
[jackson@cvrc-manta dumps]$ pg_dump fish_db
getTables(): relation 'alleles': cannot find function with oid 190689
for trigger alleles_t

Finally, I don't see the functions check_primary_key and
check_foreign_key when I do a function list with \df.

So I think I didn't install them properly, but have no clue as to what
else should be done.  Do I need to modify the declarations in
refint.source?  Help!

Don Jackson