Search Postgresql Archives

Re: tracking scripts...

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Tue, Nov 26, 2013 at 2:38 PM, John R Pierce <pierce@xxxxxxxxxxxx> 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


-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux