Re: [BUGS] BUG #14712: postgres how to handle boolean datatype to use0 and 1 using hibernate

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: [BUGS] BUG #14712: postgres how to handle boolean datatype to use0 and 1 using hibernate
Дата
Msg-id CAKFQuwbn38OXfnz0pUH=aYsQ--tcrb0jU+VQ3gawyYZzvbKLrA@mail.gmail.com
обсуждение исходный текст
Ответ на [BUGS] BUG #14712: postgres how to handle boolean datatype to use 0 and 1using hibernate  (aprasad@flexerasoftware.com)
Список pgsql-bugs
Дерево обсуждения
On Mon, Jun 19, 2017 at 12:09 AM, <aprasad@flexerasoftware.com> wrote:
The following bug has been logged on the website:

Bug reference:      14712
Logged by:          Akanksha Prasad
Email address:      aprasad@flexerasoftware.com
PostgreSQL version: 9.6.2
Operating system:   windows 7
Description:

I wanted to use boolean withd efault value as 1 in hbm file , the hibernate
generates the ddl for sql server and oracle and they both works fine but
postgres fails with error as cannot have int default 1 as value for boolean
field.
Please help with this. How can i do this with changes only at the dialect
level beacuse changing the application me too many changes and that too sql
server and oracle databases with fail.

​Please send non-bug-report questions to pgsql-general@postgresql.org or a more appropriate list if there is one.

Thank You.

David J.

p.s. It sounds to me, though, that if Hibernate is translating between dialects that you should be able to specify "default true" for your boolean column and let it make that work with the other DBMSes - a true boolean column only stores "True" and "False" by definition.
​

В списке pgsql-bugs по дате отправления:

Предыдущее
От: josef.machytka@gmail.com
Дата:
Сообщение: [BUGS] BUG #14714: long running sessions from remote instance seems to hangsome times
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [BUGS] BUG #14714: long running sessions from remote instance seems to hang some times