Re: Create Rule/trigger

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Anagha Joshi <ajoshi(at)nulinkinc(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Create Rule/trigger
Date: 2003-06-18 12:23:29
Message-ID: Pine.LNX.4.44.0306181345420.2501-100000@peter.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)gmx(dot)net

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Gaffga, Stefan 2003-06-18 12:56:00 Plz help: PostgreSQL takes too much disk-space
Previous Message Peter Eisentraut 2003-06-18 12:14:58 Re: configure readline error