From: vignesh kumar <vigneshkumar.venugopal@outlook.com>
To: Laurenz Albe <laurenz.albe@cybertec.at>, Sabyasachi Mukherjee
	<mukherjee.sabyasachi@outlook.com>, "pgsql-admin@lists.postgresql.org"
	<pgsql-admin@lists.postgresql.org>
Subject: Re: Loading data from one table to another
Thread-Topic: Loading data from one table to another
Thread-Index: AQHbHTd44EbVmBQV6kGso1S6rljeY7KFzEQAgAIwMFg=
Date: Tue, 15 Oct 2024 16:01:38 +0000
Message-ID: 
 <MN0PR20MB49128874B7C246293B856A3B87452@MN0PR20MB4912.namprd20.prod.outlook.com>
References: 
 <DB7PR03MB378887A0840FDAECF62410CD8C7B2@DB7PR03MB3788.eurprd03.prod.outlook.com>
 <d56f02ddb857b53e537d1e1d54dc2e111e7c9937.camel@cybertec.at>
In-Reply-To: <d56f02ddb857b53e537d1e1d54dc2e111e7c9937.camel@cybertec.at>
Accept-Language: en-US
Content-Language: en-US
x-ms-exchange-messagesentrepresentingtype: 1
x-ms-publictraffictype: Email
x-ms-traffictypediagnostic: MN0PR20MB4912:EE_|DS0PR20MB5029:EE_
x-ms-office365-filtering-correlation-id: ad8edab3-397b-44e5-2db6-08dced32a744
x-microsoft-antispam: 
 BCL:0;ARA:14566002|19110799003|461199028|12050799009|8062599003|8060799006|7092599003|14030799003|15080799006|9400799024|102099032|10035399004|3412199025|4302099013|440099028|1602099012;
x-microsoft-antispam-message-info: 
	=?us-ascii?Q?4t1k1Hvih2B9Y/PwiaXKTalgfiytj+Jaqj+/MehP0LPr0wtdZMy+QApLoPQL?=
 =?us-ascii?Q?uN85vuGIkleoeoMWZOMu/ZkRgWWETBMgdQKJgfJ/dzDa2oipLK2g9VYSL9fr?=
 =?us-ascii?Q?ne1NBYIkT+ykrX6fb+c9xYUHZUSynwLDZyTZ48VoFSDoZZBX3ij92lRLPRKo?=
 =?us-ascii?Q?/UdLAvMpDP8zmDGmOtsiyNeUk9eAuGBtG9Lk8Ahjt7VYavD2vSEzXaXc7dqs?=
 =?us-ascii?Q?arQizjVG1+2x5xeEr7kqQdceYK0S1mglTvc7BvPuNeSJguOsLgYBi6xAS1ts?=
 =?us-ascii?Q?M0R7pc+fPpN3QiHU1uIfxLnfPIV7zF6UvorsROr/zM0sBljFyrgMCQ3fHNnV?=
 =?us-ascii?Q?IpcA/MLFCrAYV/I/ujnEJwfmDt2lvb0Iy/6m4Qczm1ocMi9K4y5e3N6NqtTQ?=
 =?us-ascii?Q?QiwIqJgcYR2nB0LXU6mLclj6JlMd4lgsPiEx1Jp+B5iGxIbSko8l9S0lcHeP?=
 =?us-ascii?Q?K/xMlsl1Yb/lF6pu6A1bqjkQD4Nrm48lauag1QkEL1uM/IwdfDHdhi9lkZzS?=
 =?us-ascii?Q?eh4Z49BAaZn2o4aDjGb+vpJ4N5dmcj8iok7WbZC6k/zbDJesFs1KSF2hn+Gp?=
 =?us-ascii?Q?BLND/bogs7OnlKBeAckHt9pSCqFfH2IQT9ytN9q/ffX1wI+lgzjwrkkxiCgl?=
 =?us-ascii?Q?xQFcEzX0Of99u2W9L7ZOCSzki4kWqqFeO9i3lfLOwqOdYQDPaFX6n9zc8xc+?=
 =?us-ascii?Q?EnHbH3+WfFBY/G91FiVFhRoPw37MTyF4j0bqJoaURe0kZ+Tj0yOfhW22kRy3?=
 =?us-ascii?Q?T7N/HmMsKOMo1O+Q8WEBdNf+y0gyiDhHqCVUnZ0R+5VIYAqC2eGOflme10CD?=
 =?us-ascii?Q?j84CzA0adJsI8pUaQybXDstYrQXZ6g30865XCt3o0sniaGICBUXLvDTXYrak?=
 =?us-ascii?Q?HUMNSoHa0YCtDgzUZBiR6iQSK2dd5uV20zCwrkT8IubO2Dbdnr4njivq7Xst?=
 =?us-ascii?Q?mJzOyIMtbJPb3pfX+Blhxw=3D=3D?=
x-ms-exchange-antispam-messagedata-chunkcount: 1
x-ms-exchange-antispam-messagedata-0: 
 =?us-ascii?Q?0oI9Om1ZQXegQlK/c7IbI+nHqY3KgieI2VbReJ8mCKGO5zFiAHlemJcV2WnW?=
 =?us-ascii?Q?vPBFtxQteFGswot5kNKRPD+Sh42J4iK84vmy9p5rqOag1zekDwzo1EvD0ybQ?=
 =?us-ascii?Q?fbLCiw/2SAizf0V5q9btDNSLF/oUw2OSYei+DLFfrwNPLKyvrtwm6JW49vtH?=
 =?us-ascii?Q?0iop5nKM48q58Eg1kQJ0I47OCoH1Bewd32Hn+A74itHfucJlFy7TFrtdohCg?=
 =?us-ascii?Q?lWA9EeuZMh4RUbqXiRGqpivKulk1Me+p3v8MSZLFB3TR2YGXVwtkSEKWfRQ2?=
 =?us-ascii?Q?BrrDkPvL3i1cqLq1E5u+lNmH/CEuXFTtzIHqyr4p3q1xzTG4QpZWxw54e2Ev?=
 =?us-ascii?Q?ztdpPp5XO+3BmYX/wF/I7r8VT7U1jlRAMw6XiIL1bUDE3LqyxR01KorF2Q1h?=
 =?us-ascii?Q?Q8seNa26wBIim9haGm5zGvnI5nDiqcLD85hxICACYYz265/4D5idFX/NC6u/?=
 =?us-ascii?Q?GXmVEyLQuGaHa0Py1sXdIHIWfbD0m48l3WznHv1dl3o618I0Ja7RVAZ4Lwp4?=
 =?us-ascii?Q?3QAFzdjbivS/6KaAkVTpY4LkXUilMOcZANQNrYs84bAJYnZutZGK8YJeorEQ?=
 =?us-ascii?Q?2tJUeStDn0DxQnVNVi6Avm8GNSflBSicFhmVLm5wus5lDmqoJrBT8UpACgch?=
 =?us-ascii?Q?CyadVtNkOfTJxibIheXYnZaevuUxDpT0aBQ3R4o3iMS8BA9/0oh2Nudw65yg?=
 =?us-ascii?Q?4T6lN3Jv923CBwvIFIFIkPNpXl4yHwXlOJBfjfKEVgteL/HhARtMP2XV3T2I?=
 =?us-ascii?Q?6iV6FSPy2F/pWSQYMbEIZjn5HP5O5k5GUVZappEe9PG1g1He/T2B5tyRE099?=
 =?us-ascii?Q?RFoIqxQUl5+8LqKl87LqYxwgsCdol6t44w4xunaRq3rdlCoT6CwXoT/SwTfQ?=
 =?us-ascii?Q?Bnn4AVsQrXaBo6WlcNb/NwE8XbyTb5mzSHe6odC8qgA0IYskuBiB7bAWzT+m?=
 =?us-ascii?Q?BK3DA/XgkLgJs383umvjlo/kDwMT9W3h8wNLII9VSNJuKnTiEEIvdjXbwB4E?=
 =?us-ascii?Q?C56drBConDQIJQaQETT55nVzExeP8ASLS7xP6p9GWI5HZxEhbF9S50mtnUXk?=
 =?us-ascii?Q?sKsBSX2drkBvJdhj1HwcT8x44NwZOx+/luN/sR7umZG6yj3ZYiEOYB+cpsM0?=
 =?us-ascii?Q?WEC30I9Xe+ozR9/pxW+byxyBipfJJLctKc4VBhgHe9XC+DHnLRLrhPbrPesS?=
 =?us-ascii?Q?nxKuRs/2eFmoawsjigZ6kGg3SYUU7rhoqhuIsD/jUj5sQ9qRjwKj0PQ5u1Cj?=
 =?us-ascii?Q?T6PuPUCQDsrNL01ZJEfCqOGI54ZxmPfFN1tsfc127+sJhWo/fZdFLDTyOIAW?=
 =?us-ascii?Q?zY4=3D?=
Content-Type: multipart/alternative;
	boundary="_000_MN0PR20MB49128874B7C246293B856A3B87452MN0PR20MB4912namp_"
MIME-Version: 1.0
X-OriginatorOrg: outlook.com
X-MS-Exchange-CrossTenant-AuthAs: Internal
X-MS-Exchange-CrossTenant-AuthSource: MN0PR20MB4912.namprd20.prod.outlook.com
X-MS-Exchange-CrossTenant-RMS-PersistedConsumerOrg: 
 00000000-0000-0000-0000-000000000000
X-MS-Exchange-CrossTenant-Network-Message-Id: 
 ad8edab3-397b-44e5-2db6-08dced32a744
X-MS-Exchange-CrossTenant-originalarrivaltime: 15 Oct 2024 16:01:38.9940
 (UTC)
X-MS-Exchange-CrossTenant-fromentityheader: Hosted
X-MS-Exchange-CrossTenant-id: 84df9e7f-e9f6-40af-b435-aaaaaaaaaaaa
X-MS-Exchange-CrossTenant-rms-persistedconsumerorg: 
 00000000-0000-0000-0000-000000000000
X-MS-Exchange-Transport-CrossTenantHeadersStamped: DS0PR20MB5029
List-Id: <pgsql-admin.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-admin@lists.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-admin>
Archived-At: 
 <https://www.postgresql.org/message-id/MN0PR20MB49128874B7C246293B856A3B87452%40MN0PR20MB4912.namprd20.prod.outlook.com>
Precedence: bulk

--_000_MN0PR20MB49128874B7C246293B856A3B87452MN0PR20MB4912namp_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Check if you have foreign table references and they should hold on delete c=
ascade that should resolve data being dupliated

Sent from Outlook for Android<https://aka.ms/AAb9ysg>
________________________________
From: Laurenz Albe <laurenz.albe@cybertec.at>
Sent: Monday, October 14, 2024 12:06:08 PM
To: Sabyasachi Mukherjee <mukherjee.sabyasachi@outlook.com>; pgsql-admin@li=
sts.postgresql.org <pgsql-admin@lists.postgresql.org>
Subject: Re: Loading data from one table to another

On Sun, 2024-10-13 at 06:24 +0000, Sabyasachi Mukherjee wrote:
> To copy the data - the command that I am trying to execute is (Insert int=
o ...(Select * from )) using PGAdmin
>
> The command fails every time.
>
> ERROR:  Failed on request of size 1048576 in memory context "AfterTrigger=
Events".out of memory
> ERROR:  out of memory
> SQL state: 53200
> Detail: Failed on request of size 1048576 in memory context "AfterTrigger=
Events".

You have a row level AFTER INSERT trigger on the destination table.
Try without the trigger.

Yours,
Laurenz Albe


--_000_MN0PR20MB49128874B7C246293B856A3B87452MN0PR20MB4912namp_
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<html>
<head>
<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Dus-ascii"=
>
</head>
<body>
<div dir=3D"auto">Check if you have foreign table references and they shoul=
d hold on delete cascade that should resolve data being dupliated</div>
<div><br>
</div>
<div id=3D"ms-outlook-mobile-signature" dir=3D"auto">Sent from <a href=3D"h=
ttps://aka.ms/AAb9ysg">
Outlook for Android</a></div>
<hr style=3D"display:inline-block;width:98%" tabindex=3D"-1">
<div id=3D"divRplyFwdMsg" dir=3D"ltr"><font face=3D"Calibri, sans-serif" st=
yle=3D"font-size:11pt" color=3D"#000000"><b>From:</b> Laurenz Albe &lt;laur=
enz.albe@cybertec.at&gt;<br>
<b>Sent:</b> Monday, October 14, 2024 12:06:08 PM<br>
<b>To:</b> Sabyasachi Mukherjee &lt;mukherjee.sabyasachi@outlook.com&gt;; p=
gsql-admin@lists.postgresql.org &lt;pgsql-admin@lists.postgresql.org&gt;<br=
>
<b>Subject:</b> Re: Loading data from one table to another</font>
<div>&nbsp;</div>
</div>
<div class=3D"BodyFragment"><font size=3D"2"><span style=3D"font-size:11pt;=
">
<div class=3D"PlainText">On Sun, 2024-10-13 at 06:24 +0000, Sabyasachi Mukh=
erjee wrote:<br>
&gt; To copy the data - the command that I am trying to execute is (Insert =
into ...(Select * from )) using PGAdmin<br>
&gt; <br>
&gt; The command fails every time.<br>
&gt; <br>
&gt; ERROR: &nbsp;Failed on request of size 1048576 in memory context &quot=
;AfterTriggerEvents&quot;.out of memory<br>
&gt; ERROR: &nbsp;out of memory<br>
&gt; SQL state: 53200<br>
&gt; Detail: Failed on request of size 1048576 in memory context &quot;Afte=
rTriggerEvents&quot;.<br>
<br>
You have a row level AFTER INSERT trigger on the destination table.<br>
Try without the trigger.<br>
<br>
Yours,<br>
Laurenz Albe<br>
<br>
<br>
</div>
</span></font></div>
</body>
</html>

--_000_MN0PR20MB49128874B7C246293B856A3B87452MN0PR20MB4912namp_--