Re: Suggestions for Remote Procedure Calls from PG, please?

Em Thursday 18 October 2007 01:44:33 Bret Schuhmacher escreveu:
>
> Thanks for the reply, Tom.  I was thinking I could have my remote
> process send a message back to PG via XMLBlaster, too.  XMLBlaster is
> a MOM-like message-queuing app that guarantees delivery to
> subscribers. (www.xmlblaster.org).  The problem, as you stated,
> though, is transactional integrity :-(.  Hmmm, I'll see about the
> to-do queue idea.

You can try implementing a queue, Bret.  Make it a FIFO queue and poll from it
regularly.  Ten make your transaction insert a record on that queue and take
your action based on that.

A table as simple as:

    id            SERIAL,       -- you can have a routine to reset this when empty
    table         TEXT,          -- includes schema
    primary_key    TEXT           -- to allow for numeric and text PKs

would allow you to retrieve the row that has been changed and take your action
based on that.

--
Jorge Godoy      <jgodoy@gmail.com>