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

2012-01-18 Thread bricklen
On Wed, Jan 18, 2012 at 5:38 AM, wrote: >  INSERT INTO tissue.biopsy (id_biopsy, f_user,introduction_date, > description, weight, size) >  VALUES >  ( >  DEFAULT, >  user, >  in_date, >  in_description, >  in_weight, >  in_size >  ); What happens when you double-quote user in the insert statemen

[BUGS] BUG #6400: function arguments not accepted

2012-01-18 Thread knoch
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 have a strange problem regarding functions with para

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

2012-01-18 Thread kenaniah
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) IS DISTINCT FROM point(2, 3); ERROR:

Re: [BUGS] pg_upgrade v9.1 issues

2012-01-18 Thread Bruce Momjian
On Tue, Jan 17, 2012 at 06:38:46AM -0800, shitake wrote: > I am having the same exact problem, migrating from 8.4SS to 9.1 . > > @Bruce_Momjian: Do you have a solution for this ?? > > I have also opened a thread for this because I didn't find this thread > before. > > http://postgresql.10456

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

2012-01-18 Thread Heikki Linnakangas
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 needs some cleanup;

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

2012-01-18 Thread Heikki Linnakangas
On 16.01.2012 11:32, y...@mwd.biglobe.ne.jp wrote: The following bug has been logged on the website: Bug reference: 6399 Logged by: YAMAMOTO Takashi Email address: y...@mwd.biglobe.ne.jp PostgreSQL version: Unsupported/Unknown Operating system: NetBSD Description: 9.2devel