> > 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 > > > > > > > > > > >
