Postgres Pro
Downloads
Home   >   mailing lists

Re: infinite loop in an update statement - Mailing list pgsql-general

From Adrian Klaver
Subject Re: infinite loop in an update statement
Date
Msg-id 0bd0a3be-b181-4ac7-bb9e-6ee5aec35d6c@aklaver.com
Whole thread Raw
In response to infinite loop in an update statement  (Fabrice Chapuis <fabrice636861@gmail.com>)
List pgsql-general
Tree view 
On 9/10/24 07:47, Fabrice Chapuis wrote:
Reply to list also
Ccing list

> no trigger on theses tables

> 
> On Mon, Sep 9, 2024 at 5:00 PM Adrian Klaver <adrian.klaver@aklaver.com 
> <mailto:adrian.klaver@aklaver.com>> wrote:
> 
>     On 9/9/24 07:55, Fabrice Chapuis wrote:
>      > Hi,
>      >
>      > table a and b are empty, this query does not return. It seems we
>     enter
>      > in infinite loop.
>      > why this update does not return instantly?
>      >
>      > UPDATE table_a a
>      >   SET col1 = (SELECT MIN(b.col1)
>      >                      FROM table_b b
>      >                      WHERE b.col2 = a.col2)
> 
>     Do you have an UPDATE trigger on table_a?
> 
>      >
>      > Regards,
>      >
>      > Fabrice
>      >
>      >
> 
>     -- 
>     Adrian Klaver
>     adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
> 

-- 
Adrian Klaver
adrian.klaver@aklaver.com

pgsql-general by date:

Previous
From: Pecsök Ján
Date:
Subject: Error:could not extend file " with FileFallocate(): No space left on device
Next
From: Rich Shepard
Date:
Subject: Removing duplicate rows in table