[SQL] Trigger for updating view with join

2013-09-03 Thread Dmitry Morozovsky
Dear colleagues, I'm running Pg 9.1 and have schema like the following: create table machines ( mid serial not null primary key, mname text not null unique ); create table fs ( fsidserial not null primary key, mid int not null references machines,

Re: [SQL] Trigger for updating view with join

2013-09-03 Thread Dmitry Morozovsky
On Wed, 4 Sep 2013, Dmitry Morozovsky wrote: > Dear colleagues, > > I'm running Pg 9.1 and have schema like the following: [snip] > I understand I should use smth like > > create trigger fsl_update instead of insert or update on fsl ... > > but till now did not succeed in it. Quick googlink

Re: [SQL] Trigger for updating view with join

2013-09-03 Thread Dmitry Morozovsky
Heh, it's me spamming you again :) now -- asking for comments. > > create trigger fsl_update instead of insert or update on fsl ... > > > > but till now did not succeed in it. Quick googlink did not help either. > > Argh. My google-fu is definitely low in the night ;) > > for the record: it'