Re: Delete from table where id in (bugged query) - fully remove all data without any notice.

From: Pantelis Theodosiou <ypercube(at)gmail(dot)com>
To: Kostya M <kostya27(at)gmail(dot)com>, PostgreSQL mailing lists <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: Delete from table where id in (bugged query) - fully remove all data without any notice.
Date: 2022-10-21 23:22:51
Message-ID: CAE3TBxxRr0o9REYjwmEy-WEeqvhGO6QYgpv+ohmiHZE1-Ai6=Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Fri, Oct 21, 2022 at 11:38 PM Kostya M <kostya27(at)gmail(dot)com> wrote:
>
> Ok, thanks.
> For me even this scope resolution looks quite strange and unexpected.
>

See also the FAQ entry for this question:

https://wiki.postgresql.org/wiki/FAQ#Why_doesn.27t_PostgreSQL_report_a_column_not_found_error_when_using_the_wrong_name_in_a_subquery.3F

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message PG Bug reporting form 2022-10-22 11:55:24 BUG #17660: JSONPATH issue using like_regex followed by the && operator
Previous Message Pantelis Theodosiou 2022-10-21 21:08:28 Re: Delete from table where id in (bugged query) - fully remove all data without any notice.