Re: Loading data from one table to another

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

Sent from Outlook for Android<https://aka.ms/AAb9ysg>
________________________________
From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
Sent: Monday, October 14, 2024 12:06:08 PM
To: Sabyasachi Mukherjee <mukherjee(dot)sabyasachi(at)outlook(dot)com>; pgsql-admin(at)lists(dot)postgresql(dot)org <pgsql-admin(at)lists(dot)postgresql(dot)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 into ...(Select * from )) using PGAdmin
>
> The command fails every time.
>
> ERROR: Failed on request of size 1048576 in memory context "AfterTriggerEvents".out of memory
> ERROR: out of memory
> SQL state: 53200
> Detail: Failed on request of size 1048576 in memory context "AfterTriggerEvents".

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

Yours,
Laurenz Albe