pg.ddx.io pgsql-sql@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Is it possible to defer triggers? 2+ messages / 2 participants [nested] [flat]
* Is it possible to defer triggers? @ 2001-05-27 10:57 Torsten Knodt <torstenknodt@datas-world.de> 2001-05-30 21:26 ` Re: Is it possible to defer triggers? Frank Contrepois <sokak@tin.it> 0 siblings, 1 reply; 2+ messages in thread From: Torsten Knodt @ 2001-05-27 10:57 UTC (permalink / raw) To: 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----- ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Is it possible to defer triggers? 2001-05-27 10:57 Is it possible to defer triggers? Torsten Knodt <torstenknodt@datas-world.de> @ 2001-05-30 21:26 ` Frank Contrepois <sokak@tin.it> 0 siblings, 0 replies; 2+ messages in thread From: Frank Contrepois @ 2001-05-30 21:26 UTC (permalink / raw) To: pgsql-sql 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) ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2001-05-30 21:26 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2001-05-27 10:57 Is it possible to defer triggers? Torsten Knodt <torstenknodt@datas-world.de> 2001-05-30 21:26 ` Frank Contrepois <sokak@tin.it>
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