Re: Error while updating a table

 So far, I couldn't find the query that caused the error.   Is there any way to unlock it?  
Re-start, Format and fresh install of windows, etc. ?
Happiness Always
BKR Sivaprakash
    On Friday 18 April, 2025 at 04:50:52 pm IST, sivapostgres@yahoo.com <sivapostgres@yahoo.com> wrote:  
 
  If the query caused an error ....
Does it mean that other reasons might also be there?
Nevertheless, I'll check the log file to find the query...
Happiness Always
BKR Sivaprakash
    On Friday 18 April, 2025 at 03:53:06 pm IST, Laurenz Albe <laurenz.albe@cybertec.at> wrote:  
 
 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