Re: [BUGS] postgres 7.1.3 wth perl 5.8.0

2004-08-11 Thread David Fetter
On Thu, Aug 12, 2004 at 12:05:49PM +0700, Christian wrote: > Tom Lane wrote: > > >Use a later release. > > > >Seriously, 7.1.* is not supported anymore. There are extremely > >serious known bugs in it that will never be fixed. I can't imagine > >a reason for you to be trying to build it rather t

Re: [BUGS] postgres 7.1.3 wth perl 5.8.0

2004-08-11 Thread Christian
Tom Lane wrote: Use a later release. Seriously, 7.1.* is not supported anymore. There are extremely serious known bugs in it that will never be fixed. I can't imagine a reason for you to be trying to build it rather than something more current. actually, we are upgrading our system the previously

Re: [BUGS] postgres 7.1.3 wth perl 5.8.0

2004-08-11 Thread Tom Lane
Christian <[EMAIL PROTECTED]> writes: > i was trying to install postgres 7.1.3 on Redhat 9, using perl 5.8.0-88.3, > ... > somebody know how to fix this problem? Use a later release. Seriously, 7.1.* is not supported anymore. There are extremely serious known bugs in it that will never be fixed.

[BUGS] postgres 7.1.3 wth perl 5.8.0

2004-08-11 Thread Christian
Hi, i was trying to install postgres 7.1.3 on Redhat 9, using perl 5.8.0-88.3, ./configure --enable-multibyte --enable-odbc --with-perl --with-java --with-tcl but make fails on plperl: gcc -c -I../../../src/include -D_REENTRANT -D_GNU_SOURCE -DTHREADS_HAVE_PIDS -DDEBUGGING -fno-strict-aliasing

Re: [BUGS] BUG #1215: Call sql function from plpgsql results vary.

2004-08-11 Thread Tom Lane
"PostgreSQL Bugs List" <[EMAIL PROTECTED]> writes: > I was playing around seeing what new things I could do in stored procedures. > Here is the statment I'm using to get the issue. > select * from f_trap_error(); > I expect the above statement to alway return 1 which it does. > The issue is I expec

[BUGS] 8.0.0beta1: Ownership of implicit sequences after dump/restore

2004-08-11 Thread Michael Fuhr
PostgreSQL version: 8.0.0beta1 Operating system : Solaris 9 Backups created by pg_dump/pg_dumpall don't set the ownership of implicitly-created sequences. When backups are restored, users who created sequences may not be able to use them. How to repeat: 1. Create a test user and a test databas

[BUGS] BUG #1215: Call sql function from plpgsql results vary.

2004-08-11 Thread PostgreSQL Bugs List
The following bug has been logged online: Bug reference: 1215 Logged by: Bob Henkel Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0 Beta Operating system: Windows XP Home SP1 Description:Call sql function from plpgsql results vary. Details: I was playi

Re: [BUGS] BUG #1214: ecpg regression in 8.0.0beta1

2004-08-11 Thread Tom Lane
"PostgreSQL Bugs List" <[EMAIL PROTECTED]> writes: > The following code snippet does not compile under 8.0.0beta1: > exec sql CREATE TEMPORARY TABLE OverallData (Class, Parameter, DataVal) > AS SELECT Class, Paramter, SUM(DataVal) > FROM PatrolData JOIN Metrics ON Parameter = MetricName > WH

[BUGS] BUG #1214: ecpg regression in 8.0.0beta1

2004-08-11 Thread PostgreSQL Bugs List
The following bug has been logged online: Bug reference: 1214 Logged by: R. Scott Bailey Email address: [EMAIL PROTECTED] PostgreSQL version: 7.5 Dev Operating system: Tru64 UNIX V5.1B Description:ecpg regression in 8.0.0beta1 Details: The following code snippe

[BUGS] BUG #1213: version 8.0 install error in beta1 msi

2004-08-11 Thread PostgreSQL Bugs List
The following bug has been logged online: Bug reference: 1213 Logged by: Steve Johnson Email address: [EMAIL PROTECTED] PostgreSQL version: 7.5 Dev Operating system: windows xp Description:version 8.0 install error in beta1 msi Details: During install of the 8

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

2004-08-11 Thread Tom Lane
Michael Fuhr <[EMAIL PROTECTED]> writes: > I've run numerous queries with variants of 'Infinity' and '-Infinity' > and I haven't been able to break it. Thanks for taking care of it. No problem. Appreciate the followup. regards, tom lane ---(end o

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

2004-08-11 Thread Michael Fuhr
On Wed, Aug 11, 2004 at 01:22:46PM -0400, Tom Lane wrote: > I've applied the attached patch to try to fix this problem with minimal > run-time cost. Since I don't have a Solaris machine I can't positively > confirm it works --- would one of you please test? == All 96 tests pa

Re: [BUGS] BUG #1212: 8.0.0beta1 build fails with bundled cc compiler

2004-08-11 Thread Tom Lane
"PostgreSQL Bugs List" <[EMAIL PROTECTED]> writes: > I found the following patch (relative to the postgresql-8.0.0beta1 > directory) was required in order to compile successfully: Thanks for the report --- fix committed. I wonder how we missed ANSI-fying that function in the first place?

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

2004-08-11 Thread Tom Lane
I've applied the attached patch to try to fix this problem with minimal run-time cost. Since I don't have a Solaris machine I can't positively confirm it works --- would one of you please test? regards, tom lane *** src/backend/utils/adt/float.c.orig Wed Aug 4 17:34:02

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

2004-08-11 Thread Tom Lane
=?ISO-8859-15?Q?Martin_M=FCnstermann?= <[EMAIL PROTECTED]> writes: > Yeah, with this patch the tests just pass on solaris8. Great, thanks for the confirmation. regards, tom lane ---(end of broadcast)--- TIP 9: the planner wi

Re: [BUGS] 8.0.0beta1: -lpthread missing

2004-08-11 Thread Bruce Momjian
OK, I have some more information. Basically, the config/acx_pthread.m4 manual page (http://www.gnu.org/software/ac-archive/htmldoc/acx_pthread.html) says: NOTE: You are assumed to not only compile your program with these flags, but also link it with them as well. e.g. you

[BUGS] BUG #1212: 8.0.0beta1 build fails with bundled cc compiler

2004-08-11 Thread PostgreSQL Bugs List
The following bug has been logged online: Bug reference: 1212 Logged by: R. Scott Bailey Email address: [EMAIL PROTECTED] PostgreSQL version: 7.5 Dev Operating system: Tru64 UNIX V5.1B Description:8.0.0beta1 build fails with bundled cc compiler Details: I just

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

2004-08-11 Thread Michael Fuhr
On Wed, Aug 11, 2004 at 10:34:24AM -0400, Tom Lane wrote: > Michael Fuhr <[EMAIL PROTECTED]> writes: > > I've replied on this topic a couple of times in the "SOLARIS 9 > > ULTRASPARC BUILD" thread, but perhaps my messages aren't getting > > through. On Solaris, when strtod() parses "infinity" or i

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

2004-08-11 Thread Michael Fuhr
On Wed, Aug 11, 2004 at 09:36:30AM -0400, Tom Lane wrote: > =?ISO-8859-15?Q?Martin_M=FCnstermann?= <[EMAIL PROTECTED]> writes: > > It's even a little more bizarre: > > When I start a fresh psql session, SELECT 'infinity'::float4 just works. > > Then I \i sql/float4.sql, and after that > > template1

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

2004-08-11 Thread Tom Lane
Michael Fuhr <[EMAIL PROTECTED]> writes: > I've replied on this topic a couple of times in the "SOLARIS 9 > ULTRASPARC BUILD" thread, but perhaps my messages aren't getting > through. On Solaris, when strtod() parses "infinity" or its > equivalent, it sets endptr one character beyond where it shou

Re: [BUGS] broken contrib/dbsize in cvs head?

2004-08-11 Thread Fabien COELHO
> > It seems that GetDatabasePath was updated, but not all its callers were > > fixed. > > This is a known issue; there's a patch in pgsql-patches fixing this very > issue while still not tablespace-aware for tables, and another patch > proposing new functions which offer tablespace size as well.

Re: [BUGS] broken contrib/dbsize in cvs head?

2004-08-11 Thread Andreas Pflug
Fabien COELHO wrote: contrib/dbsize> make gcc -O2 -fno-strict-aliasing -Wall -Wmissing-prototypes -Wmissing-declarations -fpic -I. -I../../src/include -D_GNU_SOURCE -c -o dbsize.o dbsize.c dbsize.c: In function `database_size': dbsize.c:58: error: too few arguments to function `GetDatabasePath' m

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

2004-08-11 Thread Tom Lane
>> My best guess about it is that strtod() is actively broken on your >> platform, and is recognizing the "infinity" input but returning an >> incorrect endptr. I seem to recall that we've heard of such bugs >> before. Can you check for any updates from Sun that might affect >> strtod()? Hmm, ta

[BUGS] broken bug-report web form

2004-08-11 Thread Fabien COELHO
I wanted to report a bug, but could not: http://www.postgresql.org/bugform.html ("Report a bug" link from postgresql main page) leads to: "Not Found, The requested URL /bugform.php was not found on this server." -- Fabien Coelho - [EMAIL PROTECTED] ---(end of broadcast

[BUGS] broken contrib/dbsize in cvs head?

2004-08-11 Thread Fabien COELHO
contrib/dbsize> make gcc -O2 -fno-strict-aliasing -Wall -Wmissing-prototypes -Wmissing-declarations -fpic -I. -I../../src/include -D_GNU_SOURCE -c -o dbsize.o dbsize.c dbsize.c: In function `database_size': dbsize.c:58: error: too few arguments to function `GetDatabasePath' make: *** [dbsize.o]

[BUGS] BUG #1211: JDBC connection

2004-08-11 Thread PostgreSQL Bugs List
The following bug has been logged online: Bug reference: 1211 Logged by: Diego Email address: [EMAIL PROTECTED] PostgreSQL version: 7.5 Dev Operating system: win xp pro Description:JDBC connection Details: I'm unable to connect to my 8.0 beta1 from JDBC, even r

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

2004-08-11 Thread Tom Lane
=?ISO-8859-15?Q?Martin_M=FCnstermann?= <[EMAIL PROTECTED]> writes: > It's even a little more bizarre: > When I start a fresh psql session, SELECT 'infinity'::float4 just works. > Then I \i sql/float4.sql, and after that > template1=# \set VERBOSITY verbose > template1=# SELECT 'infinity'::float4; >

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

2004-08-11 Thread Theodore Petrosky
This was my bad I thought I did what you suggested however looking through the terminal history I see that I left out part of the path. The export env works beautifully for me. Thanks, Ted --- Adam Witney <[EMAIL PROTECTED]> wrote: > > I'm not sure I understand you, but you are saying > t

[BUGS] BUG #1210: 8beta1 msi installer crashes when creating shared memory segment

2004-08-11 Thread PostgreSQL Bugs List
The following bug has been logged online: Bug reference: 1210 Logged by: wolfgang teschner Email address: [EMAIL PROTECTED] PostgreSQL version: 7.5 Dev Operating system: win2000 server SP4 Description:8beta1 msi installer crashes when creating shared memory segm

Re: [BUGS] PG 8.0.0 on OpenBSD problems

2004-08-11 Thread Peter Eisentraut
Am Dienstag, 10. August 2004 03:35 schrieb bpalmer: > gmake[4]: Leaving directory > `/usr/home/bpalmer/CODE/postgresql-8.0.0beta1/src/port' > gcc -O2 -fno-strict-aliasing -Wall -Wmissing-prototypes > -Wmissing-declarations -DFRONTEND -I../../../src/interfaces/libpq > -I../../../src/include -c -o