Re: pg_trigger permissions - Mailing list pgsql-novice

From Steve Tucknott
Subject Re: pg_trigger permissions
Date
Msg-id 1135955460.4628.10.camel@retsol1
Whole thread Raw
In response to Re: pg_trigger permissions  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-novice
Thanks Tom.

On Fri, 2005-12-30 at 09:59 -0500, Tom Lane wrote:
Steve Tucknott <steve@retsol.co.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

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: pg_trigger permissions
Next
From: Ubence Quevedo
Date:
Subject: Correct way to set up Variables [Was - Simple Accumulating Number Loop?]