TUniTable, PostgreSQL and FetchAll option

[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?

[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.

[cross_join]

azyk, thank you for explanations.

[azyk]

If any other questions come up, please contact us.