Message-ID: <05820f63079333ff7e475e61b44c8378a03aa8e2.camel@cybertec.at>
Subject: Re:  Error while updating a table
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: "sivapostgres@yahoo.com" <sivapostgres@yahoo.com>, Pgsql-general
	 <pgsql-general@postgresql.org>
Date: Sat, 19 Apr 2025 14:55:12 +0200
In-Reply-To: <45879321.3496225.1745066329503@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>
	 <24bb716bbdb6dbb8ac02c501db26731a101d21d3.camel@cybertec.at>
	 <1365122733.3205645.1744975213857@mail.yahoo.com>
	 <45879321.3496225.1745066329503@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
Archived-At: <https://www.postgresql.org/message-id/05820f63079333ff7e475e61b44c8378a03aa8e2.camel%40cybertec.at>
Precedence: bulk

On Sat, 2025-04-19 at 12:38 +0000, sivapostgres@yahoo.com wrote:
> So far, I couldn't find the query that caused the error.=C2=A0 =C2=A0Is t=
here any way to unlock it?=C2=A0=C2=A0
>=20
> Re-start, Format and fresh install of windows, etc. ?

On Windows you have to reboot, bow three times toward sunset,
say a prayer to Bill Gates, then reboot again.

No, seriously: randomly messing around with your machine rarely ever
gets you closer to a solution.

If you get the error

  current transaction is aborted, commands ignored until end of transaction=
 block

it is 100% clear that an earlier statement in the same transaction must
have got an error.  Write your application so that it logs *every* error
that comes from the database, then you are sure to catch that error.

Also, if "log_min_messages" is "warning" (the default) or "error", you
will find the error in the PostgreSQL log.  That's all I can say to you.

Yours,
Laurenz Albe