Re: acessibility for tables

From: Philipp Kraus <philipp(dot)kraus(at)flashpixx(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: acessibility for tables
Date: 2012-06-06 23:59:57
Message-ID: jqoqp9$ahu$1@dough.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Josh Kupershmidt 2012-06-07 00:01:35 Re: Need help in transferring FP to Int64 DateTime
Previous Message Josh Kupershmidt 2012-06-06 21:30:41 Re: How to get user privs on a table using select