Re: [PATCHES] Writing Commit Status hint bits (was Re: [HACKERS] Constant

2005-07-20 Thread Simon Riggs
On Tue, 2005-07-19 at 22:24 -0400, Tom Lane wrote: Simon Riggs [EMAIL PROTECTED] writes: Short patch enclosed to turn off writing of commit-status hint bits. Doesn't this entirely destroy the ability to truncate clog, and therefore the ability to survive XID wraparound? I hope not for all

[PATCHES] Problems compiling Postgresql 8.0.3 on 10.4

2005-07-20 Thread Jamie Deppeler
Hi, i have just installed 10.4 on one of our machines and cannot get past this error during make gcc -no-cpp-precomp -O2 -Wall -Wmissing-prototypes -Wpointer-arith -Wendif-labels -fno-strict-aliasing -dynamiclib -install_name /usr/local/pgsql/lib/libpq.4.dylib -compatibility_version 4

Re: [PATCHES] [HACKERS] Problems compiling Postgresql 8.0.3 on 10.4

2005-07-20 Thread Dave Cramer
Jamie, That's strange, I have 8.03 building fine on 10.4 ? Did you simply do a make without a make clean and run configure again ? Dave On 20-Jul-05, at 3:37 AM, Jamie Deppeler wrote: Hi, i have just installed 10.4 on one of our machines and cannot get past this error during make gcc

Re: [PATCHES] [HACKERS] Problems compiling Postgresql 8.0.3 on 10.4

2005-07-20 Thread Jeff Trout
On Jul 20, 2005, at 5:58 AM, Dave Cramer wrote: Hi, i have just installed 10.4 on one of our machines and cannot get past this error during make /usr/bin/libtool: for architecture: cputype (16777234) cpusubtype (0) file: -lSystem is not an object file (not allowed in a library)

Re: [PATCHES] Writing Commit Status hint bits (was Re: [HACKERS] Constant WAL replay)

2005-07-20 Thread Tom Lane
Simon Riggs [EMAIL PROTECTED] writes: On Tue, 2005-07-19 at 22:24 -0400, Tom Lane wrote: Simon Riggs [EMAIL PROTECTED] writes: Short patch enclosed to turn off writing of commit-status hint bits. Doesn't this entirely destroy the ability to truncate clog, and therefore the ability to

Re: [PATCHES] Writing Commit Status hint bits (was Re: [HACKERS] Constant

2005-07-20 Thread Simon Riggs
On Wed, 2005-07-20 at 09:24 -0400, Tom Lane wrote: Simon Riggs [EMAIL PROTECTED] writes: On Tue, 2005-07-19 at 22:24 -0400, Tom Lane wrote: Simon Riggs [EMAIL PROTECTED] writes: Short patch enclosed to turn off writing of commit-status hint bits. Doesn't this entirely destroy the

Re: [PATCHES] Interval-day patch

2005-07-20 Thread Bruce Momjian
I have applied this patch with significant adjustments. I changed your simplify function into two new functions, justify_hours() and justify_days(), to handle the adjustment of interval values to hours 24 and days 30. Do we want to separate functions? I used date2j and j2date to add days to

Re: [PATCHES] Writing Commit Status hint bits (was Re: [HACKERS] Constant WAL replay)

2005-07-20 Thread Tom Lane
Simon Riggs [EMAIL PROTECTED] writes: On Wed, 2005-07-20 at 09:24 -0400, Tom Lane wrote: We don't rely on any one write of them to work, but that doesn't mean that we can indefinitely postpone writing them. OK, I think I understand where you're coming from now. Apparently not :-( When

Re: [PATCHES] Interval-day patch

2005-07-20 Thread Tom Lane
Bruce Momjian pgman@candle.pha.pa.us writes: We have this TODO item: o Allow TIMESTAMP WITH TIME ZONE to store the original timezone information, either zone name or offset from UTC [timezone] If the TIMESTAMP value is stored with a time zone name, interval

Re: [PATCHES] Interval-day patch

2005-07-20 Thread Bruce Momjian
Tom Lane wrote: Bruce Momjian pgman@candle.pha.pa.us writes: We have this TODO item: o Allow TIMESTAMP WITH TIME ZONE to store the original timezone information, either zone name or offset from UTC [timezone] If the TIMESTAMP value is stored with a time

Re: [PATCHES] Changes for AIX buildfarm

2005-07-20 Thread Peter Eisentraut
Tom Lane wrote: Fair enough. But I'm concerned about the proposed patch because it seems to revert a deliberate change made some time ago: http://developer.postgresql.org/cvsweb.cgi/pgsql/src/Makefile.shlib#r ev1.65 http://archives.postgresql.org/pgsql-committers/2002-10/msg00054.php so I

Re: [PATCHES] [COMMITTERS] pgsql: Add 'day' field to INTERVAL so 1 day interval

2005-07-20 Thread Bruce Momjian
Kris Jurka wrote: Bruce Momjian wrote: Log Message: --- Add 'day' field to INTERVAL so 1 day interval can be distinguished from 24 hours. This is very helpful for daylight savings time: Seems to have broken the contrib/btree_gist interval regression tests

Re: [PATCHES] [COMMITTERS] pgsql: Add 'day' field to INTERVAL so 1 day interval

2005-07-20 Thread Rocco Altier
This is also broken for make check with --enable-integer-datetimes on kookaburra (AIX). It looks like the other members of buildfarm that fail on contrib aren't using integer datetimes. -rocco -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of