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 ) id 1t0Egi-00ABRX-2X for pgsql-admin@arkaria.postgresql.org; Mon, 14 Oct 2024 06:36:16 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1t0Egf-00AdwS-Cn for pgsql-admin@arkaria.postgresql.org; Mon, 14 Oct 2024 06:36:13 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1t0Egf-00AdwE-07 for pgsql-admin@lists.postgresql.org; Mon, 14 Oct 2024 06:36:13 +0000 Received: from mail-ej1-x634.google.com ([2a00:1450:4864:20::634]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1t0Egb-000xfH-8o for pgsql-admin@lists.postgresql.org; Mon, 14 Oct 2024 06:36:12 +0000 Received: by mail-ej1-x634.google.com with SMTP id a640c23a62f3a-a9a156513a1so45918866b.0 for ; Sun, 13 Oct 2024 23:36:09 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec.at; s=cybertec.at; t=1728887769; x=1729492569; darn=lists.postgresql.org; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:from:to:cc:subject:date :message-id:reply-to; bh=fLwvOobVGW68wCG9GPyUbpZWr7zHu2EuYOC2QrHk4ts=; b=XUXRKRT/jGC8vZNJL+bZ51eXMu5mrNoNkWr8N9jBTMKw7x61CybFYLr5QbCbrJer1V 5sDihM5xzPAYN4zBozK3dNcOE2EqhfBT0/WHXGnwIEPK2wjEEfaOhUd0asoHh2vNfKcB c1bNwUAI9OR/zjjXLmpAHwaGwTmqfyjAduI5w= X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1728887769; x=1729492569; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=fLwvOobVGW68wCG9GPyUbpZWr7zHu2EuYOC2QrHk4ts=; b=o1/liE5a42PXyl9797xFiAzUnM+jLt9g1pL61seNhZzgldwc6CAeo6SxS57XLVT9/R KrvH+obk2p7ulWWsuldxClozYQhGLvUCISfUOqjOvSJvFEEjGJgWtyld9ZQAT1LZHxj4 9ih9zyi42t06TTy51+Oq4pIkL8xcA/J5y5LFkMycJUuWyz8gfyHp5HlvHNb/BhbTFlbM BW9fF3ds1F/tbts2IeVoQqxI4HXR4g1T6VAVh1kYPXEkfpUyKmllCDFYLuvCfAYVBxlz hcN5WYBWu4dPqCPb61jDKLuJYwmdjsGdxFFTKQ3257fvpjlXnG8wzFVIQRhUF4fmm/As Dm/g== X-Forwarded-Encrypted: i=1; AJvYcCVIWY+z8BU47iyQKPKXPC72Wcy6KoXzXNTnZYgHKfcn3toLHOGvExBWqtmA3EsOqHoZVkKlHlSlGYiBlw==@lists.postgresql.org X-Gm-Message-State: AOJu0YxrRK9s8z3/aUWyf+fM9td5/fDVDDpoaifBe6dSluUxrsQeRl7Y PtGRmusOXO0OEZlpqQ3VSrOc+tTR0i23VoE6BdIxKYnyTJMVQLgoleo6NGOwzZ8= X-Google-Smtp-Source: AGHT+IGgL1xQI4FHQ5XwWJmminkdDROaT7B5VVmy8ENB281p00yEJ+6WdJmxY7MaymdafzQ63CFL8g== X-Received: by 2002:a17:906:478d:b0:a99:7c14:9197 with SMTP id a640c23a62f3a-a99b95ebbf7mr681601866b.64.1728887768996; Sun, 13 Oct 2024 23:36:08 -0700 (PDT) Received: from dynamic-pd01.res.v6.highway.a1.net ([2001:871:260:536:206a:2b5b:d652:a7f2]) by smtp.gmail.com with ESMTPSA id a640c23a62f3a-a99a7f27f05sm529403866b.83.2024.10.13.23.36.08 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Sun, 13 Oct 2024 23:36:08 -0700 (PDT) Message-ID: Subject: Re: Loading data from one table to another From: Laurenz Albe To: Sabyasachi Mukherjee , "pgsql-admin@lists.postgresql.org" Date: Mon, 14 Oct 2024 08:36:08 +0200 In-Reply-To: References: Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.52.4 (3.52.4-1.fc40) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk 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 >=20 > The command fails every time. >=20 > ERROR: =C2=A0Failed on request of size 1048576 in memory context "AfterTr= iggerEvents".out of memory > ERROR: =C2=A0out 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