Postgres 12

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?.

select version();


version


PostgreSQL 12.6 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.3.1 20191121 (Red Hat 8.3.1-5), 64-bit


CREATE OR REPLACE FUNCTION /* public. */ create_databaseuser(
username name,
pass text)
RETURNS /* smallint */ TEXT
LANGUAGE 'plpgsql'
COST 100
VOLATILE STRICT SECURITY DEFINER PARALLEL UNSAFE
AS $BODY$
declare
begin
/* execute */
 RETURN format('CREATE USER "%I" with password ''%I'' 
                LOGIN 
                NOSUPERUSER 
                INHERIT 
                NOCREATEDB 
                NOCREATEROLE 
                REPLICATION ;', username, pass);
/* return 1; */
exception 
when others then
    return /* 0 */ '0';
end;
$BODY$;
SELECT /* public. */ create_databaseuser('sid',  '1');


create_databaseuser


CREATE USER "sid" with password '"1"' 
                LOGIN 
                NOSUPERUSER 
                INHERIT 
                NOCREATEDB 
                NOCREATEROLE 
                REPLICATION ;