pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
delayed actions
2+ messages / 1 participants
[nested] [flat]

* delayed actions
@ 2007-07-10 20:53  De Leeuw Guy <G.De_Leeuw@eurofer.be>
  0 siblings, 1 reply; 2+ messages in thread

From: De Leeuw Guy @ 2007-07-10 20:53 UTC (permalink / raw)
  To: pgsql-admin

Hello all

I write a new trigger in C.
These trigger update a sums of rows and I have a strange problem :

when I insert the data ok
When I delete the data the DELETE are delayed and my trigger is fired a
lot of time (see below)
It is possible to flush the actions before exiting my trigger ?

Thanks in advance
Guy

  SPI_connect();
  if bBusy return; /* global variable */

elog(INFO, "Not busy");
     gd_SetBusy(relationName, true);
     gd_InitCatCodes(relationName, tupdesc, retTuple, valDiff, qteDiff,
firedEvent); /* INSERT, DELETE, OR UPGRADE a lot of records */
     gd_SetBusy(relationName, false);
    }
  SPI_finish();
}

db_stats=# INSERT INTO table_f001 VALUES (1, 00000001, 2, 0010101, 3,
00000101, 4, 00004001, 5, 20070199, 0,  50);
INFO:  Not busy
INFO:  INSERT INTO table_f001 VALUES (1, 1, 2, 10101, 3, 101, 4, 4001,
5, 20079999, 0.000000, 50.000000);
INFO:  INSERT INTO table_f001 VALUES (1, 1, 2, 10101, 3, 101, 4, 4099,
5, 20070199, 0.000000, 50.000000);
INFO:  INSERT INTO table_f001 VALUES (1, 1, 2, 10101, 3, 101, 4, 4099,
5, 20079999, 0.000000, 50.000000);
INFO:  INSERT INTO table_f001 VALUES (1, 1, 2, 10101, 3, 1010, 4, 4001,
5, 20070199, 0.000000, 50.000000);
INFO:  INSERT INTO table_f001 VALUES (1, 1, 2, 10101, 3, 1010, 4, 4001,
5, 20079999, 0.000000, 50.000000);
INFO:  INSERT INTO table_f001 VALUES (1, 1, 2, 10101, 3, 1010, 4, 4099,
5, 20070199, 0.000000, 50.000000);
INFO:  INSERT INTO table_f001 VALUES (1, 1, 2, 10101, 3, 1010, 4, 4099,
5, 20079999, 0.000000, 50.000000);
INFO:  INSERT INTO table_f001 VALUES (1, 3, 2, 10101, 3, 101, 4, 4001,
5, 20070199, 0.000000, 50.000000);
INFO:  INSERT INTO table_f001 VALUES (1, 3, 2, 10101, 3, 101, 4, 4001,
5, 20079999, 0.000000, 50.000000);
INFO:  INSERT INTO table_f001 VALUES (1, 3, 2, 10101, 3, 101, 4, 4099,
5, 20070199, 0.000000, 50.000000);
INFO:  INSERT INTO table_f001 VALUES (1, 3, 2, 10101, 3, 101, 4, 4099,
5, 20079999, 0.000000, 50.000000);
INFO:  INSERT INTO table_f001 VALUES (1, 3, 2, 10101, 3, 1010, 4, 4001,
5, 20070199, 0.000000, 50.000000);
INFO:  INSERT INTO table_f001 VALUES (1, 3, 2, 10101, 3, 1010, 4, 4001,
5, 20079999, 0.000000, 50.000000);
INFO:  INSERT INTO table_f001 VALUES (1, 3, 2, 10101, 3, 1010, 4, 4099,
5, 20070199, 0.000000, 50.000000);
INFO:  INSERT INTO table_f001 VALUES (1, 3, 2, 10101, 3, 1010, 4, 4099,
5, 20079999, 0.000000, 50.000000);
db_stats=# DELETE FROM table_f001;
INFO:  Not busy
INFO:  DELETE FROM table_f001 WHERE code01=1 AND code02=10101 AND
code03=101 AND code04=4001 AND code05=20079999;
INFO:  DELETE FROM table_f001 WHERE code01=1 AND code02=10101 AND
code03=101 AND code04=4099 AND code05=20070199;
INFO:  DELETE FROM table_f001 WHERE code01=1 AND code02=10101 AND
code03=101 AND code04=4099 AND code05=20079999;
INFO:  DELETE FROM table_f001 WHERE code01=1 AND code02=10101 AND
code03=1010 AND code04=4001 AND code05=20070199;
INFO:  DELETE FROM table_f001 WHERE code01=1 AND code02=10101 AND
code03=1010 AND code04=4001 AND code05=20079999;
INFO:  DELETE FROM table_f001 WHERE code01=1 AND code02=10101 AND
code03=1010 AND code04=4099 AND code05=20070199;
INFO:  DELETE FROM table_f001 WHERE code01=1 AND code02=10101 AND
code03=1010 AND code04=4099 AND code05=20079999;
INFO:  DELETE FROM table_f001 WHERE code01=3 AND code02=10101 AND
code03=101 AND code04=4001 AND code05=20070199;
INFO:  DELETE FROM table_f001 WHERE code01=3 AND code02=10101 AND
code03=101 AND code04=4001 AND code05=20079999;
INFO:  DELETE FROM table_f001 WHERE code01=3 AND code02=10101 AND
code03=101 AND code04=4099 AND code05=20070199;
INFO:  DELETE FROM table_f001 WHERE code01=3 AND code02=10101 AND
code03=101 AND code04=4099 AND code05=20079999;
INFO:  DELETE FROM table_f001 WHERE code01=3 AND code02=10101 AND
code03=1010 AND code04=4001 AND code05=20070199;
INFO:  DELETE FROM table_f001 WHERE code01=3 AND code02=10101 AND
code03=1010 AND code04=4001 AND code05=20079999;
INFO:  DELETE FROM table_f001 WHERE code01=3 AND code02=10101 AND
code03=1010 AND code04=4099 AND code05=20070199;
INFO:  DELETE FROM table_f001 WHERE code01=3 AND code02=10101 AND
code03=1010 AND code04=4099 AND code05=20079999;
INFO:  Not busy
INFO:  DELETE FROM table_f001 WHERE code01=1 AND code02=10101 AND
code03=101 AND code04=4099 AND code05=20079999;
INFO:  DELETE FROM table_f001 WHERE code01=1 AND code02=10101 AND
code03=1010 AND code04=4001 AND code05=20079999;
INFO:  DELETE FROM table_f001 WHERE code01=1 AND code02=10101 AND
code03=1010 AND code04=4099 AND code05=20079999;
INFO:  DELETE FROM table_f001 WHERE code01=3 AND code02=10101 AND
code03=101 AND code04=4001 AND code05=20079999;
INFO:  DELETE FROM table_f001 WHERE code01=3 AND code02=10101 AND
code03=101 AND code04=4099 AND code05=20079999;
INFO:  DELETE FROM table_f001 WHERE code01=3 AND code02=10101 AND
code03=1010 AND code04=4001 AND code05=20079999;
INFO:  DELETE FROM table_f001 WHERE code01=3 AND code02=10101 AND
code03=1010 AND code04=4099 AND code05=20079999;
INFO:  Not busy
INFO:  DELETE FROM table_f001 WHERE code01=1 AND code02=10101 AND
code03=101 AND code04=4099 AND code05=20079999;
INFO:  DELETE FROM table_f001 WHERE code01=1 AND code02=10101 AND
code03=1010 AND code04=4099 AND code05=20070199;
INFO:  DELETE FROM table_f001 WHERE code01=1 AND code02=10101 AND
code03=1010 AND code04=4099 AND code05=20079999;
INFO:  DELETE FROM table_f001 WHERE code01=3 AND code02=10101 AND
code03=101 AND code04=4099 AND code05=20070199;
INFO:  DELETE FROM table_f001 WHERE code01=3 AND code02=10101 AND
code03=101 AND code04=4099 AND code05=20079999;
INFO:  DELETE FROM table_f001 WHERE code01=3 AND code02=10101 AND
code03=1010 AND code04=4099 AND code05=20070199;
INFO:  DELETE FROM table_f001 WHERE code01=3 AND code02=10101 AND
code03=1010 AND code04=4099 AND code05=20079999;
INFO:  Not busy
INFO:  DELETE FROM table_f001 WHERE code01=1 AND code02=10101 AND
code03=1010 AND code04=4099 AND code05=20079999;
INFO:  DELETE FROM table_f001 WHERE code01=3 AND code02=10101 AND
code03=101 AND code04=4099 AND code05=20079999;
INFO:  DELETE FROM table_f001 WHERE code01=3 AND code02=10101 AND
code03=1010 AND code04=4099 AND code05=20079999;
INFO:  Not busy
INFO:  DELETE FROM table_f001 WHERE code01=1 AND code02=10101 AND
code03=1010 AND code04=4001 AND code05=20079999;
INFO:  DELETE FROM table_f001 WHERE code01=1 AND code02=10101 AND
code03=1010 AND code04=4099 AND code05=20070199;
INFO:  DELETE FROM table_f001 WHERE code01=1 AND code02=10101 AND
code03=1010 AND code04=4099 AND code05=20079999;
INFO:  DELETE FROM table_f001 WHERE code01=3 AND code02=10101 AND
code03=1010 AND code04=4001 AND code05=20070199;
INFO:  DELETE FROM table_f001 WHERE code01=3 AND code02=10101 AND
code03=1010 AND code04=4001 AND code05=20079999;
INFO:  DELETE FROM table_f001 WHERE code01=3 AND code02=10101 AND
code03=1010 AND code04=4099 AND code05=20070199;
INFO:  DELETE FROM table_f001 WHERE code01=3 AND code02=10101 AND
code03=1010 AND code04=4099 AND code05=20079999;
INFO:  Not busy
INFO:  DELETE FROM table_f001 WHERE code01=1 AND code02=10101 AND
code03=1010 AND code04=4099 AND code05=20079999;
INFO:  DELETE FROM table_f001 WHERE code01=3 AND code02=10101 AND
code03=1010 AND code04=4001 AND code05=20079999;
INFO:  DELETE FROM table_f001 WHERE code01=3 AND code02=10101 AND
code03=1010 AND code04=4099 AND code05=20079999;
INFO:  Not busy
INFO:  DELETE FROM table_f001 WHERE code01=1 AND code02=10101 AND
code03=1010 AND code04=4099 AND code05=20079999;
INFO:  DELETE FROM table_f001 WHERE code01=3 AND code02=10101 AND
code03=1010 AND code04=4099 AND code05=20070199;
INFO:  DELETE FROM table_f001 WHERE code01=3 AND code02=10101 AND
code03=1010 AND code04=4099 AND code05=20079999;
INFO:  Not busy
INFO:  DELETE FROM table_f001 WHERE code01=3 AND code02=10101 AND
code03=1010 AND code04=4099 AND code05=20079999;
INFO:  Not busy
INFO:  DELETE FROM table_f001 WHERE code01=3 AND code02=10101 AND
code03=101 AND code04=4001 AND code05=20079999;
INFO:  DELETE FROM table_f001 WHERE code01=3 AND code02=10101 AND
code03=101 AND code04=4099 AND code05=20070199;
INFO:  DELETE FROM table_f001 WHERE code01=3 AND code02=10101 AND
code03=101 AND code04=4099 AND code05=20079999;
INFO:  DELETE FROM table_f001 WHERE code01=3 AND code02=10101 AND
code03=1010 AND code04=4001 AND code05=20070199;
INFO:  DELETE FROM table_f001 WHERE code01=3 AND code02=10101 AND
code03=1010 AND code04=4001 AND code05=20079999;
INFO:  DELETE FROM table_f001 WHERE code01=3 AND code02=10101 AND
code03=1010 AND code04=4099 AND code05=20070199;
INFO:  DELETE FROM table_f001 WHERE code01=3 AND code02=10101 AND
code03=1010 AND code04=4099 AND code05=20079999;
INFO:  Not busy
INFO:  DELETE FROM table_f001 WHERE code01=3 AND code02=10101 AND
code03=101 AND code04=4099 AND code05=20079999;
INFO:  DELETE FROM table_f001 WHERE code01=3 AND code02=10101 AND
code03=1010 AND code04=4001 AND code05=20079999;
INFO:  DELETE FROM table_f001 WHERE code01=3 AND code02=10101 AND
code03=1010 AND code04=4099 AND code05=20079999;
INFO:  Not busy
INFO:  DELETE FROM table_f001 WHERE code01=3 AND code02=10101 AND
code03=101 AND code04=4099 AND code05=20079999;
INFO:  DELETE FROM table_f001 WHERE code01=3 AND code02=10101 AND
code03=1010 AND code04=4099 AND code05=20070199;
INFO:  DELETE FROM table_f001 WHERE code01=3 AND code02=10101 AND
code03=1010 AND code04=4099 AND code05=20079999;
INFO:  Not busy
INFO:  DELETE FROM table_f001 WHERE code01=3 AND code02=10101 AND
code03=1010 AND code04=4099 AND code05=20079999;
INFO:  Not busy
INFO:  DELETE FROM table_f001 WHERE code01=3 AND code02=10101 AND
code03=1010 AND code04=4001 AND code05=20079999;
INFO:  DELETE FROM table_f001 WHERE code01=3 AND code02=10101 AND
code03=1010 AND code04=4099 AND code05=20070199;
INFO:  DELETE FROM table_f001 WHERE code01=3 AND code02=10101 AND
code03=1010 AND code04=4099 AND code05=20079999;
INFO:  Not busy
INFO:  DELETE FROM table_f001 WHERE code01=3 AND code02=10101 AND
code03=1010 AND code04=4099 AND code05=20079999;
INFO:  Not busy
INFO:  DELETE FROM table_f001 WHERE code01=3 AND code02=10101 AND
code03=1010 AND code04=4099 AND code05=20079999;
INFO:  Not busy
db_stats=#



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: delayed actions
@ 2007-07-12 07:41  De Leeuw Guy <G.De_Leeuw@eurofer.be>
  parent: De Leeuw Guy <G.De_Leeuw@eurofer.be>
  0 siblings, 0 replies; 2+ messages in thread

From: De Leeuw Guy @ 2007-07-12 07:41 UTC (permalink / raw)
  To: ; +Cc: pgsql-admin

Sorry for the sound, I match a bug on my trigger :-(

Guy




^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2007-07-12 07:41 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-07-10 20:53 delayed actions De Leeuw Guy <G.De_Leeuw@eurofer.be>
2007-07-12 07:41 ` De Leeuw Guy <G.De_Leeuw@eurofer.be>

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