From: Aasmund Midttun Godal <postgresql@envisity.com>
To: dassing@wettzell.ifag.de
Cc: pgsql-sql@postgresql.org
Subject: Re: Triggers do not fire
Date: Tue, 16 Oct 2001 19:43:27 GMT
Message-ID: <20011016194327.8782.qmail@ns.krot.org> (raw)
In-Reply-To: <3BCC2CBB.9C3A31EF@wettzell.ifag.de>
References: <3BCC2CBB.9C3A31EF@wettzell.ifag.de>
Your update trigger is fired FOR EACH ROW and no rows are updated i.e. no trigger fired!
On Tue, 16 Oct 2001 14:48:59 +0200, Reiner Dassing <dassing@wettzell.ifag.de> wrote:
> Hallo!
>
> I have written a very small test procedure to show a possible error
> on PostgreSQL V7.1.1.
> A trigger does not fire the function on update but on inserts.
> Does someone have made the same experiences?
>
>
> Here is the short example which is doing nothing important, just showing
> the
> situation:
>
> DROP TABLE test;
> CREATE TABLE test (
> "sensor_id" int4 NOT NULL,
> "epoch" datetime NOT NULL,
> "value" float4 NOT NULL,
> PRIMARY KEY (sensor_id,epoch));
>
> DROP FUNCTION f_test();
> CREATE FUNCTION f_test() RETURNS OPAQUE AS '
> BEGIN
> RAISE NOTICE ''Fired %'',TG_OP;
> RETURN NULL;
> END;
> ' LANGUAGE 'plpgsql';
>
>
> DROP TRIGGER t_test;
> CREATE TRIGGER t_test BEFORE INSERT OR UPDATE ON test FOR EACH ROW
> EXECUTE PROCEDURE f_test();
>
> INSERT INTO test VALUES(1,'2000-10-11 12:00:00',-20.2);
> UPDATE test SET value = 1000.0 WHERE epoch = '2000-10-11 12:10:00' AND
> sensor_id = 1;
>
> The result is as follows:
> INSERT INTO test VALUES(1,'2000-10-11 12:00:00',-20.2);
> NOTICE: Fired INSERT
> INSERT 0 0
> UPDATE test SET value = 1000.0 WHERE epoch = '2000-10-11 12:10:00' AND
> sensor_id = 1;
> UPDATE 0
>
> The insert notice can be shown!
> The update notice is not there!
>
> Why?
>
>
> --
> Mit freundlichen Gruessen / With best regards
> Reiner Dassing
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
Aasmund Midttun Godal
aasmund@godal.com - http://www.godal.com/
+47 40 45 20 46
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: postgresql@envisity.com, dassing@wettzell.ifag.de
Subject: Re: Triggers do not fire
In-Reply-To: <20011016194327.8782.qmail@ns.krot.org>
* 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