From: | Joe Conway <mail(at)joeconway(dot)com> |
---|---|
To: | Aleš Zelený <zeleny(dot)ales(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>, Michael Paquier <michael(at)paquier(dot)xyz>, "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | Re: PostgreSQL 14.4 ERROR: out of memory issues |
Date: | 2022-08-04 21:15:09 |
Message-ID: | 40a48d9d-a324-f69c-5ab6-5afb9050176e@joeconway.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 8/4/22 08:34, Aleš Zelený wrote:
>> SELECT ... simple join of two tables...
>> WHERE opd.id_data_provider = _id_data_provider
>> AND CASE WHEN _external_id IS NULL
>> THEN external_id IS NULL
>> ELSE external_id = _external_id
>> END
>> AND CASE WHEN _external_complete_id IS NULL
>> THEN _external_complete_id IS NULL
Unrelated to your question, but shouldn't that actually read:
AND CASE WHEN _external_complete_id IS NULL
THEN external_complete_id IS NULL
^^^
>> ELSE external_complete_id = _external_complete_id
>> END;
>> $function$
--
Joe Conway
RDS Open Source Databases
Amazon Web Services: https://aws.amazon.com
From | Date | Subject | |
---|---|---|---|
Next Message | Jan Wieck | 2022-08-04 23:57:22 | Re: Purpose of DEFERRABLE _and_ INITIALLY DEFERRED foreign key constraint checking? |
Previous Message | abrahim abrahao | 2022-08-04 20:47:16 | sequence id overflow ERROR using timescaledb |