Re: Sync vs Flush

=?UTF-8?B?SmFrYSBKYW7EjWFy?= <jaka@kubje.org> writes:
> For an extended query that needs to get parameter types before sending
> them, is there a difference in doing:

> Parse, Describe statement, Flush, Bind, Execute, Sync
> vs
> Parse, Describe statement, Sync, Bind, Execute, Sync

Sync is a resync point after an error, so the real question is what
you want to have happen if you get some kind of error during the Parse.
If you expect that the app wouldn't proceed with issuing Bind/Execute
then you want to do it the second way.

I suppose you could do

    Send Parse/Describe/Flush
    Read results
    If OK:
       Send Bind/Execute/Sync
    else:
       Send Sync    # needed to get back to normal state

but that doesn't sound all that convenient.

            regards, tom lane