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 1u5irz-004s4Q-Jx for pgsql-general@arkaria.postgresql.org; Fri, 18 Apr 2025 10:22:52 +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 1u5irv-00BPkC-9z for pgsql-general@arkaria.postgresql.org; Fri, 18 Apr 2025 10:22:48 +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 ) id 1u5iru-00BPhp-Tm for pgsql-general@lists.postgresql.org; Fri, 18 Apr 2025 10:22:47 +0000 Received: from mail-wm1-x336.google.com ([2a00:1450:4864:20::336]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1u5irt-000gvZ-1E for pgsql-general@postgresql.org; Fri, 18 Apr 2025 10:22:46 +0000 Received: by mail-wm1-x336.google.com with SMTP id 5b1f17b1804b1-4394a0c65fcso17855165e9.1 for ; Fri, 18 Apr 2025 03:22:45 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec.at; s=google; t=1744971764; x=1745576564; darn=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=Vq0vWBJ6yDzRJclOXpzohSkpS+71OyAx/YHxqxpes6A=; b=mGQ9eYHSkOY3nzdnnGSarnwQt0uRruetDYnrkR/HIoP73Nw1rHtoiRyYBLBgcj6MHm 5tFcbuf5h5+k+87KpVdB19kqxcxW8+bTpPbv7eUk++Ku3H1xAO78nE6iWMYhdeJX7969 SZ3R1eV2uWKyiIwRwkSG7jJhaT4sBkaTCNGaf0i8OYPcbhQhmUDCWzW1oZTuk99l/WaM xgf+pjUGkOhTrAohlUNVD2OMj0wVP3rCVu7mJJXWFhJxRjQv6JjqJpxEE/o/m+oHsITx wTEjUZV8yatf1h3NkT77cwlrKSf6Zc+ij54Gp3/hJpZFlLgseLj0ulrcD3cjc+lezR0k /Wbg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1744971764; x=1745576564; 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=Vq0vWBJ6yDzRJclOXpzohSkpS+71OyAx/YHxqxpes6A=; b=gt2WvGIIzLtfHBnwIvMydS+ry9scO/NDlGxwQ4NjtT00g2F89Kg16dCnoT3hZkSwZB ulBoEIVRMiCcgzsDWbMGmJnaGasFWVMv5fYjfbwqQolZ6KqbWWyZf46PejKv/dLMG9Su 2kZDZ1PxVQCmPbHHXY452dktprT14f0J7aRHDWhy84SyzfPTH89XLuOUKYwL+XisHNnT 7IpTu6cpthXJ08Er7Y3GPiBtTWt9VONrs1ZUC5Y6FwxfcGwuHZxiNX/Fbai7xkJR6Ddn Z6jREgr1/TMZ4p/a1W8sJB5RJrIEIiWdGHO2pbbo8hjd+04AMfHDcAlmKyncv7GQH7nv 825A== X-Forwarded-Encrypted: i=1; AJvYcCUq1grxqpE6ELXc+WwgPijxAp2ArLBI8i58hsUgv2rn+h6fZm6hsLb+4Xam6CjvpgZjcJ7ja79xAXarBCv+@postgresql.org X-Gm-Message-State: AOJu0YyN1tb6gZSIS9KeNy/jTVIYoLgKuul0N9ot0AxyzzTVZMdUxAaH it6Wj9qMdMTixilpWvAc55+GrCurxFM0ymcYpAmWvccM1aqBel1qUPKyS6aiQdhkUDSi5IPcaDm m X-Gm-Gg: ASbGncuvOliMrBdCOApp55cI2p25R4Kau72rPvpyUNODt8WaRyEHdDmayaCboJv8li8 d7YvSM03Mz6cmP8MdciQj9wajTxZP5q+29oWmrqezkZzisrdH2m4s+7SCywbPIninXNtOECWk7w xUR5YMIGaaNQ6bJynA+FMdNePKboDreau85IbPyB33HX09l0GhgAYvukRqJ6oKleRLSkkEiHf4z NHrHhr4ZEyoaRa4ZV8XhPBRNLPsnNmHhVLawZme0FSxnMYGrhUoCiQgWJRIN9B7CZ/fVURTXkk5 WudqUOgqRR8tbZHSCujPxPKQ/D2MqlWJ5/G0oS1vYPMOFTz3Li8hYR6hqm42 X-Google-Smtp-Source: AGHT+IFyClBf5gweQot7azR9xMudfW8Kq0i4fCat1EZHRZ5RE7Vfov2i8DQX9tu7pbYv65LIsXL13A== X-Received: by 2002:a5d:64e2:0:b0:39c:16a0:feef with SMTP id ffacd0b85a97d-39efbadeacemr1616379f8f.38.1744970293033; Fri, 18 Apr 2025 02:58:13 -0700 (PDT) Received: from localhost.localdomain ([2001:871:5e:5373:9d9a:af04:78c5:75aa]) by smtp.gmail.com with ESMTPSA id ffacd0b85a97d-39efa4207e6sm2265275f8f.7.2025.04.18.02.58.12 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Fri, 18 Apr 2025 02:58:12 -0700 (PDT) Message-ID: <24bb716bbdb6dbb8ac02c501db26731a101d21d3.camel@cybertec.at> Subject: Re: Error while updating a table From: Laurenz Albe To: "sivapostgres@yahoo.com" , Pgsql-general Date: Fri, 18 Apr 2025 11:58:11 +0200 In-Reply-To: <1852089030.3173833.1744961512201@mail.yahoo.com> References: <1385521371.3160626.1744955370756.ref@mail.yahoo.com> <1385521371.3160626.1744955370756@mail.yahoo.com> <02e2740edf821e2ce84773c83065b45e9be890cc.camel@cybertec.at> <1852089030.3173833.1744961512201@mail.yahoo.com> Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.54.3 (3.54.3-1.fc41) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Fri, 2025-04-18 at 07:31 +0000, sivapostgres@yahoo.com wrote: > For the second part, how to identify that culprit query? If the query caused an error, and you left "log_min_messages" at the default setting, the error and the statement that caused it should be in the PostgreSQL log. Yours, Laurenz Albe