BUG #4631: Hibernate Restriction bigint~~bigint - Mailing list pgsql-bugs

The following bug has been logged online:

Bug reference:      4631
Logged by:          Hauke Runge
Email address:      runge@tembit.de
PostgreSQL version: 8.3
Operating system:   XP professional
Description:        Hibernate Restriction bigint~~bigint
Details:

Developing a project with spring, struts, hibernate 3.2 and a postgres 8.1
we were using hibernateCallback like this:

HibernateCallback callback = new HibernateCallback() {
            public Object doInHibernate(Session session) throws
HibernateException, SQLException {
                Criteria ct = session.createCriteria(Reminder.class);

                ct.add(Restrictions.like("user", reminder.getPatient()));
                ct.add(Restrictions.like("suitId", reminder.getSuitId()));

                return ct.list();
            }
        };

this was working very well. Changing to postgreSql 8.3 we got the following
error:
ERROR: operator does not exist: bigint ~~ bigint

we changed the jdbc driver to the latest jdbc3 driver - but the error was
the same.


I think, this could be a bug.