From: Donald Jackson <jackson@cvrc-taco.mgh.harvard.edu>
To: pgsql-interfaces@postgresql.org
To: pgsql-sql@postgresql.org
Subject: problems working with refint functions
Date: Mon, 21 Jun 1999 12:31:19 -0400
Message-ID: <376E68D7.587475D3@cvrc.mgh.harvard.edu> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: jackson@cvrc-taco.mgh.harvard.edu, pgsql-sql@postgresql.org
Subject: Re: problems working with refint functions
In-Reply-To: <376E68D7.587475D3@cvrc.mgh.harvard.edu>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox