From: | Euler Taveira <euler(at)timbira(dot)com> |
---|---|
To: | rmitchell(at)bzzagent(dot)com |
Cc: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: BUG #7734: JPA2/Hibernate4 PG enum insert causes exception |
Date: | 2012-12-10 12:51:31 |
Message-ID: | 50C5DAD3.2010606@timbira.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
On 05-12-2012 18:54, rmitchell(at)bzzagent(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | postgres | 2012-12-10 18:41:29 | BUG #7750: pid file conflict in RedHat |
Previous Message | Abhishek Ramkumar | 2012-12-10 10:24:07 | error |