problems working with refint functions
От | Donald Jackson |
---|---|
Тема | problems working with refint functions |
Дата | |
Msg-id | 376E68D7.587475D3@cvrc.mgh.harvard.edu обсуждение исходный текст |
Список | pgsql-sql |
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
В списке pgsql-sql по дате отправления: