Thread: Is it possible to defer triggers?

Is it possible to defer triggers?

From
Torsten Knodt
Date:
-----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-----



Re: Is it possible to defer triggers?

From
"Frank Contrepois"
Date:
read this:
http://www.postgresql.org/idocs/index.php?sql-createtrigger.html

bye
--
--

"L'idea di base � estremamente semplice..."
�opyright Frank "Pazzooo" Contrepois (schiavista francese del '900)