[HACKERS] 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: [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: [HACKERS] Constraint Exclusion on all tables

2005-07-20 Thread Dawid Kuroczko
On 7/20/05, Simon Riggs [EMAIL PROTECTED] wrote: Since it's also possible to do partitioning with UNION ALL, maybe it would be better if there was an option to explain that told it either to show or not show info about eliminated partitions. That would seem to serve the general case better

Re: [HACKERS] More buildfarm stuff

2005-07-20 Thread Palle Girgensohn
--On tisdag, juli 19, 2005 15.11.31 -0400 Tom Lane [EMAIL PROTECTED] wrote: Jim C. Nasby [EMAIL PROTECTED] writes: http://archives.postgresql.org/pgsql-bugs/2005-07/msg00096.php describes what I think is causing octopus to fail. What's also interesting is these patches from the FreeBSD

Re: [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: [HACKERS] Buildfarm issues on specific machines

2005-07-20 Thread Tom Lane
Jim C. Nasby [EMAIL PROTECTED] writes: And 7.3 is also failing, with a different error: ccache gcc -traditional-cpp -g -O2 -fno-strict-aliasing -g -Wall -Wmissing-prototypes -Wmissing-declarations -I../../../../src/include -I/opt/local/include -c -o printtup.o printtup.c In file included

Re: 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: 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: [HACKERS] Buildfarm issues on specific machines

2005-07-20 Thread Peter Eisentraut
Tom Lane wrote: This is a considerably bigger issue for the buildfarm than it would be for ordinary users of our distribution, since in the distro it's only the contrib modules that you actually need to run through your local flex. Couldn't we just run the distprep actions (flex, bison)

Re: [HACKERS] Buildfarm issues on specific machines

2005-07-20 Thread Tom Lane
Peter Eisentraut [EMAIL PROTECTED] writes: Couldn't we just run the distprep actions (flex, bison) through contrib as well? That wouldn't hurt anyone, I think. No objection here (though of course it doesn't affect the buildfarm issue). regards, tom lane

Re: [HACKERS] Buildfarm issues on specific machines

2005-07-20 Thread Jim C. Nasby
On Wed, Jul 20, 2005 at 10:32:00AM -0400, Tom Lane wrote: In short, OS X 10.2 wasn't a supported platform when 7.2/7.3 came out, and I don't want to retroactively try to make it so. All I needed to hear. I'll pull those from cuckoo's config. -- Jim C. Nasby, Database Consultant

Re: [HACKERS] Constraint Exclusion on all tables

2005-07-20 Thread Jim C. Nasby
On Wed, Jul 20, 2005 at 12:52:28PM +0200, Dawid Kuroczko wrote: On 7/20/05, Simon Riggs [EMAIL PROTECTED] wrote: Since it's also possible to do partitioning with UNION ALL, maybe it would be better if there was an option to explain that told it either to show or not show info about

Re: [HACKERS] [PATCHES] Patch to fix plpython on OS X

2005-07-20 Thread Jim C. Nasby
On Tue, Jul 19, 2005 at 05:47:37PM -0600, Michael Fuhr wrote: On Tue, Jul 19, 2005 at 06:06:00PM -0500, Jim C. Nasby wrote: [EMAIL PROTECTED]:00]~/buildfarm/HEAD/pgsqlkeep.1121809875/src/pl/plpython:41%otool -L libplpython.0.0.so libplpython.0.0.so:

[HACKERS] cygwin bulds broken

2005-07-20 Thread Andrew Dunstan
At least on my machine, the latest Cygwin seems to break comprehensively, with a SEGV when starting postmaster. It looks like it is failing ion the code that looks for the highest settable FD, but it's hard to say - the stack gets corrupted so getting a reliable backtrace is hard. Can

Re: [HACKERS] cygwin bulds broken

2005-07-20 Thread Andrew Dunstan
Andrew Dunstan wrote: At least on my machine, the latest Cygwin seems to break comprehensively, with a SEGV when starting postmaster. It looks like it is failing ion the code that looks for the highest settable FD, but it's hard to say - the stack gets corrupted so getting a reliable

Re: [HACKERS] Enticing interns to PostgreSQL

2005-07-20 Thread Jeff Davis
Jim C. Nasby wrote: The email below about FreeBSD's involvement in Google's Summer of Code got me thinking; would there be value in trying to attract college students to working on either PostgreSQL development, or using PostgreSQL in projects? Even though we missed getting in on the summer

[HACKERS] snapshot build broken ...

2005-07-20 Thread Marc G. Fournier
Did I miss a docbook upgrade or something here? openjade -V draft-mode -D . -c /usr/local/share/sgml/docbook/dsssl/modular/catalog -d stylesheet.dsl -i output-text -t sgml -V nochunks standalone-install.sgml installation.sgml INSTALL.html openjade:installation.sgml:873:44:X: reference to

Re: [HACKERS] snapshot build broken ...

2005-07-20 Thread Tom Lane
Marc G. Fournier [EMAIL PROTECTED] writes: openjade -V draft-mode -D . -c /usr/local/share/sgml/docbook/dsssl/modular/catalog -d stylesheet.dsl -i output-text -t sgml -V nochunks standalone-install.sgml installation.sgml INSTALL.html openjade:installation.sgml:873:44:X: reference to

[HACKERS] Timezone bugs

2005-07-20 Thread Kevin McArthur
There appear to be several bugs in the at time zone patch recently applied. show timezone;TimeZone --UTC(1 row) select now(); now ---2005-07-20 23:38:57.981128+00(1 row) *** WORKS *** select CURRENT_DATE + '05:00'::time at time zone

Re: [HACKERS] snapshot build broken ...

2005-07-20 Thread Marc G. Fournier
On Wed, 20 Jul 2005, Tom Lane wrote: Marc G. Fournier [EMAIL PROTECTED] writes: openjade -V draft-mode -D . -c /usr/local/share/sgml/docbook/dsssl/modular/catalog -d stylesheet.dsl -i output-text -t sgml -V nochunks standalone-install.sgml installation.sgml INSTALL.html

Re: [HACKERS] snapshot build broken ...

2005-07-20 Thread Marc G. Fournier
On Wed, 20 Jul 2005, Tom Lane wrote: Marc G. Fournier [EMAIL PROTECTED] writes: On Wed, 20 Jul 2005, Tom Lane wrote: Fixed --- but maybe we ought to do something to test the INSTALL/HISTORY documentation build as well as the main SGML docs. Or maybe better, do something to make failures of

[HACKERS] No user being created during initdb for OS X

2005-07-20 Thread Jamie Deppeler
Hi, Having an issue with 10.4.2 at the moment when i initialize the database no user is being created. I have setup Postgresql 8.0.3 on 10.3 without any issue, has anyone come accross this problem before? ---(end of broadcast)--- TIP 2:

Re: [HACKERS] No user being created during initdb for OS X

2005-07-20 Thread Thomas F. O'Connell
Do you already have a postgres user on the system? And do you mean that initdb is not creating a postgres user in the database? Presumably, if run as the user that will own the server process, it should create that user in the database as well.

Re: [HACKERS] No user being created during initdb for OS X

2005-07-20 Thread Jamie Deppeler
I am doing it right /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data Thomas F. O'Connell wrote: Do you already have a postgres user on the system? And do you mean that initdb is not creating a postgres user in the database? Presumably, if run as the user that will own the server

Re: [HACKERS] Enticing interns to PostgreSQL

2005-07-20 Thread Jim C. Nasby
On Wed, Jul 20, 2005 at 03:43:04PM -0700, Jeff Davis wrote: Jim C. Nasby wrote: The email below about FreeBSD's involvement in Google's Summer of Code got me thinking; would there be value in trying to attract college students to working on either PostgreSQL development, or using