Re: pg_proc - pg_triggers

Поиск
Список
Период
Сортировка
От Stephan Szabo
Тема Re: pg_proc - pg_triggers
Дата
Msg-id 20030207064857.B55352-100000@megazone23.bigpanda.com
обсуждение исходный текст
Ответ на pg_proc - pg_triggers  ("Yudha Setiawan" <yudha@BonBon.net>)
Список pgsql-admin
On Fri, 7 Feb 2003, Yudha Setiawan wrote:

> As Developer we've been developing a simple tools
> for PostgreSQL under Windows, Just helping on Daily operation for our
> "IT-Operation Dept.". Someday I'll share that's tools for milist, i
> promise. But know we need to know how could we connecting two tables,
> between pg_proc and pg_trigger to findout my trigger's script. For now
> we just know the trigger's function without know which trigger is
> using it. Somebody can help us..??? Please.

Something like?

select * from pg_trigger, pg_proc where tgfoid = pg_proc.oid;



В списке pgsql-admin по дате отправления:

Предыдущее
От: Rajesh Kumar Mallah
Дата:
Сообщение: Re: Vacuum full hang => strace
Следующее
От: Palle Girgensohn
Дата:
Сообщение: incremental backup of postgres database?