| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | yaptNO | 2005-12-30 17:28:52 | pg:8.0 -> 8.1 - COPY and UTF-8 error on restore. |
| Previous Message | Tom Lane | 2005-12-30 14:59:32 | Re: pg_trigger permissions |