pg_get_triggerdef - Mailing list pgsql-patches

From Christopher Kings-Lynne
Subject pg_get_triggerdef
Date
Msg-id 01e801c2e78e$fe2a1be0$6500a8c0@fhp.internal
Whole thread Raw
Responses Re: pg_get_triggerdef  (Neil Conway <neilc@samurai.com>)
Re: pg_get_triggerdef  (Neil Conway <neilc@samurai.com>)
Re: pg_get_triggerdef  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-patches
This patch creates a function named pg_get_triggerdef that takes the oid of
a trigger as its parameter.  It is basically copied from the pg_dump code.

Once we're certain it's perfect, we could probably save some effort in
pg_dump by using the function.

Once it's committed, I will be modifying psql to show trigger definitions,
instead of just the name.

I have tested it with a bunch of different triggers, parameters, constraint
triggers, weird names, different functions, etc and it seems to be OK.

Cheers,

Chris

Attachment

pgsql-patches by date:

Previous
From: Tom Lane
Date:
Subject: Re: spelling corrections
Next
From: "Christopher Kings-Lynne"
Date:
Subject: pg_get_triggerdef doc patch