Re: [BUGS] BUG #4559: performance issue

2008-12-18 Thread Craig Ringer
M. Alaa ElGohary wrote: > The following bug has been logged online: > > Bug reference: 4559 > Logged by: M. Alaa ElGohary > Email address: alaa.elgoh...@backandfront.ws > PostgreSQL version: 7.4.19 > Operating system: FreeBSD 6.3 > Description:performance issue > Detai

[BUGS] BUG #4583: Db stop

2008-12-18 Thread Bruno Pimenta
The following bug has been logged online: Bug reference: 4583 Logged by: Bruno Pimenta Email address: brunofpime...@gmail.com PostgreSQL version: 8.1.4 Operating system: Windows 2003 Server SP2 Description:Db stop Details: I have a system in Java and I'm using the P

Re: [BUGS] Page header error on PGSQL 7.4.5

2008-12-18 Thread Heikki Linnakangas
Богданов В. wrote: We have PostgreSQL v. 7.4.5 and main application working with PGSQL via libpq. Linux kernel 2.6.17.14 7.4.5 is very old. The latest minor version of the 7.4 series is 7.4.23. There has been a lot of bug fixes in between; you really should upgrade. We encounter page header

[BUGS] BUG #4588: post gres installation problem

2008-12-18 Thread raghavendra
The following bug has been logged online: Bug reference: 4588 Logged by: raghavendra Email address: raghavend...@integramicro.com PostgreSQL version: 8.3 Operating system: windows 2003 standard edition with sp2 Description:post gres installation problem Details: Whe

Re: [BUGS] BUG #4586: Supporting of Binary instead Bytea for Primary Keys

2008-12-18 Thread Miroslav Nachev
Hi, This is very good. Can you give me some idea how to use that feature together with Hibernate JPA? Is there some special annotation or ? Regards, Miro. Kris Jurka wrote: On Wed, 17 Dec 2008, Miroslav Nachev wrote: Thank you very much. How can I map PostgreSQL UUID to JPA Hibernate with

Re: [BUGS] BUG #4586: Supporting of Binary instead Bytea for Primary Keys

2008-12-18 Thread Miroslav Nachev
Yes, you are right. With the correct code: public static void main(String[] args) { UUID uuid = UUID.randomUUID(); TestTable1 testTable = new TestTable1(uuid); persist(testTable); } the exception is: Hibernate: insert into test_db.public.test_table_1 (description, my_id

Re: [BUGS] BUG #4586: Supporting of Binary instead Bytea for Primary Keys

2008-12-18 Thread Miroslav Nachev
Hi, What if I convert to/from byte array with (see the attached java number utility class): NumberUtils.toByteArray(UUID uuid) NumberUtils.toUUID(byte[] value) Miro. Miroslav Nachev wrote: Yes, you are right. With the correct code: public static void main(String[] args) { U

[BUGS] Page header error on PGSQL 7.4.5

2008-12-18 Thread Богданов В .
We have PostgreSQL v. 7.4.5 and main application working with PGSQL via libpq. Linux kernel 2.6.17.14 We encounter page header error occasional occurence in different tables, including system pg_xxx. Database is restored transactionally using restore.sql commands: drop table ..., create table