check foreign constraints before delete

Поиск
Список
Период
Сортировка
От Robert Wimmer
Тема check foreign constraints before delete
Дата
Msg-id BAY109-F12955AB36E2BB06F87D1D5D0940@phx.gbl
обсуждение исходный текст
Ответы Re: check foreign constraints before delete
Список pgsql-interfaces
hi,

i want to write a function in plpgsql, which checks a foreign key constraint 
violation on deleting  a special value in my table. for example

CREATE TABLE to (n NAME PRIMARY KEY);
CREATE TABLE t1 (n_name NAME REFERENCES to(n), id INTEGER ...);

CREATE FUNCTION check_before_delete(..some value ...) RETURNS INTEGER AS '
.. IF foreign_key_violation THEN RETURN -1 END IF; RETURN 0;
..
END;
...

so i can avoid the database errormessages.

i checked some 'd'  commands with the 'E' option. but i have no idea for a 
smart solution of this problem

thanx in advance (tom?)

sepp




В списке pgsql-interfaces по дате отправления:

Предыдущее
От: Michael Fuhr
Дата:
Сообщение: Re: finding indexed functions from pg_index
Следующее
От: Michael Fuhr
Дата:
Сообщение: Re: check foreign constraints before delete