Re: Triggers and System Tables.

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: Stef Telford <stef(at)chronozon(dot)artofdns(dot)com>
Cc: <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Triggers and System Tables.
Date: 2002-05-28 05:29:05
Message-ID: 20020527222735.V17559-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Mon, 27 May 2002, Stef Telford wrote:

>
> Hello,
> this is probably a really silly question, but where can i
> control wether or not the superuser/root user can create a trigger
> on a system table ?

In general this is not something you can safely do. I'm not sure if
pg_stat_activity modifications go through something that will fire
triggers, but in general you shouldn't expect that they will on system
tables.

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Stef Telford 2002-05-28 05:35:47 Re: Triggers and System Tables.
Previous Message Joe Conway 2002-05-27 23:18:06 Re: Problem with the result set of postgres