pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / 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>
  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-30 21:26  Frank Contrepois <sokak@tin.it>
  parent: Torsten Knodt <torstenknodt@datas-world.de>
  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