Re: pl/pgsql RECORD data type, how to access to the values - Mailing list pgsql-general

From Pavel Stehule
Subject Re: pl/pgsql RECORD data type, how to access to the values
Date
Msg-id 162867790804060107m201bd99ag8cac53b7e9db2c18@mail.gmail.com
Whole thread Raw
In response to Re: pl/pgsql RECORD data type, how to access to the values  ("Guillaume Bog" <guibog@gmail.com>)
List pgsql-general
>
>  This read-only table is modified (delete + insert) by a trigger
>  function set on another table, but this second trigger calls the first
>  and I can modify my read-only table. I'd like my "read-only" trigger
>  to be aware that the modification call on the read-only table comes
>  from the second trigger. Is it possible?

PostgreSQL call triggers in alphabet order

>
>  I have read in some places that I should use a rule instead, but I
>  never used them and it seems complex. I would prefer not to set up
>  complex access rules with GRANT and REVOKE because my access rules in
>  simple and works now. The best solution I can think of so far is to
>  have the client application work with a view, but having this behavior
>  fully managed through triggers would be more natural and I fear I
>  missed something in the docs.
>

it's depend on application

Pavel

>  > Regards
>  > Pavel Stehule
>  >
>  > >
>  > >
>  >
>

pgsql-general by date:

Previous
From: Oleg Bartunov
Date:
Subject: Re: Text Search Configuration Problem
Next
From: Harald Fuchs
Date:
Subject: Re: Numbering rows by date