Re: Create Rule/trigger - Mailing list pgsql-admin

From Peter Eisentraut
Subject Re: Create Rule/trigger
Date
Msg-id Pine.LNX.4.44.0306181345420.2501-100000@peter.localdomain
Whole thread Raw
In response to Create Rule/trigger  ("Anagha Joshi" <ajoshi@nulinkinc.com>)
List pgsql-admin
Anagha Joshi writes:

> Can we create trigger/rule that specifies
> Do action 'Y'
>         when
>                 inserts/updates to any table in the
> database 'X' occurs?

No, you need to create a trigger/rule for each table.

If you just want to audit things, maybe you could crank up the log level
to log all statements in the server log.

--
Peter Eisentraut   peter_e@gmx.net


pgsql-admin by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: configure readline error
Next
From: "Gaffga, Stefan"
Date:
Subject: Plz help: PostgreSQL takes too much disk-space