Re: acessibility for tables - Mailing list pgsql-general

From Philipp Kraus
Subject Re: acessibility for tables
Date
Msg-id jqoqp9$ahu$1@dough.gmane.org
Whole thread Raw
In response to acessibility for tables  (Kraus Philipp <philipp.kraus@flashpixx.de>)
Responses Re: acessibility for tables
List pgsql-general
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


pgsql-general by date:

Previous
From: Josh Kupershmidt
Date:
Subject: Re: Need help in transferring FP to Int64 DateTime
Next
From: Adrian Klaver
Date:
Subject: Re: Need help in transferring FP to Int64 DateTime