Page 1 of 1
TUniTable, PostgreSQL and FetchAll option
Posted: Thu 29 Oct 2015 10:48
by cross_join
Hello all,
When setting
Code: Select all
UniTable.SpecificOptions.Values['FetchAll'] := 'false';
UniDAC open a second connection.
What are the reasons to use second connection?
What PostgreSQL particularities do this impact?
Re: TUniTable, PostgreSQL and FetchAll option
Posted: Fri 30 Oct 2015 11:03
by azyk
PostgreSQL doesn't support simultaneous usage of several transactions within the context of one session. So, before calling the TUniQuery.Open method, PgDAC will use a separate connection instance for fetching data to a dataset with FetchAll = False.
However, if the TUniConnection.StartTransaction method was called before opening such dataset, then PgDAC won't use a separate connection instance for data fetching.
Re: TUniTable, PostgreSQL and FetchAll option
Posted: Fri 30 Oct 2015 12:22
by cross_join
azyk, thank you for explanations.
Re: TUniTable, PostgreSQL and FetchAll option
Posted: Fri 30 Oct 2015 13:15
by azyk
If any other questions come up, please contact us.