Re: [BUGS] BUG #6399: knngist sometimes returns tuples in incorrect order

2012-01-19 Thread Heikki Linnakangas
On 19.01.2012 06:35, YAMAMOTO Takashi wrote: On 18.01.2012 14:07, Heikki Linnakangas wrote: For 9.2, I think we should change gist so that the user-defined distance function can return any scalar data type, not just float8 (as long as it has b-tree comparison operators). I took a shot at doing

Re: [BUGS] BUG #6401: IS DISTINCT FROM improperly compares geomoetric datatypes

2012-01-19 Thread Heikki Linnakangas
On 18.01.2012 23:14, kenan...@gmail.com wrote: The following bug has been logged on the website: Bug reference: 6401 Logged by: Kenaniah Cerny Email address: kenan...@gmail.com PostgreSQL version: 9.1.2 Operating system: Centos 6 x86_64 Description: SELECT point(2, 3)

Re: [BUGS] BUG #6401: IS DISTINCT FROM improperly compares geomoetric datatypes

2012-01-19 Thread Alvaro Herrera
Excerpts from Heikki Linnakangas's message of jue ene 19 07:25:36 -0300 2012: > Frankly that's such a rare corner case that I'm not very enthusiastic > about fixing it. One idea would be to look up the type's b-tree sort > operators, and pick the equality operator from there. But point datatype

Re: [BUGS] BUG #6401: IS DISTINCT FROM improperly compares geomoetric datatypes

2012-01-19 Thread Heikki Linnakangas
On 19.01.2012 15:30, Alvaro Herrera wrote: Excerpts from Heikki Linnakangas's message of jue ene 19 07:25:36 -0300 2012: Frankly that's such a rare corner case that I'm not very enthusiastic about fixing it. One idea would be to look up the type's b-tree sort operators, and pick the equality o

[BUGS] BUG #6402: Installer hung and wouldn't work again

2012-01-19 Thread srinivas_j2ee
The following bug has been logged on the website: Bug reference: 6402 Logged by: Srini Email address: srinivas_j...@yahoo.com PostgreSQL version: 9.1.2 Operating system: Window 7 Description: I was trying to upgrade from postgres 8.4 to 9.1.2. I had uninstalled existi

Re: [BUGS] BUG #6399: knngist sometimes returns tuples in incorrect order

2012-01-19 Thread YAMAMOTO Takashi
hi, > On 18.01.2012 14:07, Heikki Linnakangas wrote: >> For 9.2, I think we should change gist so >> that the user-defined distance function can return any scalar data type, >> not just float8 (as long as it has b-tree comparison operators). > > I took a shot at doing that. Patch attached. It nee

R: R: R: R: R: R: [BUGS] BUG #6342: libpq blocks forever in "poll" function

2012-01-19 Thread Andrea Grassi
To try to solve this problem my colleague (the systems engineer that takes care of the machine) did: 1. Disable drivers HP : NOT SOLVED 2. Disable Hyperthreading: NOT SOLVED 3. Reduced the phisical CPU (enabled on boot) from 32 to 16: THIS SOLVED THE PROBLEM. Now 2 weeks passed without blocking a

Re: [BUGS] BUG #6401: IS DISTINCT FROM improperly compares geomoetric datatypes

2012-01-19 Thread Tom Lane
Alvaro Herrera writes: > Excerpts from Heikki Linnakangas's message of jue ene 19 07:25:36 -0300 2012: >> Frankly that's such a rare corner case that I'm not very enthusiastic >> about fixing it. One idea would be to look up the type's b-tree sort >> operators, and pick the equality operator fro

Re: [BUGS] BUG #6400: function arguments not accepted

2012-01-19 Thread Robert Haas
On Wed, Jan 18, 2012 at 8:38 AM, wrote: > The following bug has been logged on the website: > > Bug reference:      6400 > Logged by:          Sandra Knoch > Email address:      kn...@ipa.fraunhofer.de > PostgreSQL version: 9.0.6 > Operating system:   Windows Server 2007 SP2 > Description: > > I

Re: [BUGS] Documentation bug: reference to checkpoint activity in bgwriter

2012-01-19 Thread Robert Haas
On Mon, Jan 9, 2012 at 2:37 PM, Peter Geoghegan wrote: > On 9 January 2012 18:47, Robert Haas wrote: >> On Sat, Dec 31, 2011 at 8:54 PM, Peter Geoghegan >> wrote: >>> ISTM that the following reference, at config.sgml line 1345, ought to >>> be adjusted due to the introduction of the new checkpo

Re: [BUGS] Documentation bug: reference to checkpoint activity in bgwriter

2012-01-19 Thread Peter Geoghegan
On 20 January 2012 02:53, Robert Haas wrote: > OK, done. Thanks -- Peter Geoghegan       http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training and Services -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.po

Re: [BUGS] BUG #6399: knngist sometimes returns tuples in incorrect order

2012-01-19 Thread YAMAMOTO Takashi
hi, > On 19.01.2012 06:35, YAMAMOTO Takashi wrote: >>> On 18.01.2012 14:07, Heikki Linnakangas wrote: For 9.2, I think we should change gist so that the user-defined distance function can return any scalar data type, not just float8 (as long as it has b-tree comparison operators). >