triggers (refint) - Mailing list pgsql-sql

From Werner Reisberger
Subject triggers (refint)
Date
Msg-id 19990221183810.C273@tribe.free.de
Whole thread Raw
List pgsql-sql
Trying to use the function check_primary_key with the examples provided
in postresql 6.3.1 I am getting the error message

  "fmgr_info: function 157189: cache lookup failed"

Apart from this problem I would like to extend the function of
check_foreign_key to delete the whole row instead of only the foreign_key.

I think it's possible to write a second trigger function which will delete
the whole row if the foreign_key field is null. Or do I need to customize
the refint source?

Werner

pgsql-sql by date:

Previous
From: "D'Arcy" "J.M." Cain
Date:
Subject: Re: [HACKERS] Re: [SQL] SQL-Query 2 get primary key
Next
From: Tom Lane
Date:
Subject: Re: questions on interpreting the output of explain