Dear Postgres Team,
I am still working away at fixing my database. I have decided to drop of
out of date check_foriegn_key function, and
move to the new FOREIGN KEY.
I am having a little trouble converting triggers to make use of the new
function, and wondered if someone could give me an example.
Taking the trigger;
CREATE TRIGGER check_user
BEFORE DELETE ON genUser
FOR EACH ROW EXECUTE PROCEDURE
how would I correct it to make use of the new Foreign Key function?
I understand that this may be a simple question, but converting a non
backedup database when still learning Sql can be a scary thing!!!
Any help appreciated.
pgsql-novice by date
|Next:||From: Bill Howell||Date: 2001-03-19 15:18:28|
|Subject: Sorry, too many clients already|
|Previous:||From: Vijay Deval||Date: 2001-03-19 03:34:12|
|Subject: Re: Help with a query, please|