From: | Christian Barthel <bch(at)online(dot)de> |
---|---|
To: | ALT SHN <i(dot)geografica(at)alt-shn(dot)org> |
Cc: | pgsql-novice(at)lists(dot)postgresql(dot)org |
Subject: | Re: Coalesce in PostgreSQL trigger does not fire on upddate |
Date: | 2020-02-08 07:53:39 |
Message-ID: | 87blq9qzuk.fsf@barthel.ch |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
ALT SHN <i(dot)geografica(at)alt-shn(dot)org> writes:
[..]
> However this trigger only fires on INSERT, nothing happens if
> an UPDATE is made. How can have this trigger also firing in the
> case of an UPDATE?
I have just tested it on PostgreSQL 11 (FreeBSD) and it seems to
work (at least, it is what I would expect):
bch=# select id,taxon,reino,phylum,subphylum,classe,especie from
taxon where id = 3;
id | taxon | reino | phylum | subphylum | classe | especie
----+-------+-------+--------+-----------+--------+---------
(0 rows)
bch=# insert into taxon(reino,classe) values ('1', '2');
INSERT 0 1
bch=# select id,taxon,reino,phylum,subphylum,classe,especie from
taxon where id = 3;
id | taxon | reino | phylum | subphylum | classe | especie
----+-------+-------+--------+-----------+--------+---------
3 | 2 | 1 | | | 2 |
(1 row)
bch=# update taxon set especie='99' where id = 3;
UPDATE 1
bch=# select id,taxon,reino,phylum,subphylum,classe,especie from
taxon where id = 3;
id | taxon | reino | phylum | subphylum | classe | especie
----+-------+-------+--------+-----------+--------+---------
3 | 99 | 1 | | | 2 | 99
(1 row)
Are there any other triggers preventing the update? You may also
write some RAISE NOTICE messages into the trigger to see when it
is being executed.
--
Christian Barthel <bch(at)online(dot)de>
From | Date | Subject | |
---|---|---|---|
Next Message | ALT SHN | 2020-02-08 09:32:20 | Re: Coalesce in PostgreSQL trigger does not fire on upddate |
Previous Message | ALT SHN | 2020-02-07 20:15:39 | Coalesce in PostgreSQL trigger does not fire on upddate |