Postgres 15

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

Help with an interesting Postgres question: Why isn't an Index Only Scan used on a partition accessed via the parent table?.

CREATE FUNCTION public.test() RETURNS int LANGUAGE SQL RETURN NULL::int;

CREATE FUNCTION

SELECT 'public.test'::regproc::oid

oid

8681686

SELECT 1

CREATE FUNCTION public.test(a int, b int) RETURNS integer LANGUAGE SQL RETURN a + b;

CREATE FUNCTION

SELECT 'public.test'::regproc::oid;

ERROR:  more than one function named "public.test"
LINE 1: SELECT 'public.test'::regproc::oid;
               ^

SELECT 'public.test()'::regprocedure::oid;
SELECT 'public.test(int, int)'::regprocedure::oid;

oid

8681686

SELECT 1

oid

8681687

SELECT 1