Re: NULLs in ecpg

From: <wespvp(at)syntegra(dot)com>
To: <pgsql-interfaces(at)postgresql(dot)org>
Subject: Re: NULLs in ecpg
Date: 2004-07-22 17:29:03
Message-ID: BD25638F.F5C3%wespvp@syntegra.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

What is the scope of a BEGIN or an implicit transaction in ECPG? Is it a
physical subroutine, or can it span functions containing EXEC SQL
statements?

For example, if I have:

void a (xxx)
{
EXEC SQL SELECT ... for UPDATE;
EXEC SQL UPDATE ...
}

void b (xxx)
{
EXEC SQL begin;

a(xxxx);

a(yyyy);

EXEC SQL COMMIT;
}

Do the multiple calls to 'a' remain in the same transaction?

Wes

In response to

Responses

Browse pgsql-interfaces by date

  From Date Subject
Next Message Peter Eisentraut 2004-07-22 17:51:39 Re: NULLs in ecpg
Previous Message Michal Dobaczewski 2004-07-22 13:51:16 Re: libpq: usage of PQoidValue to obtain serial primary