Re: [HACKERS] Problem with lower() function

Thank you, we figured out that, the query with lower() is taking too long and we thought it is having some problem. The actual table in our database has more than 10 million rows and query is taking too long. Thanks Yuva -Original Message- From: Yuva Chandolu Sent: Friday, August 09

[HACKERS] Problem with lower() function

Hi, We have a problem with lower() function working differently for two different data types table: yuva_test column_name data_type yt_name1varchar(255) yt_name2char(1) The data is yt_name1yt_name2 yuvaF bharat F 1234556 F 234 F etc.

[HACKERS] IO error - please help

Hi, We had seen the following exception when we tried for a heavy query(around 1 to 2 in result is possible) An I/O error occured while reading from backend - Exception: java.net.SocketException: socket closed: Bad file number Stack Trace: java.net.SocketException: socket closed: Bad fi

Re: [HACKERS] Outer join differences

This is great, we thought we may go for code changes, we will go with this solution instead. Thanks Yuva -Original Message- From: Stephan Szabo [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 30, 2002 9:31 PM To: Yuva Chandolu Cc: '[EMAIL PROTECTED]' Subject: Re: [HACKERS]

Re: [HACKERS] Outer join differences

-Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 30, 2002 9:15 PM To: Yuva Chandolu Cc: '[EMAIL PROTECTED]' Subject: Re: [HACKERS] Outer join differences Yuva Chandolu <[EMAIL PROTECTED]> writes: > I see different results in Oracle and postgres

[HACKERS] Outer join differences

Hi, I see different results in Oracle and postgres for same outer join queries. Here are the details. I have the following tables in our pg db table: yuva_test1 yt1_id yt1_nameyt1_descr 1 1-name1 1-desc1 2 1-name2 1-desc2 3 1-name3 1-de

Re: [HACKERS] outer join help...

Message- From: Marc Lavergne [mailto:[EMAIL PROTECTED]] Sent: Monday, July 29, 2002 2:31 PM To: Yuva Chandolu Cc: '[EMAIL PROTECTED]' Subject: Re: [HACKERS] outer join help... Looks fine, you may want to rephrase it as: select yt1_name, yt1_descr, yt2_name, yt2_descr, yt3_name,

Re: [HACKERS] outer join help...

we try with live data. Thanks Yuva -Original Message- From: Andrew Sullivan [mailto:[EMAIL PROTECTED]] Sent: Monday, July 29, 2002 1:27 PM To: Yuva Chandolu Subject: Re: [HACKERS] outer join help... On Mon, Jul 29, 2002 at 01:07:43PM -0700, Yuva Chandolu wrote: > Hi, > > I n

[HACKERS] regd count(count(*)) in group by

Hi, We have a query "select count(count(*)) from test group by trunc(test_date)". This works fine with Oracle but when moving to postgres I changed it to "select count(count(*)) from test group by date_trunc('day', test_date)" but I get the following error ERROR: Aggregate function calls may no

[HACKERS] savepoint and rollback queries in postgres

Hi, We are in the process of moving to Postgres from Oracle. We were using "savepoint xyz" and "rollback to savepoint xyz" with Oracle. Or these supported by Postgres?, if so what are the equivalent queries in postgres for the same. Thanks Yuva Sr. Java Developer www.ebates.com

[HACKERS] Howmany connections postgres can handle upto?

Hi, We are moving to postgres from Oarcle. When we were with Oracle, we were using a total of 160 connections(4 app servers each maintaining a pool of 40 connections). After moving to postgres we want to make it higher i.e make it 60 connections for each app server i.e a total of 240 connections.

[HACKERS] Milliseconds problem with PostgreSQL 7.2 jdbc driver (pgjdbc2.jar)

Hi, We observed a "String index out of range: 23" problem when we tried to retrieve timestamp field value that has milliseconds. We are trying to find a quick fix for the millisecond problem for Timestamp. We notice there is a beta driver(devpgjdbc2.jar) that contains this fix currently, but wa

[HACKERS] String index out of range: 23 problem with timestamp milliseconds

Hi, We have a timestamp column in one table and we are getting the above problem when the timestamp column has a value up to milliseconds. We are using stable PostgreSQL 7.2 jdbc driver (pgjdbc2.jar) got from http://jdbc.postgresql.org/download.html. Does anyone know of latest production ready d

[HACKERS] String index out of range: 23 problem with timestamp

Hi, We have a timestamp column in one table and we are getting the above problem when the timestamp column has a value upto milliseconds. We are using PostgreSQL 7.2 version stable jdbc driver(pgjdbc2.jar) got from http://jdbc.postgresql.org/download.html. Does anyone know of latest production r

[HACKERS] Will postgress handle too big tables?

Hi, We are moving to Postgres from Oracle. We have a few tables that have around 8 to 10 millions of rows and their size increases very rapidly(deletions are very less on these tables). How will Postgres hanlde very big tables like this? or would it be very slow when compared to Oracle? Do you ha