Re: [BUGS] BUG #8271: Configure warning: sys/ucred.h: present but cannot be compiled

2013-07-25 Thread Andres Freund
Hi, On 2013-06-30 15:17:20 +0200, Andres Freund wrote: > On 2013-06-30 15:11:24 +0300, Emre Hasegeli wrote: > > 2013/6/30 Andres Freund : > > > On 2013-06-30 10:43:49 +, e...@hasegeli.com wrote: > > > Could you attach config.log? > > > > Attached. > > This seems to be caused by be4585b1c27ac

Re: [BUGS] BUG #8271: Configure warning: sys/ucred.h: present but cannot be compiled

2013-07-25 Thread Tom Lane
Andres Freund writes: >> Before that commit the checks for cmsgcred which includes sys/ucred.h >> happened to include params.h... Patch attached, missing the configure >> update since I don't have a compatible autoconf on my laptop, to produce >> a minimal diff. > Could somebody apply the fix (in

Re: [BUGS] BUG #8271: Configure warning: sys/ucred.h: present but cannot be compiled

2013-07-25 Thread Andres Freund
On 2013-07-25 09:48:31 -0400, Tom Lane wrote: > Andres Freund writes: > >> Before that commit the checks for cmsgcred which includes sys/ucred.h > >> happened to include params.h... Patch attached, missing the configure > >> update since I don't have a compatible autoconf on my laptop, to produce

Re: [BUGS] BUG #8271: Configure warning: sys/ucred.h: present but cannot be compiled

2013-07-25 Thread Tom Lane
Andres Freund writes: > On 2013-07-25 09:48:31 -0400, Tom Lane wrote: >> The proposed patch seems a bit overcomplicated --- isn't the real >> problem that I changed the ordering of the header probes in >> be4585b1c27ac5dbdd0d61740d18f7ad9a00e268? I think I just alphabetized >> them in a fit of ne

Re: [BUGS] BUG #8271: Configure warning: sys/ucred.h: present but cannot be compiled

2013-07-25 Thread Andrew Dunstan
On 07/25/2013 09:48 AM, Tom Lane wrote: Andres Freund writes: Before that commit the checks for cmsgcred which includes sys/ucred.h happened to include params.h... Patch attached, missing the configure update since I don't have a compatible autoconf on my laptop, to produce a minimal diff. Co

[BUGS] BUG #8332: Error 2920 installation

2013-07-25 Thread poddubom
The following bug has been logged on the website: Bug reference: 8332 Logged by: Regenoman Email address: poddu...@mail.ru PostgreSQL version: 9.0.2 Operating system: Windows XP Professional ver 2002 Service Pack 3 Description: Hello When you install any version of

[BUGS] BUG #8330: Accessing Postgres database on iOS Application

2013-07-25 Thread prateek
The following bug has been logged on the website: Bug reference: 8330 Logged by: Prateek Kansara Email address: prat...@kansara.in PostgreSQL version: 9.2.4 Operating system: iOS Description: Respected Sir/madam, I am working on an application for iP

Re: [BUGS] BUG #8271: Configure warning: sys/ucred.h: present but cannot be compiled

2013-07-25 Thread Tom Lane
Andres Freund writes: > The problem is that you can't include sys/ucred.h on some platforms > (e.g. openbsd) without first including sys/params.h because the > resulting file won't compile. BTW, after committing this I re-reviewed the thread and realized that actually this problem is strictly cos

[BUGS] BUG #8333: Conversions from TEXT to range types are not immutable

2013-07-25 Thread quassnoi
The following bug has been logged on the website: Bug reference: 8333 Logged by: Alex Bolenok Email address: quass...@gmail.com PostgreSQL version: 9.2.4 Operating system: Fedora 19 Description: SET lc_messages TO 'en_US.UTF-8'; DROP TABLE IF EXISTS mytable;

Re: [BUGS] BUG #8271: Configure warning: sys/ucred.h: present but cannot be compiled

2013-07-25 Thread Andres Freund
On 2013-07-25 11:50:47 -0400, Tom Lane wrote: > Andres Freund writes: > > The problem is that you can't include sys/ucred.h on some platforms > > (e.g. openbsd) without first including sys/params.h because the > > resulting file won't compile. > > BTW, after committing this I re-reviewed the thre

Re: [BUGS] BUG #8271: Configure warning: sys/ucred.h: present but cannot be compiled

2013-07-25 Thread Tom Lane
Andres Freund writes: > On 2013-07-25 11:50:47 -0400, Tom Lane wrote: >> So on an OpenBSD build that code wouldn't be used anyway (not even >> when talking to a pre-9.1 server, if I'm interpreting the comment >> correctly). > As far as I understood it, it wouldn't be used as long as you're not >

[BUGS] BUG #8334: Merge Join drops records

2013-07-25 Thread euclid
The following bug has been logged on the website: Bug reference: 8334 Logged by: Euclid Nikiforov Email address: euc...@yandex-team.ru PostgreSQL version: 9.2.0 Operating system: Linux 3.8.0-11-na Description: Hi all Recently investigating problem in our backend que

Re: [BUGS] BUG #8334: Merge Join drops records

2013-07-25 Thread Pavan Deolasee
On Thu, Jul 25, 2013 at 9:46 PM, wrote: > The following bug has been logged on the website: > > Bug reference: 8334 > Logged by: Euclid Nikiforov > Email address: euc...@yandex-team.ru > PostgreSQL version: 9.2.0 > Did you try updating to the latest minor release ? I can not r

[BUGS] pgsql 8.4 "not" + "is contained by" operators return wrong result

2013-07-25 Thread László Lajos Jánszky
*Description:* By pgsql 8.4 I have the following bug: If the haystack array is null (for example by empty result of array_agg) by is contained by, and you use it with negation, the the result is false instead of true. *Reproduce:* The following query returns nothing, but it should return 1. *

Re: [BUGS] pgsql 8.4 "not" + "is contained by" operators return wrong result

2013-07-25 Thread Tom Lane
=?ISO-8859-1?Q?L=E1szl=F3_Lajos_J=E1nszky?= writes: > The following query returns nothing, but it should return 1. > *SELECT 1 FROM NOT(ARRAY[1] <@ NULL**); * I assume you meant SELECT 1 WHERE NOT(ARRAY[1] <@ NULL) ? Because what you wrote doesn't parse. This is not a bug. "ARRAY[1] <@ NULL" y

[BUGS] BUG #8335: trim() un-document behaviour

2013-07-25 Thread amutu
The following bug has been logged on the website: Bug reference: 8335 Logged by: Jov Email address: am...@amutu.com PostgreSQL version: 9.2.4 Operating system: suse 10 linux 64 Description: in the postgresql doc 9.4,I find the trim() function like this: trim([leadin