Re: pg_trigger permissions

Поиск
Список
Период
Сортировка
От Steve Tucknott
Тема Re: pg_trigger permissions
Дата
Msg-id 1135955460.4628.10.camel@retsol1
обсуждение исходный текст
Ответ на Re: pg_trigger permissions  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: pg_trigger permissions
Следующее
От: Ubence Quevedo
Дата:
Сообщение: Correct way to set up Variables [Was - Simple Accumulating Number Loop?]