pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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-----




view thread (2+ messages)  latest in thread

Message-ID: <01052712574700.02459@tk-wkst-1>
Permalink:  ../01052712574700.02459@tk-wkst-1/
Also on:    postgresql.org/message-id/01052712574700.02459@tk-wkst-1

 · 

reply

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