Thread: pg_trigger permissions
What specific permissions are required to change entries on the pg_* tables - specifically pg_trigger?
I am doing a batch load and want to disable triggers before the load starts and then re-enable them after.
I am doing a batch load and want to disable triggers before the load starts and then re-enable them after.
| Regards, Steve Tucknott ReTSol Ltd DDI: 01903 828769 Mobile: 0773 671 5772 |
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
Thanks Tom.
On Fri, 2005-12-30 at 09:59 -0500, Tom Lane wrote:
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 |