| From: | Larry Rosenman <ler(at)lerctr(dot)org> |
|---|---|
| To: | Joe Conway <mail(at)joeconway(dot)com> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: PL/pgSQL: Logging Trigger. Advice/comments/other? |
| Date: | 2003-05-14 21:41:18 |
| Message-ID: | 485430000.1052948478@lerlaptop-red.iadfw.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
--On Wednesday, May 14, 2003 14:32:52 -0700 Joe Conway <mail(at)joeconway(dot)com>
wrote:
> Larry Rosenman wrote:
>> Ok, I finally finished this damn trigger to log changes to ONE frapping
>> table.
>>
>> I'm wondering if any of you PL/pgSQL guru's out there see any better way
>> to do
>> this:
>
> I haven't had the time to follow this thread, but depending on your
> needs, maybe this will help (uses dblink_current_query() from
> contrib/dblink):
[snip]
Oooohhhhh.... This looks promising. (now, can I migrate the damn 7.2.1
to 7.3.2????).
Thanks Joe!
LER
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972-414-9812 E-Mail: ler(at)lerctr(dot)org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Guy Fraser | 2003-05-14 22:11:27 | I need help with a rule to relocate duplicate records |
| Previous Message | Joe Conway | 2003-05-14 21:32:52 | Re: PL/pgSQL: Logging Trigger. Advice/comments/other? |