Received: from relay.100btx.intranet (dsl-213-023-052-067.arcor-ip.net [213.23.52.67]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f4RAw3A56586 for ; Sun, 27 May 2001 06:58:04 -0400 (EDT) (envelope-from torstenknodt@datas-world.de) Received: by relay.100btx.intranet (Postfix on SuSE Linux 7.1 (i386), from userid 210) id 470C928E2C; Sun, 27 May 2001 12:57:54 +0200 (CEST) Received: from tk-wkst-1 (tk-wkst-1.100btx.intranet [10.1.1.255]) by relay.100btx.intranet (Postfix on SuSE Linux 7.1 (i386)) with SMTP id 55C6528E2B for ; Sun, 27 May 2001 12:57:51 +0200 (CEST) Content-Type: text/plain; charset="iso-8859-1" From: Torsten Knodt To: pgsql-sql@postgresql.org Subject: Is it possible to defer triggers? Date: Sun, 27 May 2001 12:57:47 +0200 X-Mailer: KMail [version 1.2] Organization: Datas-World MIME-Version: 1.0 Message-Id: <01052712574700.02459@tk-wkst-1> Content-Transfer-Encoding: 8bit X-AntiVirus: scanned for viruses by AMaViS 0.2.1 (http://amavis.org/) X-Archive-Number: 200105/283 X-Sequence-Number: 3111 -----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-----