Re: pl/pgsql RECORD data type, how to access to the values
От | Pavel Stehule |
---|---|
Тема | Re: pl/pgsql RECORD data type, how to access to the values |
Дата | |
Msg-id | 162867790804060107m201bd99ag8cac53b7e9db2c18@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: pl/pgsql RECORD data type, how to access to the values ("Guillaume Bog" <guibog@gmail.com>) |
Список | 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 по дате отправления: