On 6/1/2007 10:52 AM, Dmitry Koterov wrote:
> I also tried to use
> 
> try {
>    ...
> } on success {
>   WAIT FOR EVENT (
>       ORIGIN = ALL,
>       CONFIRMED = ALL,
>       WAIT ON = 1
>   )
> }

Looking at the code, it seems that EXECUTE SCRIPT doesn't actually 
record the events seqno in the admin conninfo. Which means that WAIT FOR 
EVENT will wait for an earlier event, or even nothing. Unfortunately the 
same is true for SYNC in 1.2.9.


Jan


> 
> - effect is the same: no real waiting after ALTER performed.
> 
> 
> On 6/1/07, *Andrew Sullivan* <ajs at crankycanuck.ca 
> <mailto:ajs at crankycanuck.ca>> wrote:
> 
>     On Fri, Jun 01, 2007 at 01:41:44PM +0400, Dmitry Koterov wrote:
>      > Seems when I use EXECUTE
>      > SCRIPT<http://slony.info/documentation/stmtddlscript.html
>     <http://slony.info/documentation/stmtddlscript.html>>and slonik
>      > reports PGRES_TUPLES_OK updates may NOT be finished yet on all
>      > slaves.
> 
>     Right.  If that weren't the case, we wouldn't have WAIT FOR EVENT.
> 
>      > 1. THE MAIN question: is it possible to ask slonik to wait untill
>     all scheme
>      > changes were propogated to all slaves after a slonik call?
> 
>     See above, and http://slony.info/documentation/stmtwaitevent.html
> 
>      > 2. If slonik updates slaves not immediately, but via event
>     creation, why
>      > does it still need to know an information about ALL database
>     hosts, not only
>      > about the master database? I have to enumerate all slave hosts in
>     slonik
>      > calls:
> 
>     You need this information for some cases, and unfortunately that just
>     means that we require it for all cases.  Slonik is indeed a little
>     clunky that way.  It wasn't really intended to be the last word in
>     administration interface for Slony-I.
> 
>     A
> 
>     --
>     Andrew Sullivan  | ajs at crankycanuck.ca <mailto:ajs at crankycanuck.ca>
>     This work was visionary and imaginative, and goes to show that visionary
>     and imaginative work need not end up well.
>                     --Dennis Ritchie
>     _______________________________________________
>     Slony1-general mailing list
>     Slony1-general at lists.slony.info <mailto:Slony1-general at lists.slony.info>
>     http://lists.slony.info/mailman/listinfo/slony1-general
> 
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> Slony1-general mailing list
> Slony1-general at lists.slony.info
> http://lists.slony.info/mailman/listinfo/slony1-general


-- 
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck at Yahoo.com #