Any plans on allowing user-defined triggers to be deferrable?

Поиск
Список
Период
Сортировка
Искать
От
Mike Mascari
Тема
Any plans on allowing user-defined triggers to be deferrable?
Дата
Msg-id
417E4959.5080203@mascari.com
Список
Дерево обсуждения
Any plans on allowing user-defined triggers to be deferrable? Mike Mascari <mascarm@mascari.com>
Re: Any plans on allowing user-defined triggers to be Valentin Militaru <valentin.militaru@telcor.ro>
Re: Any plans on allowing user-defined triggers to be deferrable? Mike Mascari <mascarm@mascari.com>
Re: Any plans on allowing user-defined triggers to Valentin Militaru <valentin.militaru@telcor.ro>
Re: Any plans on allowing user-defined triggers to be Stephan Szabo <sszabo@megazone.bigpanda.com>
Re: Any plans on allowing user-defined triggers to be deferrable? Mike Mascari <mascarm@mascari.com>
Re: Any plans on allowing user-defined triggers to be Stephan Szabo <sszabo@megazone.bigpanda.com>
Re: Any plans on allowing user-defined triggers to be Stephan Szabo <sszabo@megazone.bigpanda.com>
I'd like to ensure that the creation of a department also implies the 
creation of two to eight projects; no more, no less:

CREATE TABLE departments (
  department text primary key not null
);

CREATE TABLE projects (
project text primary key not null,
department text not null
  references departments(department)
  on delete cascade
  on update cascade
);

So it'd be nice to have an INSERT trigger that's fired on departments at 
the end of the transaction to ensure that between two and eight projects 
exist for the newly created department.

Is there no way to achieve the above stated goal in the server? Must I 
rely on the application to enforce consistency?

Mike Mascari


В списке pgsql-general по дате отправления
От: Tino Wildenhain
Дата:
От: Mike Mascari
Дата:
FAQ