Postgres 9.6

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 f(int)
returns int
language sql
as 'select $1';

CREATE FUNCTION


do $$
begin
  create function f (int)
  returns int
  language sql
  as 'select $1';
end; $$

ERROR:  function "f" already exists with same argument types
CONTEXT:  SQL statement "create function f (int)
  returns int
  language sql
  as 'select $1'"
PL/pgSQL function inline_code_block line 3 at SQL statement


do $$
begin
    create function f (int)
    returns int
    language sql
    as 'select $1';
    

  exception
    when duplicate_function then
    null;
end; $$
    

DO