infinite loop in an update statement

From: Fabrice Chapuis <fabrice636861(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: infinite loop in an update statement
Date: 2024-09-09 14:55:01
Message-ID: CAA5-nLDmkuRbjHJvf2-Sz0FxtJtoFdrg4mUTy6N84UpZtGZJwQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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)

Regards,

Fabrice

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Achilleas Mantzios - cloud 2024-09-09 14:59:46 Re: Strange permission effect depending on DEFERRABILITY
Previous Message Koen De Groote 2024-09-09 14:36:26 Logical replication without direct link between publisher and subscriber?