On Thu, 12 Oct 2023 at 09:33, Victor K. <ptahin(at)gmail(dot)com> wrote:
> Hello team
> We have error when trying to get data from big table (about 7 GB) directly
> to pivot table in MS Excel 2016 Pro Plus x64 over ODBC driver x64
> Postrge on linux ver 15
> ODBC psqlodbc_16_00_0000-x64
> Error
> OLE DB or ODBC error. An error occurred while processing table 'Query'.
> The current operation was cancelled because another operation in the
> transaction failed.
> and
> The commit or rollback request cannot be completed because there is no
> active transaction in this session.
> On small tables everything is okay
>
I would suggest looking at the server logs.
Dave Cramer
www.postgres.rocks
>