Re: [BUGS] BUG #7588: pgsql 9.1 incompatible with zlib 1.27

2012-10-08 Thread John Marino
On 10/7/2012 18:36, Tom Lane wrote: > DragonFly has zlib 1.27 as a base library. I noticed several zlib warnings > when pgsql 9.1.6 was being built with gcc47. The various utilities in > src/bin are using the zlib.h header incorrectly. This issue is dealt with in 9.2. I don't think we are

Re: [BUGS] BUG #7588: pgsql 9.1 incompatible with zlib 1.27

2012-10-08 Thread John Marino
On 10/7/2012 22:26, Tom Lane wrote: John Marino writes: Are you 100% sure that offsetof is evaluated at compile time? Is this not part of section 6.6 that I quoted earlier? My copy of C99 sayeth (in section 7.17) offsetof(type, member-designator) which expands to an

Re: [BUGS] BUG #7588: pgsql 9.1 incompatible with zlib 1.27

2012-10-08 Thread John Marino
On 10/7/2012 22:26, Tom Lane wrote: John Marino writes: Are you 100% sure that offsetof is evaluated at compile time? Is this not part of section 6.6 that I quoted earlier? My copy of C99 sayeth (in section 7.17) offsetof(type, member-designator) which expands to an

Re: [BUGS] BUG #7588: pgsql 9.1 incompatible with zlib 1.27

2012-10-08 Thread John Marino
On 10/7/2012 21:14, Tom Lane wrote: John Marino writes: By the way, I also had to patch 9.1.6 in order to build it with gcc47: http://pkgsrc.se/files.php?messageId=20121007102454.6e70d17...@cvs.netbsd.org [ shrug... ] I just tried 9.1.6 with gcc 4.7.0 and 4.7.2 on Fedora, and saw nothing but

Re: [BUGS] BUG #7588: pgsql 9.1 incompatible with zlib 1.27

2012-10-08 Thread John Marino
On 10/7/2012 19:35, Tom Lane wrote: John Marino writes: On 10/7/2012 18:36, Tom Lane wrote: This issue is dealt with in 9.2. I don't think we are going to change it in previous release branches, because these are only warnings no? It successfully completes the build. I don't know if the w

Re: [BUGS] BUG #7586: PL/Perl problem

2012-10-08 Thread Franco Ricci
Thanks a lot for explanation. I'm planing to upgrade to pgsql 9.2 even for other reasons. If I need to use earlier postgresql versions I'll fix my functions using a text arguments instead of xml one. I tried and It seams to work fine. Regards Franco Ricci On 7-10-2012 7:06 PM, Tom Lane wro

Re: [BUGS] BUG #7588: pgsql 9.1 incompatible with zlib 1.27

2012-10-08 Thread John Marino
On 10/7/2012 21:54, Tom Lane wrote: John Marino writes: Perhaps, you need to take a closer look at this. I guarantee that I didn't do this for cosmetic reasons. GCC behavior changed with GCC 4.5 on this topic. You should report it as a bug in whatever distro you're using, because the behavio

Re: [BUGS] BUG #7534: walreceiver takes long time to detect n/w breakdown

2012-10-08 Thread Robert Haas
On Thu, Oct 4, 2012 at 6:12 AM, Amit kapila wrote: > 1. One new configuration parameter wal_receiver_timeout is added to detect > timeout at receiver task. > 2. Existing parameter replication_timeout is renamed to wal_sender_timeout. -1 from me on a backward compatibility break here. I don't kn

Re: [BUGS] BUG #7534: walreceiver takes long time to detect n/w breakdown

2012-10-08 Thread Amit Kapila
> On Monday, October 08, 2012 7:38 PM Robert Haas wrote: > On Thu, Oct 4, 2012 at 6:12 AM, Amit kapila > wrote: > > 1. One new configuration parameter wal_receiver_timeout is added to > detect timeout at receiver task. > > 2. Existing parameter replication_timeout is renamed to > wal_sender_timeou

Re: [BUGS] BUG #7578: Not able to drop user if S/he has permission on tablespace

2012-10-08 Thread Nikolay
Where can I found this path? 03.10.2012 18:55, Alvaro Herrera пишет: Excerpts from wheelly's message of mar oct 02 05:49:27 -0300 2012: Where is a bug in PostgreSQL or in documentation? I think it was a bug in the code. I have committed a patch that should fix this problem. -- Sent via