Postgres Pro
Downloads
Home   >   mailing lists

Re: Fwd: Trigger on VIEW not firing - Mailing list pgsql-general

From Beena Emerson
Subject Re: Fwd: Trigger on VIEW not firing
Date
Msg-id CAOG9ApEP3qAjBpyMygNT_iiCq+rm1rcGQG3wjDXYOuCo5pG8xQ@mail.gmail.com
Whole thread Raw
In response to Re: Fwd: Trigger on VIEW not firing  (Massimo Costantini <massimo.costantini@gmail.com>)
List pgsql-general
Tree view
It works fine if you insert into the view:


=# INSERT INTO speedv VALUES (1, 'test', 100);
INSERT 0 1

=# SELECT * FROM alarm;
 name | id | type  |            init            | fired | t_end | t_user 
------+----+-------+----------------------------+-------+-------+--------
 test |  0 | SPEED | 2013-07-30 18:08:01.006979 |       |       | 
(1 row)

=# SELECT * FROM car;
 id | type | speed 
----+------+-------
(0 rows)

=# SELECT * FROM speedv;
 id | type | speed 
----+------+-------
(0 rows)


--


Beena Emerson

pgsql-general by date:

Previous
From: Massimo Costantini
Date:
Subject: Re: Fwd: Trigger on VIEW not firing
Next
From: Beena Emerson
Date:
Subject: Re: Fwd: Trigger on VIEW not firing