From: Torsten Knodt <torstenknodt@datas-world.de>
To: pgsql-sql@postgresql.org
Subject: Is it possible to defer triggers?
Date: Sun, 27 May 2001 12:57:47 +0200
Message-ID: <01052712574700.02459@tk-wkst-1> (raw)
-----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-----
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: torstenknodt@datas-world.de
Subject: Re: Is it possible to defer triggers?
In-Reply-To: <01052712574700.02459@tk-wkst-1>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox