Is it possible to defer triggers?

Поиск
Список
Период
Сортировка
От Torsten Knodt
Тема Is it possible to defer triggers?
Дата
Msg-id 01052712574700.02459@tk-wkst-1
обсуждение исходный текст
Список pgsql-sql
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hello,
is it possible to defer the execution of a after-trigger?
To explain it exactly.
I am logging from apache to postgres via insert-commands. I'd like to 
generate online-statistics in other tables. For this I want to execute a 
trigger when something is inserted into the access_log-table, but without 
slowing down the insert's to much.

WKR Torsten Knodt
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.4 (GNU/Linux)
Comment: For info see http://www.gnupg.org

iD8DBQE7EN2uvxZktkzSmiwRAmJUAJwNDEiZMYaogiEbp6yJxWArbLxxrgCfeVM4
MEaxCRZMTNqnGj06nD/K93Q=
=uHyJ
-----END PGP SIGNATURE-----



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: corrupted tables !!!
Следующее
От: "Michael Richards"
Дата:
Сообщение: Left Joins...