Postgres 11

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 OR REPLACE FUNCTION insertTest(
IN ID1 integer, 
IN Value1 character varying,
IN Value2 character varying,
IN Value3 character varying,
IN Status character varying,
IN Active_Flag integer, 
IN Stuff1 smallint,
IN stuff2 smallint)
RETURNS text
LANGUAGE plpgsql
AS $BODY$
BEGIN
   RETURN 'Found.';
END;
$BODY$;
SELECT castsource::regtype, casttarget::regtype, castcontext
FROM   pg_cast
WHERE  castsource = 'int'::regtype
AND    casttarget = 'int2'::regtype;


castsource
casttarget
castcontext


integer
smallint
a


SELECT * FROM insertTest (
550, 'Test_Value1', 
'Test_Value2', 'Test_Value3', 
'DEL', 55, 1, 1);
ERROR:  function inserttest(integer, unknown, unknown, unknown, unknown, integer, integer, integer) does not exist
LINE 1: SELECT * FROM insertTest (
                      ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.


SELECT * FROM insertTest (
550, 'Test_Value1', 
'Test_Value2', 'Test_Value3', 
'DEL', 55, int2 '1', int2 '1');


inserttest


Found.


SELECT * FROM insertTest (
550, 'Test_Value1', 
'Test_Value2', 'Test_Value3', 
'DEL', 55, '1', '1');


inserttest


Found.