Postgres Pro
Downloads
Home   >   mailing lists

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

From Pantelis Theodosiou
Subject Re: Delete from table where id in (bugged query) - fully remove all data without any notice.
Date
Msg-id CAE3TBxxRr0o9REYjwmEy-WEeqvhGO6QYgpv+ohmiHZE1-Ai6=Q@mail.gmail.com
Whole thread Raw
In response to Delete from table where id in (bugged query) - fully remove all data without any notice.  (Kostya M <kostya27@gmail.com>)
List pgsql-bugs
Tree view 
On Fri, Oct 21, 2022 at 11:38 PM Kostya M <kostya27@gmail.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

pgsql-bugs by date:

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