Triggers in postgres

Поиск
Список
Период
Сортировка
Искать
От
Rob
Тема
Triggers in postgres
Дата
Msg-id
Pine.LNX.4.33L2.0203191140010.7143-100000@Genesis
Список
Дерево обсуждения
Triggers in postgres Rob <rob@obsidian.co.za>
Re: Triggers in postgres Oliver Elphick <olly@lfix.co.uk>
Hi,

I have a product table with a column barcode.  After a product has been
deleted, I want to create a trigger to delete references to that product
in other tables.  I've got the following trigger

CREATE TRIGGER
AFTER DELETE
ON TABLE product
FOR EACH ROW

Now, what I would ideally like to do is issue a simple sql delete command,
but I think I actually have to define a function (is this true?).  Say I
do, then the rest of my trigger would look like

EXECUTE PROCEDURE someProc();

Now I need to pass somProc the barcode of the product I've just deleted.
How do I do this?

Thanks

Rob

-- 
He who dies with the most toys ...

					... still dies


В списке pgsql-novice по дате отправления
От: Bai Yan
Дата:
Сообщение: rename a table name
От: Henshall, Stuart - WCP
Дата:
Сообщение: Re: rename a table name
FAQ