Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <pgsql-odbc-owner+archive@lists.postgresql.org>)
	id 1qqvrB-001kkE-02
	for pgsql-odbc@arkaria.postgresql.org; Thu, 12 Oct 2023 13:36:04 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-odbc-owner+archive@lists.postgresql.org>)
	id 1qqvr8-006tfH-SA
	for pgsql-odbc@arkaria.postgresql.org; Thu, 12 Oct 2023 13:36:03 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <ptahin@gmail.com>)
	id 1qqsr3-005ajG-BA
	for pgsql-odbc@lists.postgresql.org; Thu, 12 Oct 2023 10:23:46 +0000
Received: from mail-oi1-x234.google.com ([2607:f8b0:4864:20::234])
	by makus.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256
	(Exim 4.94.2)
	(envelope-from <ptahin@gmail.com>)
	id 1qqsqx-0006is-G5
	for pgsql-odbc@postgresql.org; Thu, 12 Oct 2023 10:23:44 +0000
Received: by mail-oi1-x234.google.com with SMTP id
 5614622812f47-3af6cd01323so449602b6e.3
        for <pgsql-odbc@postgresql.org>; Thu, 12 Oct 2023 03:23:38 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20230601; t=1697106218; x=1697711018;
 darn=postgresql.org;
        h=to:subject:message-id:date:from:mime-version:from:to:cc:subject
         :date:message-id:reply-to;
        bh=u6XuulT6p5HM0RvLkVuSGsnSWQOjBlEqit2dH77yzLg=;
        b=R12xtwCPvSxF4GiTbHAngQU6qjH+qeRqWPGbwfE4Wwq820k79ASPYNm92UQyiH6+F2
         Is0LTNkpF+xdFtPPGlmH5owgu99AhVgkoGYzvKN/CbzVK+tTgIzSMUVIpsB/oq7KRELk
         mrn/wFXBm1lqlc8QP7avzEn6gaCMSy3IGk3FhKTqdj6B9OlKbRIAO1JHu5oybFwVy88c
         Yd+QK2FVywUWCmpa3bq9K448lYdel4RRx2MC4wFameBVV7o9AsNKcYrA1WsxLWb7bbeh
         uYZDxTG01Lo9hGJ3VeaYTT3LTgl+0264ySIRKF5Aye2lkiyUQQ8X/vSinIORArulA/lE
         LS6g==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20230601; t=1697106218; x=1697711018;
        h=to:subject:message-id:date:from:mime-version:x-gm-message-state
         :from:to:cc:subject:date:message-id:reply-to;
        bh=u6XuulT6p5HM0RvLkVuSGsnSWQOjBlEqit2dH77yzLg=;
        b=F/ZeP8DafMTHl4kyP/MwhQpv93Bg8qYEc+L5nXhqFHSxCv1kc6zqfjqr23kYix92Gn
         mRFZsasjLrmzjMvTeWzX3jJob94VmKCEkQEHqkYXZ5GZ8xvO9/wewYj/GCioGNpch3l0
         5RR7NEH//Ml05csThlqnygzWPPE9UJr9RyK2vToSrum8FRzjTPis6apsD5TRBQnwSZF2
         xfAvtlESm7B8S7YhoFyvoYNGd6MqHLJFDwmr7/obIEEktziMgobxMACvNjIDp3ZEuBBu
         EJCP6x+C4McR8eHbUePMlZZSzLc4vH02Xhx8RwTZOg8ykoYrz6+ZZ2FlQg5CTmCEgBqb
         4cSw==
X-Gm-Message-State: AOJu0Yxt8D7wNzGJF8nOB9TwFfLrsxcZsJVYinZAvTo5ryso7tEdvYZX
	vxzMjqWMqRdkZ6DcELne6kuJhFd5c97NYoW2odK/ErjSuGU=
X-Google-Smtp-Source: 
 AGHT+IHbQ7CzCF38NMUcqrcKm/KlBtvB4HTWK1unyPV3j+x7N020Gy/mDzpnTQAHRXX/SeAqvuvdr1Vv0hOk+SNsxso=
X-Received: by 2002:a05:6808:628f:b0:3b0:da4a:4823 with SMTP id
 du15-20020a056808628f00b003b0da4a4823mr10295586oib.56.1697106218048; Thu, 12
 Oct 2023 03:23:38 -0700 (PDT)
MIME-Version: 1.0
From: "Victor K." <ptahin@gmail.com>
Date: Thu, 12 Oct 2023 13:23:01 +0300
Message-ID: 
 <CAGkTcbeeGXvMuYR6p55PCicDWJh4Oh+M7+Yfy9veasSUtV=MVg@mail.gmail.com>
Subject: ODBC error
To: pgsql-odbc@postgresql.org
Content-Type: multipart/alternative; boundary="00000000000045e2fa06078255f5"
List-Id: <pgsql-odbc.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-odbc@lists.postgresql.org>
List-Owner: <mailto:pgsql-odbc-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-odbc>
Archived-At: 
 <https://www.postgresql.org/message-id/CAGkTcbeeGXvMuYR6p55PCicDWJh4Oh%2BM7%2BYfy9veasSUtV%3DMVg%40mail.gmail.com>
Precedence: bulk

--00000000000045e2fa06078255f5
Content-Type: text/plain; charset="UTF-8"

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


Victor
 //
  (,'')> why?
<(   )'
   | |
,,_ _,,

--00000000000045e2fa06078255f5
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div class=3D"gmail_default" style=3D"color:#000000">Hello=
 team</div><div class=3D"gmail_default" style=3D"color:#000000">We have err=
or=C2=A0when trying to get data from big table (about 7 GB) directly to piv=
ot table in MS Excel 2016 Pro Plus x64 over ODBC driver x64</div><div class=
=3D"gmail_default" style=3D"color:#000000">Postrge=C2=A0on linux ver 15</di=
v><div class=3D"gmail_default" style=3D"color:#000000">ODBC=C2=A0psqlodbc_1=
6_00_0000-x64</div><div class=3D"gmail_default" style=3D"color:#000000">Err=
or</div><div class=3D"gmail_default" style=3D"color:#000000">OLE DB or ODBC=
 error. An error occurred while processing table &#39;Query&#39;. The curre=
nt operation was cancelled because another operation in the transaction fai=
led.<br></div><div class=3D"gmail_default" style=3D"color:#000000">and=C2=
=A0</div><div class=3D"gmail_default" style=3D"color:#000000">The commit or=
 rollback request cannot be completed because there is no active transactio=
n in this session.<br></div><div class=3D"gmail_default" style=3D"color:#00=
0000">On small tables everything=C2=A0is okay</div><div class=3D"gmail_defa=
ult" style=3D"color:#000000"><br></div><div class=3D"gmail_default" style=
=3D"color:#000000"><br></div><div><div dir=3D"ltr" class=3D"gmail_signature=
" data-smartmail=3D"gmail_signature"><span class=3D"gmail_default" style=3D=
"color:rgb(0,0,0)">Victor</span><br>=C2=A0//<br>=C2=A0 (,&#39;&#39;)&gt; wh=
y?<br>&lt;(=C2=A0=C2=A0 )&#39;<br>=C2=A0=C2=A0 | |<br>,,_ _,,</div></div></=
div>

--00000000000045e2fa06078255f5--