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 > >

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 process

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. http://www.postgresql.org/docs/8.0/static/app-

[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: Do

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 o

Re: [HACKERS] snapshot build broken ...

2005-07-20 Thread Tom Lane
"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 the nightly snapshot build ca

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 openjade:installa

[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

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

[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 non-

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

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 ba

[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 anyon

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

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] [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: > > /System/Library/

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 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) th

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 :-( > W

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 entire

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 in

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) I

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 ca

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 -no

[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 -curr