[BUGS] ST_Distance Issue

2011-11-17 Thread Archana Sachin Ghag
I am calculating distance from my current location with all available regions(polygons) in my table. I am using ST_Distance method for this. My regions are stored with SRID = 900913. Distance for point in Europe from USA region is coming as 122.78. How come this possible. These regions are so far

Re: [BUGS] BUG #6293: JDBC driver performance

2011-11-17 Thread Teun Hoogendoorn
Hi Kris, This is exactly what I'm doing. I understand your solution, but that's not really an option for me (I have to change a lot of code). Maybe the driver can cache the ResultSetMetaData for the ResultSet? BTW. I looked into the driver code to look for a solution for my problem. I came acros

Re: [BUGS] ST_Distance Issue

2011-11-17 Thread Robert Haas
On Thu, Nov 17, 2011 at 4:29 AM, Archana Sachin Ghag < archana_g...@infosys.com> wrote: > I am calculating distance from my current location with all available > regions(polygons) in my table. > > I am using ST_Distance method for this. > > My regions are stored with SRID = 900913. > >

[BUGS] CREATE ROLE jdbc vs pgadmin

2011-11-17 Thread Flávio Alves Granato
gentlemen, I have a problem with the query 'CREATE ROLE' being executed via jdbc and via pgadmin. When I run it via pgadmin: CREATE ROLE flavio LOGIN ENCRYPTED PASSWORD 'cd6a0065e497a3c20b3c639df7d56b0d' NOSUPERUSER INHERIT NOCREATEDB NOCREATEROLE NOREPLICATION; and via jdbc: CREATE ROLE fl

Re: [BUGS] CREATE ROLE jdbc vs pgadmin

2011-11-17 Thread John R Pierce
On 11/17/11 11:56 AM, Flávio Alves Granato wrote: I have a problem with the query 'CREATE ROLE' being executed via jdbc and via pgadmin. When I run it via pgadmin: CREATE ROLE flavio LOGIN ENCRYPTED PASSWORD 'cd6a0065e497a3c20b3c639df7d56b0d' NOSUPERUSER INHERIT NOCREATEDB NOCREATEROLE NO

Re: [BUGS] CREATE ROLE jdbc vs pgadmin

2011-11-17 Thread Flávio Alves Granato
2011/11/17 John R Pierce > On 11/17/11 11:56 AM, Flávio Alves Granato wrote: > >> >> I have a problem with the query 'CREATE ROLE' being executed via jdbc and >> via pgadmin. When I run it via pgadmin: >> >> CREATE ROLE flavio LOGIN >> ENCRYPTED PASSWORD '**cd6a0065e497a3c20b3c639df7d56b**0d' >>

[BUGS] BUG #6299: pg_dump, pg_dumpall - Problem with the order of backup functions

2011-11-17 Thread lindebg
The following bug has been logged online: Bug reference: 6299 Logged by: lindebg Email address: lind...@gmail.com PostgreSQL version: 9.0, 9.1 Operating system: Linux, Windows Description:pg_dump, pg_dumpall - Problem with the order of backup functions Details: 1. c

Re: [BUGS] BUG #6299: pg_dump, pg_dumpall - Problem with the order of backup functions

2011-11-17 Thread Tom Lane
"lindebg" writes: > Description:pg_dump, pg_dumpall - Problem with the order of backup > functions Yeah, this was reported last month --- CREATE FUNCTION neglects to mark the function with the default expression as dependent on the other one. It'll be fixed in the next set of update relea