signal 11: Segmentation fault ; query constraint list; pg16.3 - Mailing list pgsql-general

From milist ujang
Subject signal 11: Segmentation fault ; query constraint list; pg16.3
Date
Msg-id CACG9ogyCjz6yBKBuTX=686CypkgQj+RjrtAw2Skj1Q=0AxxG3Q@mail.gmail.com
Whole thread Raw
Responses Re: signal 11: Segmentation fault ; query constraint list; pg16.3
List pgsql-general
postgres 16.1; rocky 9.3

when connect to database postgres this query is OK, but run on user database, got segmentation fault.


2024-05-20 17:16:54.942 WIB,,,134291,,6648420a.20c93,165,,2024-05-18 12:52:10 WIB,,0,LOG,00000,"server process (PID 487952) was terminated by signal 11: Segmentation fault","Failed process was running: select
    ct.conname as constraint_name,
    a.attname as column_name,
    fc.relname as foreign_table_name,
    fns.nspname as foreign_table_schema,
    fa.attname as foreign_column_name
from
    (SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s
       FROM pg_constraint ct
    ) AS ct
    inner join pg_class c on c.oid=ct.conrelid
    inner join pg_namespace ns on c.relnamespace=ns.oid
    inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s]
    left join pg_class fc on fc.oid=ct.confrelid
    left join pg_namespace fns on fc.relnamespace=fns.oid
    left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s]
where
    ct.contype='f'
    and c.relname='table1'
    and ns.nspname='schemauser'
order by
    fns.nspname, fc.relname, a.attnum
;",,,,,,,,"","postmaster",,0

2024-05-20 17:16:54.942 WIB,,,134291,,6648420a.20c93,166,,2024-05-18 12:52:10 WIB,,0,LOG,00000,"terminating any other active server processes",,,,,,,,,"","postmaster",,0

--
regards

ujang jaenudin | Self-Employed, DBA Consultant
http://id.linkedin.com/pub/ujang-jaenudin/12/64/bab

pgsql-general by date:

Previous
From: Laura Smith
Date:
Subject: How to update upper-bound of tstzrange ?
Next
From: PetSerAl
Date:
Subject: Re: pg_dump and not MVCC-safe commands