> -Original Message-
> From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-
>
> How did you get OTHER to work? Did you define your own TypeHandler?
That's the only change we had to make. The Java code works as is. We only
changed the jdbcType from "ORACLECURSOR" TO "OTHER"
Please ignore this email. I sent this one earlier with the wrong email address
and it was sent to moderator.
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Zeeshan Ghalib
Sent: 05 July 2010 11:12
To: pgsql-general@postgresql.org
Subject: [GEN
Hello Guys,
We are trying to migrate from Oracle to Postgres. One of the major requirement
of our database is the ability to generate XML feeds and some of our XML files
are in the order of 500MB+.
We are getting "Out of Memory" errors when doing an update on a table.
Here is some detai
Ok, that makes perfect sense. We will upgrade to 64-bit and continue our tests
on the new build.
By the way, is it safe to go ahead with Centos 5.5 or should we stick to the
previous version 5.4?
Thank you so much Sam and Thom for your speedy help :)
Best regards,
Zeeshan
> -Origina
Hello Thom,
Thanks for your quick response.
So, is this there a restriction with 32-bit PostgreSQL, a bug or configuration
issue?
I will most definitely upgrade to 64-bit, because that's what we want anyway.
However, I was curious what is the root cause of this problem?
I am getting a bit wo
> -Original Message-
> From: Thom Brown [mailto:thombr...@gmail.com]
> Sent: 05 July 2010 12:40
> To: Zeeshan Ghalib
> Cc: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Out of memory on update of a single column table
> containg just one row.
> Hi Zeeshan,
>
> Which version of Postg
Hello Guys,
We are trying to migrate from Oracle to Postgres. One of the major requirement
of our database is the ability to generate XML feeds and some of our XML files
are in the order of 500MB+.
We are getting "Out of Memory" errors when doing an update on a table.
Here is some detai
