Re: pg_trigger permissions

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