check foreign constraints before delete
От
Robert Wimmer
Тема
check foreign constraints before delete
Дата
Msg-id
BAY109-F12955AB36E2BB06F87D1D5D0940@phx.gbl
Список
Дерево обсуждения
check foreign constraints before delete "Robert Wimmer" <seppwimmer@hotmail.com>
Re: check foreign constraints before delete Michael Fuhr <mike@fuhr.org>
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 по дате отправления