Re: tracking scripts... - Mailing list pgsql-general

From Merlin Moncure
Subject Re: tracking scripts...
Date
Msg-id CAHyXU0zJYUQPhDY+4QFcdG-xwVcWeKLDy1KLxh6SvVYuSLyhww@mail.gmail.com
Whole thread Raw
In response to Re: tracking scripts...  (John R Pierce <pierce@hogranch.com>)
List pgsql-general
On Tue, Nov 26, 2013 at 2:38 PM, John R Pierce <pierce@hogranch.com> wrote:
> On 11/26/2013 12:30 PM, Merlin Moncure wrote:
>>
>> There are not many ways to Hand off information outside of the
>> database while a transaction Is running. one way Is to write a Simple
>> trigger in plpgsql that 'raise'es A notice every 'n' times trigger
>> condition fires.  that'S Essentially the only Clean way to do it in
>> such a way that the information is Returned to the Executing console.
>> Thanks!
>
>
> how would that trigger track N?

A couple of different ways.  Easiest would just be to manage a sequence.

merlin


pgsql-general by date:

Previous
From: John R Pierce
Date:
Subject: Re: tracking scripts...
Next
From: Raymond O'Donnell
Date:
Subject: Re: tracking scripts...