the error sounds clear enough. you should make a very simple test case that shows your problem (including some test data). then people on the list can help
cheers, WBL On Thu, Jun 7, 2012 at 1:59 AM, Philipp Kraus <philipp.kr...@flashpixx.de>wrote: > Hello, > > > On 2012-06-06 09:24:16 +0200, Albe Laurenz said: > > You can define INSTEAD OF triggers on a view so that you can insert, >> update and delete on it. The trigger performs an operation on the >> base table instead. >> > > I have created the trigger with "insead of". If I try to insert a row into > the > view I get an error: > > You need an unconditional ON INSERT DO INSTEAD rule or an INSTEAD OF > INSERT trigger > > Should I create a rule !? > > Thanks > > Phil > > > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/**mailpref/pgsql-general<http://www.postgresql.org/mailpref/pgsql-general> > -- "Quality comes from focus and clarity of purpose" -- Mark Shuttleworth
