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 TYPE name AS ENUM('name1', 'name2');

CREATE TABLE Employee1(
    ID integer, 
    myname name
);

INSERT INTO Employee1 VALUES
(1, 'AAAA');

SELECT * FROM Employee1

id
myname

1
AAAA

SELECT 1

CREATE TYPE name_type AS ENUM('name1', 'name2');

CREATE TABLE Employee2(
    ID integer, 
    myname name_type
);

INSERT INTO Employee2 VALUES
(1, 'AAAA');

SELECT * FROM Employee2

ERROR:  invalid input value for enum name_type: "AAAA"
LINE 9: (1, 'AAAA');
            ^

CREATE TYPE name_type AS ENUM('name1', 'name2');

CREATE TABLE Employee2(
    ID integer, 
    myname name_type
);

INSERT INTO Employee2 VALUES
(1, 'name1');

SELECT * FROM Employee2

id
myname

1
name1

SELECT 1