Skip site navigation (1) Skip section navigation (2)

Re: pg_trigger permissions

From: Steve Tucknott <steve(at)retsol(dot)co(dot)uk>
To: PostGreSQL <pgsql-novice(at)postgresql(dot)org>
Subject: Re: pg_trigger permissions
Date: 2005-12-30 15:11:00
Message-ID: 1135955460.4628.10.camel@retsol1 (view raw or flat)
Thread:
Lists: pgsql-novice
Thanks Tom.

On Fri, 2005-12-30 at 09:59 -0500, Tom Lane wrote:

> Steve Tucknott <steve(at)retsol(dot)co(dot)uk> writes:
> > What specific permissions are required to change entries on the pg_*
> > tables - specifically pg_trigger?
> 
> superuser ...
> 
> > I am doing a batch load and want to disable triggers before the load
> > starts and then re-enable them after.
> 
> In 8.1 there is an ALTER TABLE command for this.
> 
> 			regards, tom lane
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings

Regards,

Steve Tucknott
ReTSol Ltd

DDI: 01903 828769
Mobile: 0773 671 5772

In response to

pgsql-novice by date

Next:From: yaptNODate: 2005-12-30 17:28:52
Subject: pg:8.0 -> 8.1 - COPY and UTF-8 error on restore.
Previous:From: Tom LaneDate: 2005-12-30 14:59:32
Subject: Re: pg_trigger permissions

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group