[BUGS] OSX problem with make check...

2004-08-10 Thread Theodore Petrosky
I just updated to OS X 10.3.5 and Xcode 1.5 my configure was ./configure --with-rendezvous make this is the error I get with 'make check'. I don't know if it's my fault but i read all the install docs and didn't see that I need to do anything special for the 'make check'... dyld: /Users/postgr

[BUGS] BUG #1208: Invalid page header

2004-08-10 Thread PostgreSQL Bugs List
The following bug has been logged online: Bug reference: 1208 Logged by: Robert E Bruccoleri Email address: [EMAIL PROTECTED] PostgreSQL version: 7.4 Operating system: Linux Advanced Server 2.1 and SGI ProPack 2.4 Description:Invalid page header Details: ==

Re: [BUGS] Bug: century/millenium still broken

2004-08-10 Thread Fabien COELHO
Dear Tom, > After all that about numbering centuries and millenia correctly, > why does CVS tip still give me > > regression=# select extract(century from now()); > date_part > --- > 20 > (1 row) > [ ... looks in code ... ] > > Apparently it's because you fixed only timestamp_par

[BUGS] BUG #1209: Problem related to installation

2004-08-10 Thread PostgreSQL Bugs List
The following bug has been logged online: Bug reference: 1209 Logged by: Sube Singh Email address: [EMAIL PROTECTED] PostgreSQL version: 7.5 Dev Operating system: WindowsXP Description:Problem related to installation Details: Hi I am facing the problem rela

[BUGS] 8.0.0beta1: -lpthread missing

2004-08-10 Thread Martin Münstermann
System Configuration - Architecture (example: Intel Pentium) : Intel Pentium Operating System (example: Linux 2.4.18) : Linux 2.4.21-grsec (Debian) PostgreSQL version (example: PostgreSQL-8.0): PostgreSQL-8.0.0-beta1 Compiler used (example: gcc 2.95.2)

[BUGS] 8.0.0beta1: make check fails on solaris8

2004-08-10 Thread Martin Münstermann
System Configuration - Architecture (example: Intel Pentium) : sun4u sparc SUNW,Ultra-250 Operating System (example: Linux 2.4.18) : Solaris8 (SunOS myhost 5.8 Generic_108528-29 ) PostgreSQL version (example: PostgreSQL-8.0): PostgreSQL-8.0.0 (beta1) C

[BUGS] Windows XP Service Pack 2 install failed

2004-08-10 Thread Geoff Nordli
I tried to install on XP SP2 and it failed with this error in the event log. Product: PostgreSQL 8.0-beta1 -- Failed to run initdb: 1! Please see the logfile in 'C:\Program Files\PostgreSQL\8.0-beta1\tmp\initdb.log'. I couldn't find the log file because the installation removed all the files in t

[BUGS] SOLARIS 9 ULTRASPARC BUILD

2004-08-10 Thread andrea . martano
hello, attached are the regression.out and regression.diffs files from make check on a Ultra 2 dual 300MHz CPU running Solaris 9 OS. Looks like no errorbut the expected due to difference in fp results. regression.diffs Description: Binary data regression.out Description: Binary data ---

[BUGS] Locale bug?

2004-08-10 Thread VÃclav VozÃr
Hi, if I choose in new version 8.0 for win32 czech locales then lc-collate is czech_czech republic.1250. So I suppose that strings are compared by WIN1250 charset, but database encoding can't be set as WIN1250 (only ISO8859-2=LATIN2) and then ORDER BY don't work correctly. I try make initdb my

Re: [BUGS] 8.0: Absolute path required for INITDB?

2004-08-10 Thread CoL
hi, Josh Berkus wrote, On 8/9/2004 21:20: Tom, Well, that does deserve investigation. But I've been initdb'ing frequently and not noticed any problems. What configure switches did you use exactly? Did you try to move the installation tree after configure? Here's the issue: if you start initdb fr

[BUGS] Installation of PostgreSQL

2004-08-10 Thread Sube Singh
Sir/Madam     I want to use PpstgreSQL windows 98 . But I am facing problem related to installation . How I configure it on my system.   thanks   Regards   sube singh   Yahoo! India Matrimony: Find your life partner online.

[BUGS] PG 8.0.0 on OpenBSD problems

2004-08-10 Thread bpalmer
7.* compiles clean and runs happy under the same shell / settings / etc bpalmer:/usr/home/bpalmer/CODE/postgresql-8.0.0beta1$ uname -an OpenBSD psidion.crimelabs.net 3.5 GENERIC#34 i386 gmake[4]: Leaving directory `/usr/home/bpalmer/CODE/postgresql-8.0.0beta1/src/port' gcc -O2 -fno-strict-ali

Re: [BUGS] Locale bug?

2004-08-10 Thread Peter Eisentraut
VÃclav VozÃr wrote: > if I choose in new version 8.0 for win32 czech locales then > lc-collate is czech_czech republic.1250. So I suppose that strings > are compared by WIN1250 charset, but database encoding can't be set > as WIN1250 (only ISO8859-2=LATIN2) and then ORDER BY don't work > correctly.

Re: [BUGS] 8.0.0beta1: make check fails on solaris8

2004-08-10 Thread Tom Lane
=?ISO-8859-15?Q?Martin_M=FCnstermann?= <[EMAIL PROTECTED]> writes: > make check gives me two errors, see attached diffs file. See my response to Andrea just now: This seems quite bizarre: ' -INFINiTY ' works but 'infinity' does not? Please try in psql \set VERBOSITY verbose

Re: [BUGS] SOLARIS 9 ULTRASPARC BUILD

2004-08-10 Thread Tom Lane
[EMAIL PROTECTED] writes: > attached are the regression.out and regression.diffs files from make check on a > Ultra 2 dual 300MHz CPU running Solaris 9 OS. This seems quite bizarre: ' -INFINiTY ' works but 'infinity' does not? Please try in psql \set VERBOSITY verbose

Re: [BUGS] 8.0.0beta1: -lpthread missing

2004-08-10 Thread Robert Treat
On Tuesday 10 August 2004 05:14, Martin Münstermann wrote: > System Configuration > - >Architecture (example: Intel Pentium) : Intel Pentium > >Operating System (example: Linux 2.4.18) : Linux 2.4.21-grsec > (Debian) > >PostgreSQL version (example: Postg

Re: [BUGS] BUG #1209: Problem related to installation

2004-08-10 Thread Bruce Momjian
Please search for pginstaller and use that. --- PostgreSQL Bugs List wrote: > > The following bug has been logged online: > > Bug reference: 1209 > Logged by: Sube Singh > > Email address: [EMAIL PROTEC

Re: [BUGS] SOLARIS 9 ULTRASPARC BUILD

2004-08-10 Thread Michael Fuhr
On Tue, Aug 10, 2004 at 03:23:33PM -0400, Tom Lane wrote: > [EMAIL PROTECTED] writes: > > attached are the regression.out and regression.diffs files from make check on a > > Ultra 2 dual 300MHz CPU running Solaris 9 OS. > > This seems quite bizarre: ' -INFINiTY ' works but > 'infinity'

Re: [BUGS] Installation of PostgreSQL

2004-08-10 Thread Gaetano Mendola
Sube Singh wrote: Sir/Madam I want to use PpstgreSQL windows 98 . But I am facing problem related to installation . How I configure it on my system. Is better you explain better your problem. Howevere if you are speaking about the 8.0beta1 installation I have to advice you that postgres on Win

Re: [BUGS] OSX problem with make check...

2004-08-10 Thread Tom Lane
Adam Witney <[EMAIL PROTECTED]> writes: > Ah, setting DYLD_LIBRARY_PATH does the trick Great. I'll add that to pg_regress.sh. > I notice that it has never built a .dylib library before... In 7.4.x I have > always had a libpq.so library. Is this new? Yup. regards, tom la

Re: [BUGS] OSX problem with make check...

2004-08-10 Thread Tom Lane
Theodore Petrosky <[EMAIL PROTECTED]> writes: > this is the error I get with 'make check'. > dyld: > /Users/postgres/software/postgresql-8.0.0beta1/src/test/regress/./tmp_check/install//usr/local/pgsql/bin/initdb > can't open library: /usr/local/pgsql/lib/libpq.3.dylib > (No such file or director

Re: [BUGS] OSX problem with make check...

2004-08-10 Thread Theodore Petrosky
I hope we are okay with this... I tried your path and it didn't work ... I am in bash so I did: export env DYLD_LIBRARY_PATH=/Users/postgres/software/postgresql-8.0.0beta1/src/interfaces/libpq Let me know if there is something else I could try. Ted --- Tom Lane <[EMAIL PROTECTED]> wrote: > Ada

Re: [BUGS] 8.0.0beta1: -lpthread missing

2004-08-10 Thread Bruce Momjian
In fact, backup in the output and look at the flags used to build libpq. Are they correct? If they are, you shouldn't need any additional flags when building initdb because initdb doesn't call any threaded functions, _except_ if you have that limitation that a libpq using threads requries a threa

Re: [BUGS] 8.0.0beta1: -lpthread missing

2004-08-10 Thread Bruce Momjian
Robert Treat wrote: > > `pthread_once' > > ../../../src/interfaces/libpq/libpq.so: undefined reference to > > `pthread_key_create' > > ../../../src/interfaces/libpq/libpq.so: undefined reference to > > `pthread_setspecific' > > collect2: ld returned 1 exit status > > > > > > > > Please describe a w