On 05-12-2012 18:54, rmitch...@bzzagent.com wrote: [This is not a PostgreSQL bug. It seems a limitation/bug in Hibernate dialect.]
> insert into my_table (gender) values ('male'); > insert into my_table (gender) values ('female'); > insert into my_table (gender) values ('unknown'); > s/gender/gender_type/ > Caused by: org.postgresql.util.PSQLException: ERROR: column “gender_type” is > of type GENDER_ENUM but expression is of type character varying > Hint: You will need to rewrite or cast the expression. > What is the SQL generated by Hibernate? It seems it is casting the expression to varchar like: insert into my_table (gender_type) values ('male'::varchar); -- Euler Taveira de Oliveira - Timbira http://www.timbira.com.br/ PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs