Feedback-ID: i76984098:Fastmail
Message-ID: <0bd0a3be-b181-4ac7-bb9e-6ee5aec35d6c@aklaver.com>
Date: Tue, 10 Sep 2024 07:57:40 -0700
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: infinite loop in an update statement
To: Fabrice Chapuis <fabrice636861@gmail.com>
References: <CAA5-nLDmkuRbjHJvf2-Sz0FxtJtoFdrg4mUTy6N84UpZtGZJwQ@mail.gmail.com>
 <4f5c2262-f869-4707-93cb-735267903da4@aklaver.com>
 <CAA5-nLDjpv8eLeZDAr28xtefP4qYGr2g-5vgxf01Z5DojZ4HSg@mail.gmail.com>
Content-Language: en-US
Cc: pgsql-general <pgsql-general@postgresql.org>
From: Adrian Klaver <adrian.klaver@aklaver.com>
In-Reply-To: <CAA5-nLDjpv8eLeZDAr28xtefP4qYGr2g-5vgxf01Z5DojZ4HSg@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Archived-At: <https://www.postgresql.org/message-id/0bd0a3be-b181-4ac7-bb9e-6ee5aec35d6c%40aklaver.com>
Precedence: bulk

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