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

CREATE PROCEDURE

ERROR:  relation "student" does not exist
LINE 1: INSERT INTO student(
                    ^
QUERY:  INSERT INTO student(
    "fName", "sName", "patronymic", "DoB", "group", instructor)
    VALUES (fName_val, sName_val, patr_val, DoB_val, GROUP_ID,instructor_id)
CONTEXT:  PL/pgSQL function "saveStudent"(character varying,character varying,character varying,date,integer,integer) line 2 at SQL statement

ERROR:  procedure saveStudent(character varying, character varying, character varying, date, integer, integer) does not exist
LINE 1: CALL "saveStudent" (
             ^
HINT:  No procedure matches the given name and argument types. You might need to add explicit type casts.