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.
