BUG #1646: ERROR: column "mycolumn" is of type boolean but expression is of type character
От | Kjh |
---|---|
Тема | BUG #1646: ERROR: column "mycolumn" is of type boolean but expression is of type character |
Дата | |
Msg-id | 20050504121830.42759F0B10@svr2.postgresql.org обсуждение исходный текст |
Ответы |
Re: BUG #1646: ERROR: column "mycolumn" is of type boolean
|
Список | pgsql-bugs |
The following bug has been logged online: Bug reference: 1646 Logged by: Kjh Email address: kjh@networks.nera.no PostgreSQL version: 8.0 Operating system: windows XP Description: ERROR: column "mycolumn" is of type boolean but expression is of type character Details: newest drivers (JDBC3) deployed it with JBoss 3.2.6 Indeed, the entity bean has fields of java-type Boolean and the database has fields of type boolean, but the application server seems to send it to the database as "true" or "false" strings. That is what the errormessage indicates to me anyway: ERROR: column "mycolumn" is of type boolean but expression is of type character. (Though I am not aware of how to verify this other than changing column type varchar(5) which I have tried - unfortunately, this had lots of other undesired side-effects even though it worked in some cases.) Entity beans with Boolean types works fine with mysql and mssql, though with the BIT type in the database, instead of boolean. However, if I try to use the BIT type, I bump into another error: My data base SEED TOOL fails to load data with the following error ERROR: column "mycolumn" is of type bit but expression is of type boolean sigh(!) please help. Kjetil
В списке pgsql-bugs по дате отправления: