John Pena
04/19/2021, 8:36 PMTransaction attempt #0 failed: org.postgresql.util.PSQLException: ERROR: operator does not exist: "MyEnumColumn" = character varying\n Hint: No operator matches the given name and argument types. You might need to add explicit type casts
Emil Kantis
04/19/2021, 8:40 PMJohn Pena
04/19/2021, 8:47 PMEmil Kantis
04/19/2021, 8:48 PMJohn Pena
04/19/2021, 8:48 PMEmil Kantis
04/19/2021, 8:53 PMcreate table my_things
(
my_field varchar(32) character varying not null,
);
John Pena
04/19/2021, 8:55 PMCREATE TYPE "public"."MyField" AS ENUM ('X', 'Y', 'Z');
-- Table Definition
CREATE TABLE "public"."MyTable" (
"myField" "public"."MyField" NOT NULL
)
Emil Kantis
04/19/2021, 8:59 PMCREATE TABLE "public"."MyTable" (
"myField" varchar(32) NOT NULL
)
John Pena
04/19/2021, 9:00 PMEmil Kantis
04/19/2021, 9:01 PMJohn Pena
04/19/2021, 9:06 PM