Re: [CYGWIN] [HACKERS] Request for supported platforms
This post is just for closure -- both of the issues below have been resolved: On Tue, Oct 29, 2002 at 09:47:35AM -0500, Jason Tishler wrote: 1. Cygwin bison needs to be upgraded from 1.35 to 1.75 (i.e., 1.50+) to process src/interfaces/ecpg/preproc/preproc.y successfully. I will post to the Cygwin mailing list asking the maintainer for this upgrade. OK. This shouldn't stop a release though I assume, only a build from CVS. Yes. Nevertheless, I have posted my request: http://cygwin.com/ml/cygwin/2002-10/msg01740.html http://cygwin.com/ml/cygwin-announce/2002-10/msg00016.html 2. The following fseeko/ftello ifdef in src/include/pg_config.h.in: #ifndef HAVE_FSEEKO #define fseeko(a, b, c) fseek((a), (b), (c)) #define ftello(a) ftell((a)) #endif conflicts with the following Cygwin /usr/include/stdio.h entries: int _EXFUN(fseeko, (FILE *, off_t, int)); off_t _EXFUN(ftello, ( FILE *)); Unfortunately, I'm not sure what is the best way to solve this one yet. Any suggestions would be appreciated. I found a solution to the above which will hopefully find its way into the next Cygwin release: http://cygwin.com/ml/cygwin-patches/2002-q4/msg00042.html http://cygwin.com/ml/cygwin-patches/2002-q4/msg00089.html Jason -- PGP/GPG Key: http://www.tishler.net/jason/pubkey.asc or key servers Fingerprint: 7A73 1405 7F2B E669 C19D 8784 1AFD E4CC ECF4 8EF6 ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [HACKERS] Request for supported platforms
On Tue, 2002-11-05 at 00:40, Bruce Momjian wrote: Ports list updated: http://candle.pha.pa.us/main/writings/pgsql/sgml/supported-platforms.html Please note that you have an entry for Digital Unix and one for Compaq Tru64 while in fact they are the same OS that went through a whirlwind of name changes. Don't know if official name should be now HP Tru64 or some other... -- Alessio F. Bragadini[EMAIL PROTECTED] APL Financial Services http://village.albourne.com Nicosia, Cyprus phone: +357-22-755750 It is more complicated than you think -- The Eighth Networking Truth from RFC 1925 ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
Re: [HACKERS] Request for supported platforms
-Original Message- From: Bruce Momjian [mailto:pgman;candle.pha.pa.us] Sent: 05 November 2002 03:18 To: Sean Chittenden Cc: Tom Lane; Larry Rosenman; PostgreSQL-development Subject: Re: [HACKERS] Request for supported platforms Ports list updated: http://candle.pha.pa.us/main/writings/pgsql/sgml/supported-pla tforms.html Hi Bruce, I noticed that you haven't updated the entry for Win32 native client-only. That builds OK now thanks to your fixes. Regards, Dave. ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [HACKERS] Request for supported platforms
Dave Page wrote: -Original Message- From: Bruce Momjian [mailto:pgman;candle.pha.pa.us] Sent: 05 November 2002 03:18 To: Sean Chittenden Cc: Tom Lane; Larry Rosenman; PostgreSQL-development Subject: Re: [HACKERS] Request for supported platforms Ports list updated: http://candle.pha.pa.us/main/writings/pgsql/sgml/supported-pla tforms.html Hi Bruce, I noticed that you haven't updated the entry for Win32 native client-only. That builds OK now thanks to your fixes. Thanks. Updated. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
Re: [HACKERS] Request for supported platforms
Yes, now it is Digital/HP/Compaq. Updated to existing Tru64 entry. Ports list updated: http://candle.pha.pa.us/main/writings/pgsql/sgml/supported-platforms.html --- Alessio Bragadini wrote: On Tue, 2002-11-05 at 00:40, Bruce Momjian wrote: Ports list updated: http://candle.pha.pa.us/main/writings/pgsql/sgml/supported-platforms.html Please note that you have an entry for Digital Unix and one for Compaq Tru64 while in fact they are the same OS that went through a whirlwind of name changes. Don't know if official name should be now HP Tru64 or some other... -- Alessio F. Bragadini [EMAIL PROTECTED] APL Financial Serviceshttp://village.albourne.com Nicosia, Cyprus phone: +357-22-755750 It is more complicated than you think -- The Eighth Networking Truth from RFC 1925 ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED]) -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
Re: [HACKERS] Request for supported platforms
On Fri, Nov 01, 2002 at 10:22:42AM -0500, Tom Lane wrote: I've committed fixes for the other issues too, so CVS tip should now pass cleanly on your platform. I've built the snapshot from CVS tip and now the regression tests pass with both GCC 2.95.1 and Compaq C V6.4-216 (dtk) on Digital UNIX V4.0G (Rev. 1530). Thank you very much for your help! -- Alessio F. Bragadini[EMAIL PROTECTED] APL Financial Services http://village.albourne.com Nicosia, Cyprus phone: +357-22-755750 It is more complicated than you think -- The Eighth Networking Truth from RFC 1925 ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [HACKERS] Request for supported platforms
Ports list updated: http://candle.pha.pa.us/main/writings/pgsql/sgml/supported-platforms.html --- Sean Chittenden wrote: Or at least it's *trying* to apply it for 4.7 --- as near as I can tell without testing, the above scrap of resultmap code is wrong because both of the i.86 lines will match on FreeBSD 4.7, and I think the pg_regress coding will take the last match. Larry, did you actually test the CVS-tip resultmap to make sure it picks the right comparison file on your box? Yes, just did and it *FAILS*. you need the order you have below. Sorry... Okay, I've updated the CVS tip to look like this: geometry/i.86-.*-freebsd=geometry-positive-zeros-bsd geometry/i.86-.*-freebsd4.7=geometry-bsd-precision geometry/i.86-.*-freebsd5=geometry-bsd-precision geometry/alpha.*-freebsd=geometry-positive-zeros Sean, would you verify this works for you? It does, thank you. I've just updated the -devel port to 7.3b4, hopefully the mirrors will pick up the bits soon. -sc -- Sean Chittenden -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [CYGWIN] [HACKERS] Request for supported platforms
Peter, On Wed, Oct 30, 2002 at 07:36:40PM +0100, Peter Eisentraut wrote: Dave Page writes: Hackers: As the Cygwin release that is actively supported is the binary distribution that Jason builds, I would think this is OK to be listed as supported if no-one disagrees... I disagree. We document as supported those platforms that build out of the box, not those that build somehow, somewhere, by someone. Rather than advocating methods to manually edit your system headers we should try to find out what the problem really is, such as by analyzing config.log. Did you miss the following? http://archives.postgresql.org/pgsql-hackers/2002-10/msg01303.php As you can see, I have already performed root cause analysis of theses problems *and* have taken the proper steps to ensure that PostgreSQL builds OOTB under Cygwin (after the next Cygwin release). Jason ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [HACKERS] Request for supported platforms
Ports list updated: http://candle.pha.pa.us/main/writings/pgsql/sgml/supported-platforms.html --- Alessio Bragadini wrote: On Fri, Nov 01, 2002 at 10:22:42AM -0500, Tom Lane wrote: I've committed fixes for the other issues too, so CVS tip should now pass cleanly on your platform. I've built the snapshot from CVS tip and now the regression tests pass with both GCC 2.95.1 and Compaq C V6.4-216 (dtk) on Digital UNIX V4.0G (Rev. 1530). Thank you very much for your help! -- Alessio F. Bragadini [EMAIL PROTECTED] APL Financial Serviceshttp://village.albourne.com Nicosia, Cyprus phone: +357-22-755750 It is more complicated than you think -- The Eighth Networking Truth from RFC 1925 ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
Re: [HACKERS] Request for supported platforms
Or at least it's *trying* to apply it for 4.7 --- as near as I can tell without testing, the above scrap of resultmap code is wrong because both of the i.86 lines will match on FreeBSD 4.7, and I think the pg_regress coding will take the last match. Larry, did you actually test the CVS-tip resultmap to make sure it picks the right comparison file on your box? Yes, just did and it *FAILS*. you need the order you have below. Sorry... Okay, I've updated the CVS tip to look like this: geometry/i.86-.*-freebsd=geometry-positive-zeros-bsd geometry/i.86-.*-freebsd4.7=geometry-bsd-precision geometry/i.86-.*-freebsd5=geometry-bsd-precision geometry/alpha.*-freebsd=geometry-positive-zeros Sean, would you verify this works for you? It does, thank you. I've just updated the -devel port to 7.3b4, hopefully the mirrors will pick up the bits soon. -sc -- Sean Chittenden ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [HACKERS] Request for supported platforms
On Thu, 2002-10-31 at 18:53, Tom Lane wrote: Evidently main.c needs #include errno.h added. I wonder what have changed since Beta2 that compiled fine... Please add that and see if you get any further. Done, and now it builds (I've limited the test to native cc compiler for now). But it doesn't pass two regression tests, float8 and alter_table. The diffs seem to me non-trivial, I've attached the results. Any idea? -- Alessio F. Bragadini[EMAIL PROTECTED] APL Financial Services http://village.albourne.com Nicosia, Cyprus phone: +357-22-755750 It is more complicated than you think -- The Eighth Networking Truth from RFC 1925 *** ./expected/float8-fp-exception.out Thu Mar 30 10:46:00 2000 --- ./results/float8.out Fri Nov 1 10:16:14 2002 *** *** 149,161 | 1.2345678901234e-200 |0 (5 rows) SELECT sqrt(float8 '64') AS eight; eight --- 8 (1 row) - -- square root SELECT |/ float8 '64' AS eight; eight --- --- 149,194 | 1.2345678901234e-200 |0 (5 rows) + -- ceil + select ceil(f1) as ceil_f1 from float8_tbl f; +ceil_f1 + -- + 0 + 1005 + -34 + 1.2345678901234e+200 + 1 + (5 rows) + + -- floor + select floor(f1) as floor_f1 from float8_tbl f; +floor_f1 + -- + 0 + 1004 + -35 + 1.2345678901234e+200 + 0 + (5 rows) + + -- sign + select sign(f1) as sign_f1 from float8_tbl f; + sign_f1 + - +0 +1 + -1 +1 +1 + (5 rows) + + -- square root SELECT sqrt(float8 '64') AS eight; eight --- 8 (1 row) SELECT |/ float8 '64' AS eight; eight --- == *** ./expected/alter_table.out Sat Oct 19 04:35:43 2002 --- ./results/alter_table.out Fri Nov 1 10:17:19 2002 *** *** 940,1168 alter table atacc1 drop d; alter table atacc1 drop b; select * from atacc1; ! ! -- ! (1 row) ! ! drop table atacc1; ! -- test inheritance ! create table parent (a int, b int, c int); ! insert into parent values (1, 2, 3); ! alter table parent drop a; ! create table child (d varchar(255)) inherits (parent); ! insert into child values (12, 13, 'testing'); ! select * from parent; ! b | c ! + ! 2 | 3 ! 12 | 13 ! (2 rows) ! ! select * from child; ! b | c |d ! ++- ! 12 | 13 | testing ! (1 row) ! ! alter table parent drop c; ! select * from parent; ! b ! ! 2 ! 12 ! (2 rows) ! ! select * from child; ! b |d ! +- ! 12 | testing ! (1 row) ! ! drop table child; ! drop table parent; ! -- test copy in/out ! create table test (a int4, b int4, c int4); ! insert into test values (1,2,3); ! alter table test drop a; ! copy test to stdout; ! 2 3 ! copy test(a) to stdout; ! ERROR: Relation test has no column a ! copy test(pg.dropped.1) to stdout; ! ERROR: Relation test has no column pg.dropped.1 ! copy test from stdin; ! ERROR: copy: line 1, Extra data after last expected column ! lost synchronization with server, resetting connection ! SET autocommit TO 'on'; ! select * from test; ! b | c ! ---+--- ! 2 | 3 ! (1 row) ! ! copy test from stdin; ! select * from test; ! b | c ! + ! 2 | 3 ! 21 | 22 ! (2 rows) ! ! copy test(a) from stdin; ! ERROR: Relation test has no column a ! copy test(pg.dropped.1) from stdin; ! ERROR: Relation test has no column pg.dropped.1 ! copy test(b,c) from stdin; ! select * from test; ! b | c ! + ! 2 | 3 ! 21 | 22 ! 31 | 32 ! (3 rows) ! ! drop table test; ! -- test inheritance ! create table dropColumn (a int, b int, e int); ! create table dropColumnChild (c int) inherits (dropColumn); ! create table dropColumnAnother (d int) inherits (dropColumnChild); ! -- these two should fail ! alter table dropColumnchild drop column a; ! ERROR: ALTER TABLE: Cannot drop inherited column a ! alter table only dropColumnChild drop column b; ! ERROR: ALTER TABLE: Cannot drop inherited column b ! -- these three should work ! alter table only dropColumn drop column e; ! alter table dropColumnChild drop column c; ! alter table dropColumn drop column a; ! create table renameColumn (a int); ! create table renameColumnChild (b int) inherits (renameColumn); ! create table renameColumnAnother (c int) inherits (renameColumnChild); ! -- these three should fail ! alter table renameColumnChild rename column a to d; ! ERROR: renameatt: inherited attribute a may not be renamed ! alter table only renameColumnChild rename column a to d; ! ERROR: Inherited attribute a must be renamed in child tables too ! alter table only
Re: [HACKERS] Request for supported platforms
Alessio Bragadini [EMAIL PROTECTED] writes: On Thu, 2002-10-31 at 18:53, Tom Lane wrote: Evidently main.c needs #include errno.h added. I wonder what have changed since Beta2 that compiled fine... That is odd. main.c itself certainly has not changed. Done, and now it builds (I've limited the test to native cc compiler for now). But it doesn't pass two regression tests, float8 and alter_table. The diffs seem to me non-trivial, I've attached the results. The float8 diff appears to be because new test cases were added to float8.sql, but not all the float8 output variants were updated to match :-(. I will take care of that. The alter_table diff is clearly indicative of a bug. Can you set a breakpoint and discover exactly where calloc is blowing up? (For lack of a better idea, I'm going to guess that calloc rejects a zero argument on your platform.) regards, tom lane ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
Re: [HACKERS] Request for supported platforms
I said: The alter_table diff is clearly indicative of a bug. Can you set a breakpoint and discover exactly where calloc is blowing up? Never mind, I see it: psql is doing calloc(0) when presented with a table of zero columns. Surprising you're the first to try it on a platform where that returns NULL. I've committed fixes for the other issues too, so CVS tip should now pass cleanly on your platform. regards, tom lane ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [HACKERS] Request for supported platforms
On Fri, 2002-11-01 at 01:57, Sean Chittenden wrote: Seems like someone ought to issue a call for port reports. The supported platforms list hasn't been touched ... Good point. Thomas, can you take that on? No, at least not now. I'm not able to communicate reliably with the mailing lists, and so can not coordinate anything :( Not sure when or if that will be resolved, but I'll be out of town next week so... [ Reposted with proper subject line.] OK, Tom will be away next week, and Thomas will too. I can do it. Folks. start sending in those plaform reports, OS name and version number please. The current platform list is: http://developer.postgresql.org/docs/postgres/supported-platforms.html $ uname -a FreeBSD avienda.nxad.com 5.0-CURRENT FreeBSD 5.0-CURRENT #1: Mon Oct 28 18:20:14 PST 2002 [EMAIL PROTECTED]:/usr/obj/usr/src/sys/DELLAPTOP i386 $ gcc -v Using built-in specs. Configured with: FreeBSD/i386 system compiler Thread model: posix gcc version 3.2.1 [FreeBSD] 20021009 (prerelease) Looks like the only problem on beta3 is that the geometry bits are failing, but I'm not 100% if they haven't already been solved. -sc Can you check it against the geometry-bsd[i]-precision.out file? (depending on whether you've updated since the weekend). If it matches, we need to update the resultmap. LER -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812 E-Mail: [EMAIL PROTECTED] US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749 ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
Re: [HACKERS] Request for supported platforms
Sean Chittenden [EMAIL PROTECTED] writes: $ uname -a FreeBSD avienda.nxad.com 5.0-CURRENT FreeBSD 5.0-CURRENT #1: Mon Oct 28 18:20:14 PST 2002 [EMAIL PROTECTED]:/usr/obj/usr/src/sys/DELLAPTOP i386 Looks like the only problem on beta3 is that the geometry bits are failing, but I'm not 100% if they haven't already been solved. -sc Hmm. Evidently you now have support for minus-zero. It looks like we have an updated comparison file for that case for FreeBSD, but it's only being applied for FreeBSD 4.7: geometry/i.86-.*-freebsd4.7=geometry-bsd-precision geometry/i.86-.*-freebsd=geometry-positive-zeros-bsd geometry/alpha.*-freebsd=geometry-positive-zeros Or at least it's *trying* to apply it for 4.7 --- as near as I can tell without testing, the above scrap of resultmap code is wrong because both of the i.86 lines will match on FreeBSD 4.7, and I think the pg_regress coding will take the last match. Larry, did you actually test the CVS-tip resultmap to make sure it picks the right comparison file on your box? We could possibly do geometry/i.86-.*-freebsd=geometry-positive-zeros-bsd geometry/i.86-.*-freebsd4.7=geometry-bsd-precision geometry/i.86-.*-freebsd5=geometry-bsd-precision geometry/alpha.*-freebsd=geometry-positive-zeros which is mighty ugly, but I'm hopeful that by the next PG release we'll have gotten rid of most of the platform-to-platform geometry variants anyway. regards, tom lane ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [HACKERS] Request for supported platforms
On Fri, 2002-11-01 at 09:53, Tom Lane wrote: Sean Chittenden [EMAIL PROTECTED] writes: $ uname -a FreeBSD avienda.nxad.com 5.0-CURRENT FreeBSD 5.0-CURRENT #1: Mon Oct 28 18:20:14 PST 2002 [EMAIL PROTECTED]:/usr/obj/usr/src/sys/DELLAPTOP i386 Looks like the only problem on beta3 is that the geometry bits are failing, but I'm not 100% if they haven't already been solved. -sc Hmm. Evidently you now have support for minus-zero. It looks like we have an updated comparison file for that case for FreeBSD, but it's only being applied for FreeBSD 4.7: geometry/i.86-.*-freebsd4.7=geometry-bsd-precision geometry/i.86-.*-freebsd=geometry-positive-zeros-bsd geometry/alpha.*-freebsd=geometry-positive-zeros Or at least it's *trying* to apply it for 4.7 --- as near as I can tell without testing, the above scrap of resultmap code is wrong because both of the i.86 lines will match on FreeBSD 4.7, and I think the pg_regress coding will take the last match. Larry, did you actually test the CVS-tip resultmap to make sure it picks the right comparison file on your box? Yes, just did and it *FAILS*. you need the order you have below. Sorry... We could possibly do geometry/i.86-.*-freebsd=geometry-positive-zeros-bsd geometry/i.86-.*-freebsd4.7=geometry-bsd-precision geometry/i.86-.*-freebsd5=geometry-bsd-precision geometry/alpha.*-freebsd=geometry-positive-zeros which is mighty ugly, but I'm hopeful that by the next PG release we'll have gotten rid of most of the platform-to-platform geometry variants anyway. regards, tom lane -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812 E-Mail: [EMAIL PROTECTED] US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749 ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [HACKERS] Request for supported platforms
Larry Rosenman [EMAIL PROTECTED] writes: On Fri, 2002-11-01 at 09:53, Tom Lane wrote: Or at least it's *trying* to apply it for 4.7 --- as near as I can tell without testing, the above scrap of resultmap code is wrong because both of the i.86 lines will match on FreeBSD 4.7, and I think the pg_regress coding will take the last match. Larry, did you actually test the CVS-tip resultmap to make sure it picks the right comparison file on your box? Yes, just did and it *FAILS*. you need the order you have below. Sorry... Okay, I've updated the CVS tip to look like this: geometry/i.86-.*-freebsd=geometry-positive-zeros-bsd geometry/i.86-.*-freebsd4.7=geometry-bsd-precision geometry/i.86-.*-freebsd5=geometry-bsd-precision geometry/alpha.*-freebsd=geometry-positive-zeros Sean, would you verify this works for you? regards, tom lane ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [HACKERS] Request for supported platforms
Folks. start sending in those plaform reports, OS name and version number please. DOESN'T WORK on Digital Unix/Tru64 4.0g, with both cc or gcc compiler. Using Compaq C V6.4-216 (dtk) on Digital UNIX V4.0G (Rev. 1530) Compiler Driver V6.4-013 (dtk) cc Driver: make[3]: Entering directory `/usr/local/src/postgresql-7.3b3/src/backend/main' cc -std -O4 -Olimit 2000 -I../../../src/include -I/usr/local/include -c -o main.o main.c cc: Error: main.c, line 83: In this statement, errno is not declared. (undeclared) fprintf(stderr, gettext(%s: setsysinfo failed: %s\n), argv[0], strerror(errno)); --^ make[3]: *** [main.o] Error 1 same with GCC 2.95.1. make[1]: Entering directory `/usr/local/src/postgresql-7.3b3-gcc/src/backend/main' gcc -Wall -Wmissing-prototypes -Wmissing-declarations -I../../../src/include -I/usr/local/include -c -o main.o main.c main.c: In function `main': main.c:83: `errno' undeclared (first use in this function) make[1]: *** [main.o] Error 1 So, errno function is undefined. This is quite strange, because that section hasn't been changed in the last few months. It's activated from two different #if: one is #if defined(__alpha) other is #if defined(NOFIXADE) || defined(NOPRINTADE) Maybe is the setting of NOFIXADE or NOPRINTADE to be changed upstream? -- Alessio F. Bragadini[EMAIL PROTECTED] APL Financial Services http://village.albourne.com Nicosia, Cyprus phone: +357-22-755750 It is more complicated than you think -- The Eighth Networking Truth from RFC 1925 ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [HACKERS] Request for supported platforms
Alessio Bragadini [EMAIL PROTECTED] writes: Folks. start sending in those plaform reports, OS name and version number please. DOESN'T WORK on Digital Unix/Tru64 4.0g, with both cc or gcc compiler. Evidently main.c needs #include errno.h added. Please add that and see if you get any further. There might be other files with the same problem? regards, tom lane ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
Re: [HACKERS] Request for supported platforms
Seems like someone ought to issue a call for port reports. The supported platforms list hasn't been touched ... Good point. Thomas, can you take that on? No, at least not now. I'm not able to communicate reliably with the mailing lists, and so can not coordinate anything :( Not sure when or if that will be resolved, but I'll be out of town next week so... [ Reposted with proper subject line.] OK, Tom will be away next week, and Thomas will too. I can do it. Folks. start sending in those plaform reports, OS name and version number please. The current platform list is: http://developer.postgresql.org/docs/postgres/supported-platforms.html $ uname -a FreeBSD avienda.nxad.com 5.0-CURRENT FreeBSD 5.0-CURRENT #1: Mon Oct 28 18:20:14 PST 2002 [EMAIL PROTECTED]:/usr/obj/usr/src/sys/DELLAPTOP i386 $ gcc -v Using built-in specs. Configured with: FreeBSD/i386 system compiler Thread model: posix gcc version 3.2.1 [FreeBSD] 20021009 (prerelease) Looks like the only problem on beta3 is that the geometry bits are failing, but I'm not 100% if they haven't already been solved. -sc *** ./expected/geometry-positive-zeros-bsd.out Tue Sep 12 14:07:16 2000 --- ./results/geometry.out Thu Oct 31 23:53:31 2002 *** *** 114,120 | (5.1,34.5) | [(1,2),(3,4)] | (3,4) | (-5,-12) | [(1,2),(3,4)] | (1,2) | (10,10)| [(1,2),(3,4)] | (3,4) ! | (0,0) | [(0,0),(6,6)] | (0,0) | (-10,0)| [(0,0),(6,6)] | (0,0) | (-3,4) | [(0,0),(6,6)] | (0.5,0.5) | (5.1,34.5) | [(0,0),(6,6)] | (6,6) --- 114,120 | (5.1,34.5) | [(1,2),(3,4)] | (3,4) | (-5,-12) | [(1,2),(3,4)] | (1,2) | (10,10)| [(1,2),(3,4)] | (3,4) ! | (0,0) | [(0,0),(6,6)] | (-0,0) | (-10,0)| [(0,0),(6,6)] | (0,0) | (-3,4) | [(0,0),(6,6)] | (0.5,0.5) | (5.1,34.5) | [(0,0),(6,6)] | (6,6) *** *** 224,233 twentyfour | rotation +- | (0,0),(0,0) ! | (0,0),(-20,-20) ! | (0,2),(-14,0) | (0,79.2),(-58.8,0) ! | (14,0),(0,-34) | (0,40),(0,0) | (0,0),(0,0) | (-10,-10),(-30,-30) --- 224,233 twentyfour | rotation +- | (0,0),(0,0) ! | (-0,0),(-20,-20) ! | (-0,2),(-14,0) | (0,79.2),(-58.8,0) ! | (14,-0),(0,-34) | (0,40),(0,0) | (0,0),(0,0) | (-10,-10),(-30,-30) *** *** 254,264 WHERE (p.f1 - point '(0,0)') = 1; twenty | rotation +--- ! | (0,0),(-0.2,-0.2) | (-0.1,-0.1),(-0.3,-0.3) | (-0.25,-0.25),(-0.25,-0.35) | (-0.3,-0.3),(-0.3,-0.3) ! | (0.08,0),(0,-0.56) | (0.12,-0.28),(0.04,-0.84) | (0.26,-0.7),(0.1,-0.82) | (0.12,-0.84),(0.12,-0.84) --- 254,264 WHERE (p.f1 - point '(0,0)') = 1; twenty | rotation +--- ! | (0,-0),(-0.2,-0.2) | (-0.1,-0.1),(-0.3,-0.3) | (-0.25,-0.25),(-0.25,-0.35) | (-0.3,-0.3),(-0.3,-0.3) ! | (0.08,-0),(0,-0.56) | (0.12,-0.28),(0.04,-0.84) | (0.26,-0.7),(0.1,-0.82) | (0.12,-0.84),(0.12,-0.84) *** *** 266,272 | (0.0976764836465887,-0.0241724631246608),(0.0325588278821962,-0.0725173893739825) | (0.109762715208919,-0.0562379754328844),(0.0813970697054906,-0.0604311578116521) | (0.0976764836465887,-0.0725173893739825),(0.0976764836465887,-0.0725173893739825) ! | (0,0.0828402366863905),(-0.201183431952663,0) | (-0.100591715976331,0.124260355029586),(-0.301775147928994,0.0414201183431953) | (-0.251479289940828,0.103550295857988),(-0.322485207100592,0.0739644970414201) | (-0.301775147928994,0.124260355029586),(-0.301775147928994,0.124260355029586) --- 266,272 | (0.0976764836465887,-0.0241724631246608),(0.0325588278821962,-0.0725173893739825) | (0.109762715208919,-0.0562379754328844),(0.0813970697054906,-0.0604311578116521) | (0.0976764836465887,-0.0725173893739825),(0.0976764836465887,-0.0725173893739825) ! |
Re: [CYGWIN] [HACKERS] Request for supported platforms
Dave Page writes: Hackers: As the Cygwin release that is actively supported is the binary distribution that Jason builds, I would think this is OK to be listed as supported if no-one disagrees... I disagree. We document as supported those platforms that build out of the box, not those that build somehow, somewhere, by someone. Rather than advocating methods to manually edit your system headers we should try to find out what the problem really is, such as by analyzing config.log. -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [HACKERS] Request for supported platforms
Bruce, Not sure. I know Tom Lane ran a check on 10.1.x and didn't have any errors, so I figured the differences I saw reflected changes made by Apple between 10.1.x and 10.2.x. Then, I was surprised when I saw Adam's report, so I thought perhaps he was running on a PPC G3 and there were differences between G3 and G4 floating point handling (I had run the original regression tests on a PowerBook G4/400 MHz). So, I ran the same exact scenario on my aging iMac (G3/266 Mhz). Those results corroborated my original test (geometry failed; horology cleared up, though, as expected). So, something is different between Adam's system and the two I have easy access to. I have confirmed that both my systems are running 10.2.1. Similarly, the tests were both run on 7.3b3 from the full tarball on ftp.us.postgresql.org. The new iMac G3 regression.diffs output is immediately below. Regardless, it would appear that Mac OS X 10.2.x is well supported. Tara *** ./expected/geometry-powerpc-darwin.out Mon Dec 11 11:45:16 2000 --- ./results/geometry.out Tue Oct 29 07:59:59 2002 *** *** 127,133 | (-5,-12) | [(10,-10),(-3,-4)]| (-1.60487804878049,-4.64390243902439) | (10,10)| [(10,-10),(-3,-4)]| (2.39024390243902,-6.48780487804878) | (0,0) | [(-100,200),(30,-40)] | (0.0028402365895872,15.384614860264) ! | (-10,0)| [(-100,200),(30,-40)] | (-9.99715942258202,15.3864610140472) | (-3,4) | [(-100,200),(30,-40)] | (-2.99789812267519,15.3851688427303) | (5.1,34.5) | [(-100,200),(30,-40)] | (5.09647083221496,15.3836744976925) | (-5,-12) | [(-100,200),(30,-40)] | (-4.99494420845634,15.3855375281616) --- 127,133 | (-5,-12) | [(10,-10),(-3,-4)]| (-1.60487804878049,-4.64390243902439) | (10,10)| [(10,-10),(-3,-4)]| (2.39024390243902,-6.48780487804878) | (0,0) | [(-100,200),(30,-40)] | (0.0028402365895872,15.384614860264) ! | (-10,0)| [(-100,200),(30,-40)] | (-9.99715942258202,15.3864610140473) | (-3,4) | [(-100,200),(30,-40)] | (-2.99789812267519,15.3851688427303) | (5.1,34.5) | [(-100,200),(30,-40)] | (5.09647083221496,15.3836744976925) | (-5,-12) | [(-100,200),(30,-40)] | (-4.99494420845634,15.3855375281616) == Bruce Momjian wrote: Strange. I just got report from another OSX 10.2.1 user saying regression tests passed: 10.2.1, Adam Witney ([EMAIL PROTECTED] The proper value seems to be: 15.3864610140472 or 15.3864610140473 in ./expected/geometry-powerpc-darwin.out. Which is it, folks? --- Tara Piorkowski wrote: Tom Lane wrote: Bruce Momjian writes: Folks. start sending in those plaform reports, OS name and version number please. I've checked CVS tip on: HPUX 10.20, using both gcc and vendor's cc PPC Linux Mac OS X 10.1 Here's the regression.diffs file from Mac OS X 10.2.1 (Jaguar). It failed geometry (rounding) and horology (not sure). gcc -v returns Apple Computer, Inc. GCC version 1161, based on gcc version 3.1 20020420 (prerelease). *** ./expected/geometry-powerpc-darwin.out Mon Dec 11 11:45:16 2000 --- ./results/geometry.out Sun Oct 27 21:27:11 2002 *** *** 127,133 | (-5,-12) | [(10,-10),(-3,-4)]| (-1.60487804878049,-4.64390243902439) | (10,10)| [(10,-10),(-3,-4)]| (2.39024390243902,-6.48780487804878) | (0,0) | [(-100,200),(30,-40)] | (0.0028402365895872,15.384614860264) ! | (-10,0)| [(-100,200),(30,-40)] | (-9.99715942258202,15.3864610140472) | (-3,4) | [(-100,200),(30,-40)] | (-2.99789812267519,15.3851688427303) | (5.1,34.5) | [(-100,200),(30,-40)] | (5.09647083221496,15.3836744976925) | (-5,-12) | [(-100,200),(30,-40)] | (-4.99494420845634,15.3855375281616) --- 127,133 | (-5,-12) | [(10,-10),(-3,-4)]| (-1.60487804878049,-4.64390243902439) | (10,10)| [(10,-10),(-3,-4)]| (2.39024390243902,-6.48780487804878) | (0,0) | [(-100,200),(30,-40)] | (0.0028402365895872,15.384614860264) ! | (-10,0)| [(-100,200),(30,-40)] | (-9.99715942258202,15.3864610140473) | (-3,4) | [(-100,200),(30,-40)] | (-2.99789812267519,15.3851688427303) | (5.1,34.5) | [(-100,200),(30,-40)] | (5.09647083221496,15.3836744976925) | (-5,-12) | [(-100,200),(30,-40)] | (-4.99494420845634,15.3855375281616) == ***
Re: [HACKERS] Request for supported platforms
On 29/10/02 1:50 pm, Tom Lane [EMAIL PROTECTED] wrote: Bruce Momjian [EMAIL PROTECTED] writes: Strange. I just got report from another OSX 10.2.1 user saying regression tests passed: 10.2.1, Adam Witney ([EMAIL PROTECTED] The proper value seems to be: 15.3864610140472 or 15.3864610140473 in ./expected/geometry-powerpc-darwin.out. Which is it, folks? The existing geometry file is exactly correct on my laptop (Powerbook G3 using OSX 10.1). I am not sure whether the differences some users have reported are due to hardware or OS version differences. We need to figure that out and refine the resultmap, not just change the existing file. I don't have a lot of experience with this stuff, but let me know what to try and I will try it. (Using a Powerbook G4 OSX 10.2.1) Cheers adam -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
Re: [HACKERS] Request for supported platforms
I have reviewed your diff and found that it was either timezone changes or join.sql which I have recently fixed. Can you grab current CVS snapshot and try again? --- Ian Barwick wrote: On Tuesday 29 October 2002 01:56, Bruce Momjian wrote: Sorry, Ian, here is the patch I applied. You can apply this to whatever version you are using and test Irix with that, rather than having to grab CVS. OK, I have carried out make check with the updated tests but got FAILED on the same four tests (abstime, tinterval, horology, join). The failures are subtly different (see here for new regression diff): http://home.akademie.de/~IBarwick/IRIX_65_1.regression.diffs Having looked at them again I see the following: - in horology the timestamp tests seem to have succeeded (presumably the previous failures were triggered by the change to winter time); - the tests which are still failing in abstime, tinterval and horology all refer to dates before 1970, where AFAICS they are all out by one hour; possibly this explanation?: Some systems using older time zone libraries fail to apply daylight-saving corrections to dates before 1970, causing pre-1970 PDT times to be displayed in PST instead. This will result in localized differences in the test results. (cf. http://www.postgresql.org/idocs/index.php?regress-evaluation.html ); - the join tests are failing slightly differently; I would suggest that this is because the ORDER BY is still not explicit enough, and for what ever reason under IRIX the undefined result row orderings are in a different order to every other platform... e.g. with this statement: SELECT '' AS xxx, J1_TBL.i, j, t, k FROM J1_TBL LEFT OUTER JOIN J2_TBL USING (i) ORDER BY i; xxx | i | j | t | k -+---+---+---+ | 0 | | zero | | 1 | 4 | one | -1 | 2 | 3 | two | 2 | 2 | 3 | two | 4 | 3 | 2 | three | -3 | 4 | 1 | four | | 5 | 0 | five | -5 | 5 | 0 | five | -5 | 6 | 6 | six | | 7 | 7 | seven | | 8 | 8 | eight | | | 0 | zero | | | | null | (13 rows) the order of the last two rows is not defined. The expected order according to the regression tests is: | | | null | | | 0 | zero | Ian Barwick [EMAIL PROTECTED] -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [HACKERS] Request for supported platforms
Robert Treat [EMAIL PROTECTED] wrote: I noticed that the supported platforms listed 7.2 for linux alpha but with yesterdays date. I figured it was just a typo, but thought I would try to compile myself just to be sure, but I received 4 failures: horology,geometry,opr_sanity, and misc This is on alpha running debian 3 linux uname -a = Linux usf-cf-alpha-linux-1 2.2.20 #2 Wed Mar 20 19:57:28 EST 2002 alpha unknown regression output can be seen at: http://phppgadmin.sourceforge.net/regression.diffs http://phppgadmin.sourceforge.net/regression.out my alpha history is spotty at best, perhaps someone else can help me interpret things. Robert Treat I think on Linux Alpha and Sparc alot has to do with the gcc compiler version. My system is handupgraded from Redhat 6.2, kernel 2.2.x to be using a much newer kernel (2.4.X-aaX). But it's been working flawlessly with almost any kernel from 2.2 up to where i am now, using postgresql from the 6.x days. What compiler version are you using? Is this Debian release a stable branch? Magnus ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [HACKERS] Request for supported platforms
On Tue, 2002-10-29 at 12:16, Magnus Naeslund(f) wrote: Robert Treat [EMAIL PROTECTED] wrote: I noticed that the supported platforms listed 7.2 for linux alpha but with yesterdays date. I figured it was just a typo, but thought I would try to compile myself just to be sure, but I received 4 failures: horology,geometry,opr_sanity, and misc This is on alpha running debian 3 linux uname -a = Linux usf-cf-alpha-linux-1 2.2.20 #2 Wed Mar 20 19:57:28 EST 2002 alpha unknown regression output can be seen at: http://phppgadmin.sourceforge.net/regression.diffs http://phppgadmin.sourceforge.net/regression.out my alpha history is spotty at best, perhaps someone else can help me interpret things. Robert Treat I think on Linux Alpha and Sparc alot has to do with the gcc compiler version. My system is handupgraded from Redhat 6.2, kernel 2.2.x to be using a much newer kernel (2.4.X-aaX). But it's been working flawlessly with almost any kernel from 2.2 up to where i am now, using postgresql from the 6.x days. What compiler version are you using? xzilla@usf-cf-alpha-linux-1:~/postgresql-7.3b3/src/test$ gcc --version 2.95.4 Is this Debian release a stable branch? hmm... I'm not an admin on the box, this is one of the boxes from the sourceforge compile farm. /proc/version reports this as Debian prerelease, and kernel version reports 2.2.20. Robert Treat ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [HACKERS] Request for supported platforms
I kept Dave and Jason's name on the report. Ports list updated: http://candle.pha.pa.us/main/writings/pgsql/sgml/supported-platforms.html --- Dave Page wrote: -Original Message- From: Jason Tishler [mailto:jason;tishler.net] Sent: 29 October 2002 14:48 To: Dave Page Cc: Bruce Momjian; PostgreSQL-development; Thomas Lockhart; Tom Lane; Pgsql-Cygwin Subject: Re: [HACKERS] Request for supported platforms I found a solution to the above which will hopefully find its way into the next Cygwin release: http://cygwin.com/ml/cygwin-patches/2002-q4/msg00042.html Yes, I'm seeing errors with this on my updated Cygwin very early in the build. I did think it was my hacked about installation, but I guess not! A quick and *dirty* fix for this problem is to temporarily delete the above two entries from your stdio.h file. Hi Jason, All regression tests pass with the above hack on: CYGWIN_NT-5.1 PC9 1.3.14(0.62/3/2) 2002-10-24 10:48 i686 unknown Hackers: As the Cygwin release that is actively supported is the binary distribution that Jason builds, I would think this is OK to be listed as supported if no-one disagrees... Regards, Dave. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
Re: [HACKERS] Request for supported platforms
On Tuesday 29 October 2002 01:56, Bruce Momjian wrote: Sorry, Ian, here is the patch I applied. You can apply this to whatever version you are using and test Irix with that, rather than having to grab CVS. OK, I have carried out make check with the updated tests but got FAILED on the same four tests (abstime, tinterval, horology, join). The failures are subtly different (see here for new regression diff): http://home.akademie.de/~IBarwick/IRIX_65_1.regression.diffs Having looked at them again I see the following: - in horology the timestamp tests seem to have succeeded (presumably the previous failures were triggered by the change to winter time); - the tests which are still failing in abstime, tinterval and horology all refer to dates before 1970, where AFAICS they are all out by one hour; possibly this explanation?: Some systems using older time zone libraries fail to apply daylight-saving corrections to dates before 1970, causing pre-1970 PDT times to be displayed in PST instead. This will result in localized differences in the test results. (cf. http://www.postgresql.org/idocs/index.php?regress-evaluation.html ); - the join tests are failing slightly differently; I would suggest that this is because the ORDER BY is still not explicit enough, and for what ever reason under IRIX the undefined result row orderings are in a different order to every other platform... e.g. with this statement: SELECT '' AS xxx, J1_TBL.i, j, t, k FROM J1_TBL LEFT OUTER JOIN J2_TBL USING (i) ORDER BY i; xxx | i | j | t | k -+---+---+---+ | 0 | | zero | | 1 | 4 | one | -1 | 2 | 3 | two | 2 | 2 | 3 | two | 4 | 3 | 2 | three | -3 | 4 | 1 | four | | 5 | 0 | five | -5 | 5 | 0 | five | -5 | 6 | 6 | six | | 7 | 7 | seven | | 8 | 8 | eight | | | 0 | zero | | | | null | (13 rows) the order of the last two rows is not defined. The expected order according to the regression tests is: | | | null | | | 0 | zero | Ian Barwick [EMAIL PROTECTED] ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
Re: [HACKERS] Request for supported platforms
-Original Message- From: Bruce Momjian [mailto:pgman;candle.pha.pa.us] Sent: 29 October 2002 04:24 To: Dave Page Cc: PostgreSQL-development; Thomas Lockhart; Tom Lane Subject: Re: [HACKERS] Request for supported platforms I have updated CVS and re-added getopt.c, now in /port, and updated win32.mak. That should help. Thanks. Unfortunately not quite there though: print.c(1038) : warning C4013: 'pclose' undefined; assuming extern returning int describe.c tab-complete.c describe.c(1462) : warning C4761: integral size mismatch in argument; conversion supplied mbprint.c link.exe @.\nmc01556. print.obj : error LNK2001: unresolved external symbol _pclose .\Release\psql.exe : fatal error LNK1120: 1 unresolved externals NMAKE : fatal error U1077: 'link.exe' : return code '0x460' Stop. NMAKE : fatal error U1077: 'c:\Program Files\Microsoft Visual Studio\VC98\bin\nmake.exe' : return code '0x2' Stop. Any ideas? Regards, Dave. ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
Re: [HACKERS] Request for supported platforms
Bruce Momjian [EMAIL PROTECTED] writes: Strange. I just got report from another OSX 10.2.1 user saying regression tests passed: 10.2.1, Adam Witney ([EMAIL PROTECTED] The proper value seems to be: 15.3864610140472 or 15.3864610140473 in ./expected/geometry-powerpc-darwin.out. Which is it, folks? The existing geometry file is exactly correct on my laptop (Powerbook G3 using OSX 10.1). I am not sure whether the differences some users have reported are due to hardware or OS version differences. We need to figure that out and refine the resultmap, not just change the existing file. regards, tom lane ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [HACKERS] Request for supported platforms
Matthew, On Mon, Oct 28, 2002 at 10:50:40PM -0500, Matthew T. O'Connor wrote: Are you compiling from CVS or from a released tarball? CVS. The bison requirement was recently raised to bison 1.5 or above (1.75 was recently released also.) This is an issue only when compiling from CVS, since the bison stuff is preprocessed for released tarballs. So you might want to try the just release beta3. Thanks for the above, but see my recent, related posts (if interested). Jason ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
Re: [HACKERS] Request for supported platforms
I noticed that the supported platforms listed 7.2 for linux alpha but with yesterdays date. I figured it was just a typo, but thought I would try to compile myself just to be sure, but I received 4 failures: horology,geometry,opr_sanity, and misc This is on alpha running debian 3 linux uname -a = Linux usf-cf-alpha-linux-1 2.2.20 #2 Wed Mar 20 19:57:28 EST 2002 alpha unknown regression output can be seen at: http://phppgadmin.sourceforge.net/regression.diffs http://phppgadmin.sourceforge.net/regression.out my alpha history is spotty at best, perhaps someone else can help me interpret things. Robert Treat On Mon, 2002-10-28 at 22:41, Magnus Naeslund(f) wrote: Linux alpha. An Redhat 6.2, Linux gsX 2.4.19-pre6 #4 Thu Apr 11 07:17:39 CEST 2002 alpha unknown (ev56 ruffian). gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release) ./configure \ --prefix=/usr/local/pgsql-7.3b3 \ --with-maxbackends=512 \ --with-tcl \ --without-tk \ --with-perl\ --with-openssl \ --enable-odbc \ --with-CXX The box passes every tests except Horology. It's wintertime here aswell, as i read in some other report. It installs and runs nicely. Magnus ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED]) ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [HACKERS] Request for supported platforms
-Original Message- From: Jason Tishler [mailto:jason;tishler.net] Sent: 29 October 2002 14:48 To: Dave Page Cc: Bruce Momjian; PostgreSQL-development; Thomas Lockhart; Tom Lane; Pgsql-Cygwin Subject: Re: [HACKERS] Request for supported platforms I found a solution to the above which will hopefully find its way into the next Cygwin release: http://cygwin.com/ml/cygwin-patches/2002-q4/msg00042.html Yes, I'm seeing errors with this on my updated Cygwin very early in the build. I did think it was my hacked about installation, but I guess not! A quick and *dirty* fix for this problem is to temporarily delete the above two entries from your stdio.h file. Hi Jason, All regression tests pass with the above hack on: CYGWIN_NT-5.1 PC9 1.3.14(0.62/3/2) 2002-10-24 10:48 i686 unknown Hackers: As the Cygwin release that is actively supported is the binary distribution that Jason builds, I would think this is OK to be listed as supported if no-one disagrees... Regards, Dave. ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
Re: [HACKERS] Request for supported platforms
-Original Message- From: Jason Tishler [mailto:jason;tishler.net] Sent: 29 October 2002 18:58 To: Dave Page Cc: Bruce Momjian; PostgreSQL-development; Thomas Lockhart; Tom Lane; Pgsql-Cygwin Subject: Re: [HACKERS] Request for supported platforms Hackers: As the Cygwin release that is actively supported is the binary distribution that Jason builds, I would think this is OK to be listed as supported if no-one disagrees... Umm... Should I disagree? :,) Entirely up to you - you do the build :-). I'm just pointing out that the line wrt to Cygwin is generally use the standard package, so if we stick to that, as long as you build it OK, most people needn't worry 'bout hacking stdio.h. Regards, Dave. ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [HACKERS] Request for supported platforms
-Original Message- From: Bruce Momjian [mailto:pgman;candle.pha.pa.us] Sent: 29 October 2002 19:34 To: Dave Page Cc: PostgreSQL-development; Thomas Lockhart; Tom Lane Subject: Re: [HACKERS] Request for supported platforms Attached is a diff to fix the pclose problem. It turns out there was code in there to make popen/pclose be _popen/_pclose, but it was only in common.c, even in 7.2.3 (print.c). Not sure how it would compile in the past with that. Maybe it didn't. Anyway, this is committed and should _help_ with the compile. Thanks Bruce, builds fine now. Actually, I'm sure it did just a few weeks ago - We've been developing pgAdmin III in C++ using libpq on Windows, Linux and FreeBSD for a few weeks now and we've been using the CVS code. Regards, Dave ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [HACKERS] Request for supported platforms
Dave, On Tue, Oct 29, 2002 at 09:00:20PM -, Dave Page wrote: -Original Message- From: Jason Tishler [mailto:jason;tishler.net] Sent: 29 October 2002 18:58 Hackers: As the Cygwin release that is actively supported is the binary distribution that Jason builds, I would think this is OK to be listed as supported if no-one disagrees... ^ * Umm... Should I disagree? :,) Entirely up to you - you do the build :-). I was meekly trying to voice my concern about who supplies the support mentioned above. I'm just pointing out that the line wrt to Cygwin is generally use the standard package, so if we stick to that, as long as you build it OK, most people needn't worry 'bout hacking stdio.h. If my patch gets accepted, then the stdio.h hack won't be necessary for anyone (after the next Cygwin release). Jason ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
Re: [HACKERS] Request for supported platforms
Tom Lane wrote: Bruce Momjian writes: Folks. start sending in those plaform reports, OS name and version number please. I've checked CVS tip on: HPUX 10.20, using both gcc and vendor's cc PPC Linux Mac OS X 10.1 Here's the regression.diffs file from Mac OS X 10.2.1 (Jaguar). It failed geometry (rounding) and horology (not sure). gcc -v returns Apple Computer, Inc. GCC version 1161, based on gcc version 3.1 20020420 (prerelease). *** ./expected/geometry-powerpc-darwin.out Mon Dec 11 11:45:16 2000 --- ./results/geometry.out Sun Oct 27 21:27:11 2002 *** *** 127,133 | (-5,-12) | [(10,-10),(-3,-4)]| (-1.60487804878049,-4.64390243902439) | (10,10)| [(10,-10),(-3,-4)]| (2.39024390243902,-6.48780487804878) | (0,0) | [(-100,200),(30,-40)] | (0.0028402365895872,15.384614860264) ! | (-10,0)| [(-100,200),(30,-40)] | (-9.99715942258202,15.3864610140472) | (-3,4) | [(-100,200),(30,-40)] | (-2.99789812267519,15.3851688427303) | (5.1,34.5) | [(-100,200),(30,-40)] | (5.09647083221496,15.3836744976925) | (-5,-12) | [(-100,200),(30,-40)] | (-4.99494420845634,15.3855375281616) --- 127,133 | (-5,-12) | [(10,-10),(-3,-4)]| (-1.60487804878049,-4.64390243902439) | (10,10)| [(10,-10),(-3,-4)]| (2.39024390243902,-6.48780487804878) | (0,0) | [(-100,200),(30,-40)] | (0.0028402365895872,15.384614860264) ! | (-10,0)| [(-100,200),(30,-40)] | (-9.99715942258202,15.3864610140473) | (-3,4) | [(-100,200),(30,-40)] | (-2.99789812267519,15.3851688427303) | (5.1,34.5) | [(-100,200),(30,-40)] | (5.09647083221496,15.3836744976925) | (-5,-12) | [(-100,200),(30,-40)] | (-4.99494420845634,15.3855375281616) == *** ./expected/horology.out Wed Sep 18 17:35:25 2002 --- ./results/horology.out Sun Oct 27 21:27:12 2002 *** *** 537,549 SELECT (timestamp with time zone 'today' = (timestamp with time zone 'tomorrow' - interval '1 day')) as True; True -- ! t (1 row) SELECT (timestamp with time zone 'tomorrow' = (timestamp with time zone 'yesterday' + interval '2 days')) as True; True -- ! t (1 row) SELECT (timestamp with time zone 'tomorrow' 'now') as True; --- 537,549 SELECT (timestamp with time zone 'today' = (timestamp with time zone 'tomorrow' - interval '1 day')) as True; True -- ! f (1 row) SELECT (timestamp with time zone 'tomorrow' = (timestamp with time zone 'yesterday' + interval '2 days')) as True; True -- ! f (1 row) SELECT (timestamp with time zone 'tomorrow' 'now') as True; == -- Tara Piorkowski System Administrator, vilaj.com, LLC http://www.vilaj.com/ ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [HACKERS] Request for supported platforms
On Mon, Oct 28, 2002 at 05:32:04PM -0500, Andrew Sullivan wrote: Solaris 7, 2xUltraSPARC-II 400 MHz, 2.5 Gig, gcc 2.95.3; all tests pass. Solaris 8 forthcoming. I should have mentioned that this is for beta 3; I don't have the necessary bison installed to compile from CVS. Solaris 8, 2xUltraSPARC-II 400 MHz, 3G RAM, gcc 3.2 also passes. The details I'll put in the regression database. A -- Andrew Sullivan 204-4141 Yonge Street Liberty RMS Toronto, Ontario Canada [EMAIL PROTECTED] M2P 2A8 +1 416 646 3304 x110 ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
Re: [HACKERS] Request for supported platforms
-Original Message- From: Bruce Momjian [mailto:pgman;candle.pha.pa.us] Sent: 26 October 2002 03:17 To: PostgreSQL-development Cc: Thomas Lockhart; Tom Lane Subject: [HACKERS] Request for supported platforms Folks. start sending in those plaform reports, OS name and version number please. CYGWIN_NT-5.1 PC9 1.3.10(0.51/3/2) 2002-02-25 11:14 i686 unknown Make check failed with the normal spurious errors. Make installcheck also failed on horology, copy2 and domain - see attached output. The clocks changed here on Saturday night, so I guess that shouldn't have caused the first error (or should the docs be updated?). The second 2 errors are both with copys - related to the problem with the listen() backlog queue in the parallel test perhaps? Regards, Dave. regression.out Description: regressionout regression.diffs Description: regressiondiffs ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [HACKERS] Request for supported platforms
-Original Message- From: Bruce Momjian [mailto:pgman;candle.pha.pa.us] Sent: 26 October 2002 03:17 To: PostgreSQL-development Cc: Thomas Lockhart; Tom Lane Subject: [HACKERS] Request for supported platforms Folks. start sending in those plaform reports, OS name and version number please. Windows XP Professional SP1 Client build fails :-( Regards, Dave. C:\cygwin\usr\local\src\postgresql-7.3b3\srcnmake /f win32.mak Microsoft (R) Program Maintenance Utility Version 6.00.8168.0 Copyright (C) Microsoft Corp 1988-1998. All rights reserved. cd include if not exist pg_config.h copy pg_config.h.win32 pg_config.h 1 file(s) copied. cd .. cd interfaces\libpq nmake /f win32.mak Microsoft (R) Program Maintenance Utility Version 6.00.8168.0 Copyright (C) Microsoft Corp 1988-1998. All rights reserved. Building the Win32 static library... if not exist .\Release/ mkdir .\Release cl.exe C:\DOCUME~1\dpage\LOCALS~1\Temp\nma04188. dllist.c cl.exe C:\DOCUME~1\dpage\LOCALS~1\Temp\nmb04188. md5.c cl.exe C:\DOCUME~1\dpage\LOCALS~1\Temp\nmc04188. wchar.c cl.exe C:\DOCUME~1\dpage\LOCALS~1\Temp\nmd04188. encnames.c cl.exe C:\DOCUME~1\dpage\LOCALS~1\Temp\nme04188. win32.c fe-auth.c fe-connect.c fe-exec.c fe-lobj.c fe-misc.c fe-print.c fe-secure.c pqexpbuffer.c link.exe -lib C:\DOCUME~1\dpage\LOCALS~1\Temp\nmf04188. cl.exe C:\DOCUME~1\dpage\LOCALS~1\Temp\nmg04188. libpqdll.c rc.exe /l 0x409 /fo.\Release\libpq.res libpq.rc link.exe C:\DOCUME~1\dpage\LOCALS~1\Temp\nmh04188. Creating library .\Release\libpqdll.lib and object .\Release\libpqdll.exp cd ..\..\bin\psql nmake /f win32.mak Microsoft (R) Program Maintenance Utility Version 6.00.8168.0 Copyright (C) Microsoft Corp 1988-1998. All rights reserved. if not exist .\Release/ mkdir .\Release NMAKE : fatal error U1073: don't know how to make '..\..\utils\getopt.c' Stop. NMAKE : fatal error U1077: 'C:\Program Files\Microsoft Visual Studio\VC98\bin\N MAKE.EXE' : return code '0x2' Stop. C:\cygwin\usr\local\src\postgresql-7.3b3\src ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [HACKERS] Request for supported platforms
Dave, Thanks for the heads up... On Mon, Oct 28, 2002 at 10:31:00AM -, Dave Page wrote: -Original Message- From: Bruce Momjian [mailto:pgman;candle.pha.pa.us] Sent: 26 October 2002 03:17 Subject: [HACKERS] Request for supported platforms Folks. start sending in those plaform reports, OS name and version number please. CYGWIN_NT-5.1 PC9 1.3.10(0.51/3/2) 2002-02-25 11:14 i686 unknown ^^ Please try with Cygwin 1.3.14-1 while I attempt to deal with at least the following Cygwin build issues with PostgreSQL CVS as of today at about 7:00 AM EST: 1. pg_config.h.in HAVE_FSEEKO ifdef: make[4]: Entering directory `/home/jt/src/pgsql/src/backend/access/common' gcc -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -I../../../../src/include -DBUILDING_DLL -c -o heaptuple.o heaptuple.c In file included from ../../../../src/include/c.h:56, from ../../../../src/include/postgres.h:48, from heaptuple.c:21: /usr/include/stdio.h:207: parse error before `(' 2. Cygwin bison limit exceeded: make[4]: Entering directory `/home/jt/src/pgsql/src/interfaces/ecpg/preproc' [snip] bison -y -d preproc.y preproc.y:5560: fatal error: maximum table size (32767) exceeded Make check failed with the normal spurious errors. I would stick with make installcheck due to the Cygwin (i.e., Windows) backlog issue. Make installcheck also failed on horology, copy2 and domain - see attached output. The clocks changed here on Saturday night, so I guess that shouldn't have caused the first error (or should the docs be updated?). The second 2 errors are both with copys - related to the problem with the listen() backlog queue in the parallel test perhaps? I haven't looked into the above yet due to the build problems. Any help regarding these issues is gratefully appreciated. Thanks, Jason ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
Re: [HACKERS] Request for supported platforms
I thought the join was part of the timezone change, but I see now that it is separate. I will fix it by adding ORDER BY. --- Neil Conway wrote: Bruce Momjian [EMAIL PROTECTED] writes: Ports list updated: Shouldn't the join regression test failure be fixed? Cheers, Neil -- Neil Conway [EMAIL PROTECTED] || PGP Key ID: DB3C29FC ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
Re: [HACKERS] Request for supported platforms
-Original Message- From: Jason Tishler [mailto:jason;tishler.net] Sent: 28 October 2002 13:33 To: Dave Page Cc: Bruce Momjian; PostgreSQL-development; Thomas Lockhart; Tom Lane; Pgsql-Cygwin Subject: Re: [HACKERS] Request for supported platforms Dave, Thanks for the heads up... On Mon, Oct 28, 2002 at 10:31:00AM -, Dave Page wrote: -Original Message- From: Bruce Momjian [mailto:pgman;candle.pha.pa.us] Sent: 26 October 2002 03:17 Subject: [HACKERS] Request for supported platforms Folks. start sending in those plaform reports, OS name and version number please. CYGWIN_NT-5.1 PC9 1.3.10(0.51/3/2) 2002-02-25 11:14 i686 unknown ^^ Please try with Cygwin 1.3.14-1 while I attempt to deal with at least the following Cygwin build issues with PostgreSQL CVS as of today at about 7:00 AM EST: Ok, but this is going to take a while as few of the mirrors seem to have this release yet. I also need to download a new set of everything for reasons I won't go into. Is there actually a reason for this though or are you just trying to keep me busy? :-) It can't be a good thing for us to require that people upgrade to the latest release of their OS. 2. Cygwin bison limit exceeded: make[4]: Entering directory `/home/jt/src/pgsql/src/interfaces/ecpg/preproc' [snip] bison -y -d preproc.y preproc.y:5560: fatal error: maximum table size (32767) exceeded I believe a new bison is required now. Don't know much about it other than ecpg hit some limit or other and much discussion followed. Iirc, it's only an issue when compiling from CVS, not a tarball. Regards, Dave. ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
Re: [HACKERS] Request for supported platforms
Make installcheck also failed on horology, copy2 and domain - see attached output. The clocks changed here on Saturday night, so I guess that shouldn't have caused the first error (or should the docs be updated?). Horology failures are normal for a day or so on either side of a DST change --- see the regression tests interpretation docs. I have no time right now to examine the other diffs. regards, tom lane ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [HACKERS] Request for supported platforms
-Original Message- From: Tom Lane [mailto:tgl;sss.pgh.pa.us] Sent: 28 October 2002 15:53 To: Jason Tishler Cc: Dave Page; Bruce Momjian; PostgreSQL-development; Thomas Lockhart; Pgsql-Cygwin Subject: Re: [HACKERS] Request for supported platforms Make installcheck also failed on horology, copy2 and domain - see attached output. The clocks changed here on Saturday night, so I guess that shouldn't have caused the first error (or should the docs be updated?). Horology failures are normal for a day or so on either side of a DST change --- see the regression tests interpretation docs. I have no time right now to examine the other diffs. The docs say: Some of the queries in the timestamp test will fail if you run the test on the day of a daylight-savings time changeover, or the day before or after one. Clocks changed at midnight Saturday so I figured a Monday morning run should be OK. Do they actually change on Sunday at 00:00:00 I wonder? I'll try again tomorrow. Regards, Dave. ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
Re: [HACKERS] Request for supported platforms
Dave, On Mon, Oct 28, 2002 at 02:56:01PM -, Dave Page wrote: -Original Message- From: Jason Tishler [mailto:jason;tishler.net] Sent: 28 October 2002 13:33 Subject: Re: [HACKERS] Request for supported platforms Please try with Cygwin 1.3.14-1 while I attempt to deal with at least the following Cygwin build issues with PostgreSQL CVS as of today at about 7:00 AM EST: Ok, but this is going to take a while as few of the mirrors seem to have this release yet. I also need to download a new set of everything for reasons I won't go into. My WAG is that you will be able to upgrade your Cygwin installation before I fix the Cygwin build issues. :,) Is there actually a reason for this though or are you just trying to keep me busy? :-) It can't be a good thing for us to require that people upgrade to the latest release of their OS. Agreed, but sometimes a new Cygwin release fixes some problems and breaks others... 2. Cygwin bison limit exceeded: make[4]: Entering directory `/home/jt/src/pgsql/src/interfaces/ecpg/preproc' [snip] bison -y -d preproc.y preproc.y:5560: fatal error: maximum table size (32767) exceeded I believe a new bison is required now. Don't know much about it other than ecpg hit some limit or other and much discussion followed. Iirc, it's only an issue when compiling from CVS, not a tarball. The above should help save me some time. Thanks, Jason ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [HACKERS] Request for supported platforms
On Mon, 2002-10-28 at 10:20, Jason Tishler wrote: 2. Cygwin bison limit exceeded: make[4]: Entering directory `/home/jt/src/pgsql/src/interfaces/ecpg/preproc' [snip] bison -y -d preproc.y preproc.y:5560: fatal error: maximum table size (32767) exceeded I believe a new bison is required now. Don't know much about it other than ecpg hit some limit or other and much discussion followed. Iirc, it's only an issue when compiling from CVS, not a tarball. The above should help save me some time. 1.50 of Bison fixed the issue, 1.75 works as well (current public release). Just my $.02. Thanks, Jason ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812 E-Mail: [EMAIL PROTECTED] US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749 ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
Re: [HACKERS] Request for supported platforms
Dave Page [EMAIL PROTECTED] writes: Horology failures are normal for a day or so on either side of a DST change --- see the regression tests interpretation docs. I have no time right now to examine the other diffs. The docs say: Some of the queries in the timestamp test will fail if you run the test on the day of a daylight-savings time changeover, or the day before or after one. Clocks changed at midnight Saturday so I figured a Monday morning run should be OK. Do they actually change on Sunday at 00:00:00 I wonder? I'll try again tomorrow. In the US, DST changes occur at 02:00 Sunday, so the affected queries actually fail starting at 00:00 Sunday and ending 00:00 Tuesday --- but that's local time in PST8PDT. The docs are vague because your local time might vary considerably from that ... regards, tom lane ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
Re: [HACKERS] Request for supported platforms
Dave, On Mon, Oct 28, 2002 at 11:20:16AM -0500, Jason Tishler wrote: On Mon, Oct 28, 2002 at 02:56:01PM -, Dave Page wrote: Ok, but this is going to take a while as few of the mirrors seem to have this release yet. I also need to download a new set of everything for reasons I won't go into. My WAG is that you will be able to upgrade your Cygwin installation before I fix the Cygwin build issues. :,) I guess my WAG was wrong... :,) Under the following platform: $ uname -a CYGWIN_NT-5.0 TISHLERJASON 1.3.14(0.62/3/2) 2002-10-23 14:47 i686 unknown all make installcheck tests pass except for horology. However, the horology failure is to be expected due to the recent time change. Unfortunately, there are some Cygwin build issues that I need to address: 1. Cygwin bison needs to be upgraded from 1.35 to 1.75 (i.e., 1.50+) to process src/interfaces/ecpg/preproc/preproc.y successfully. I will post to the Cygwin mailing list asking the maintainer for this upgrade. 2. The following fseeko/ftello ifdef in src/include/pg_config.h.in: #ifndef HAVE_FSEEKO #define fseeko(a, b, c) fseek((a), (b), (c)) #define ftello(a) ftell((a)) #endif conflicts with the following Cygwin /usr/include/stdio.h entries: int _EXFUN(fseeko, (FILE *, off_t, int)); off_t _EXFUN(ftello, ( FILE *)); Unfortunately, I'm not sure what is the best way to solve this one yet. Any suggestions would be appreciated. Thanks, Jason ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
Re: [HACKERS] Request for supported platforms
-Original Message- From: Jason Tishler [mailto:jason;tishler.net] Sent: 28 October 2002 20:42 To: Dave Page Cc: Bruce Momjian; PostgreSQL-development; Thomas Lockhart; Tom Lane; Pgsql-Cygwin Subject: Re: [HACKERS] Request for supported platforms Dave, On Mon, Oct 28, 2002 at 11:20:16AM -0500, Jason Tishler wrote: My WAG is that you will be able to upgrade your Cygwin installation before I fix the Cygwin build issues. :,) I guess my WAG was wrong... :,) I've been meaning to ask this for a while - what exactly is a WAG? :-) 1. Cygwin bison needs to be upgraded from 1.35 to 1.75 (i.e., 1.50+) to process src/interfaces/ecpg/preproc/preproc.y successfully. I will post to the Cygwin mailing list asking the maintainer for this upgrade. OK. This shouldn't stop a release though I assume, only a build from CVS. 2. The following fseeko/ftello ifdef in src/include/pg_config.h.in: #ifndef HAVE_FSEEKO #define fseeko(a, b, c) fseek((a), (b), (c)) #define ftello(a) ftell((a)) #endif conflicts with the following Cygwin /usr/include/stdio.h entries: int _EXFUN(fseeko, (FILE *, off_t, int)); off_t _EXFUN(ftello, ( FILE *)); Unfortunately, I'm not sure what is the best way to solve this one yet. Any suggestions would be appreciated. Yes, I'm seeing errors with this on my updated Cygwin very early in the build. I did think it was my hacked about installation, but I guess not! Unfortunately though, I don't know the answer either, but I guess the change was in Cygwin as I didn't see it before you asked me to upgrade. Regards, Dave. ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [HACKERS] Request for supported platforms
On Mon, 2002-10-28 at 14:58, Dave Page wrote: My WAG is that you will be able to upgrade your Cygwin installation before I fix the Cygwin build issues. :,) I guess my WAG was wrong... :,) I've been meaning to ask this for a while - what exactly is a WAG? :-) Wild-A**ed-Guess, I would presume. -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812 E-Mail: [EMAIL PROTECTED] US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749 ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [HACKERS] Request for supported platforms
On Fri, Oct 25, 2002 at 10:17:22PM -0400, Bruce Momjian wrote: OK, Tom will be away next week, and Thomas will too. I can do it. Folks. start sending in those plaform reports, OS name and version number please. Solaris 7, 2xUltraSPARC-II 400 MHz, 2.5 Gig, gcc 2.95.3; all tests pass. Solaris 8 forthcoming. A -- Andrew Sullivan 204-4141 Yonge Street Liberty RMS Toronto, Ontario Canada [EMAIL PROTECTED] M2P 2A8 +1 416 646 3304 x110 ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [HACKERS] Request for supported platforms
Neil Conway wrote: Bruce Momjian [EMAIL PROTECTED] writes: Ports list updated: Shouldn't the join regression test failure be fixed? OK, I have updated the join regression test to add ORDER BY in the queries Irix differed. Ian, would you retest the CVS version of PostgreSQL to see if all the regression tests pass now? -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [HACKERS] Request for supported platforms
On Tuesday 29 October 2002 00:08, Bruce Momjian wrote: Neil Conway wrote: Bruce Momjian [EMAIL PROTECTED] writes: Ports list updated: Shouldn't the join regression test failure be fixed? OK, I have updated the join regression test to add ORDER BY in the queries Irix differed. Ian, would you retest the CVS version of PostgreSQL to see if all the regression tests pass now? For confirmation: IIRC CVS now requires the latest Bison (1.75)? (The Irix machine has 1.35). Ian Barwick [EMAIL PROTECTED] ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
Re: [HACKERS] Request for supported platforms
Sorry, Ian, here is the patch I applied. You can apply this to whatever version you are using and test Irix with that, rather than having to grab CVS. --- Neil Conway wrote: Bruce Momjian [EMAIL PROTECTED] writes: Ports list updated: Shouldn't the join regression test failure be fixed? Cheers, Neil -- Neil Conway [EMAIL PROTECTED] || PGP Key ID: DB3C29FC ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ? config.log ? GNUmakefile ? config.status ? autom4te.cache ? configure.lineno ? contrib/retep/build ? contrib/retep/jars ? src/log ? src/Makefile.custom ? src/Makefile.global ? src/backend/postgres ? src/backend/catalog/postgres.bki ? src/backend/catalog/postgres.description ? src/backend/utils/mb/conversion_procs/conversion_create.sql ? src/backend/utils/mb/conversion_procs/ascii_and_mic/libascii_and_mic.so.0.0 ? src/backend/utils/mb/conversion_procs/cyrillic_and_mic/libcyrillic_and_mic.so.0.0 ? src/backend/utils/mb/conversion_procs/euc_cn_and_mic/libeuc_cn_and_mic.so.0.0 ? src/backend/utils/mb/conversion_procs/euc_jp_and_sjis/libeuc_jp_and_sjis.so.0.0 ? src/backend/utils/mb/conversion_procs/euc_kr_and_mic/libeuc_kr_and_mic.so.0.0 ? src/backend/utils/mb/conversion_procs/euc_tw_and_big5/libeuc_tw_and_big5.so.0.0 ? src/backend/utils/mb/conversion_procs/latin2_and_win1250/liblatin2_and_win1250.so.0.0 ? src/backend/utils/mb/conversion_procs/latin_and_mic/liblatin_and_mic.so.0.0 ? src/backend/utils/mb/conversion_procs/utf8_and_ascii/libutf8_and_ascii.so.0.0 ? src/backend/utils/mb/conversion_procs/utf8_and_big5/libutf8_and_big5.so.0.0 ? src/backend/utils/mb/conversion_procs/utf8_and_cyrillic/libutf8_and_cyrillic.so.0.0 ? src/backend/utils/mb/conversion_procs/utf8_and_euc_cn/libutf8_and_euc_cn.so.0.0 ? src/backend/utils/mb/conversion_procs/utf8_and_euc_jp/libutf8_and_euc_jp.so.0.0 ? src/backend/utils/mb/conversion_procs/utf8_and_euc_kr/libutf8_and_euc_kr.so.0.0 ? src/backend/utils/mb/conversion_procs/utf8_and_euc_tw/libutf8_and_euc_tw.so.0.0 ? src/backend/utils/mb/conversion_procs/utf8_and_gb18030/libutf8_and_gb18030.so.0.0 ? src/backend/utils/mb/conversion_procs/utf8_and_gbk/libutf8_and_gbk.so.0.0 ? src/backend/utils/mb/conversion_procs/utf8_and_iso8859/libutf8_and_iso8859.so.0.0 ? src/backend/utils/mb/conversion_procs/utf8_and_iso8859_1/libutf8_and_iso8859_1.so.0.0 ? src/backend/utils/mb/conversion_procs/utf8_and_johab/libutf8_and_johab.so.0.0 ? src/backend/utils/mb/conversion_procs/utf8_and_sjis/libutf8_and_sjis.so.0.0 ? src/backend/utils/mb/conversion_procs/utf8_and_tcvn/libutf8_and_tcvn.so.0.0 ? src/backend/utils/mb/conversion_procs/utf8_and_uhc/libutf8_and_uhc.so.0.0 ? src/backend/utils/mb/conversion_procs/utf8_and_win1250/libutf8_and_win1250.so.0.0 ? src/backend/utils/mb/conversion_procs/utf8_and_win1256/libutf8_and_win1256.so.0.0 ? src/backend/utils/mb/conversion_procs/utf8_and_win874/libutf8_and_win874.so.0.0 ? src/bin/initdb/initdb ? src/bin/initlocation/initlocation ? src/bin/ipcclean/ipcclean ? src/bin/pg_config/pg_config ? src/bin/pg_controldata/pg_controldata ? src/bin/pg_ctl/pg_ctl ? src/bin/pg_dump/pg_dump ? src/bin/pg_dump/pg_restore ? src/bin/pg_dump/pg_dumpall ? src/bin/pg_encoding/pg_encoding ? src/bin/pg_id/pg_id ? src/bin/pg_resetxlog/pg_resetxlog ? src/bin/psql/psql ? src/bin/psql/i ? src/bin/scripts/createlang ? src/include/pg_config.h ? src/include/stamp-h ? src/interfaces/ecpg/lib/libecpg.so.3.4.0 ? src/interfaces/ecpg/preproc/ecpg ? src/interfaces/jdbc/build ? src/interfaces/jdbc/jars ? src/interfaces/libpq/libpq.so.2.2 ? src/pl/plpgsql/src/libplpgsql.so.1.0 ? src/test/regress/pg_regress ? src/test/regress/results ? src/test/regress/regression.out ? src/test/regress/regression.diffs ? src/test/regress/expected/copy.out ? src/test/regress/expected/create_function_1.out ? src/test/regress/expected/create_function_2.out ? src/test/regress/expected/misc.out ? src/test/regress/expected/constraints.out ? src/test/regress/sql/copy.sql ? src/test/regress/sql/create_function_1.sql ? src/test/regress/sql/create_function_2.sql ? src/test/regress/sql/misc.sql ? src/test/regress/sql/constraints.sql Index: src/test/regress/expected/join.out === RCS file: /cvsroot/pgsql-server/src/test/regress/expected/join.out,v retrieving revision 1.11 retrieving revision 1.12 diff -c -c -r1.11 -r1.12 *** src/test/regress/expected/join.out 28 Apr 2002 19:54:29 - 1.11 --- src/test/regress/expected/join.out 28 Oct 2002 22:54:45 - 1.12 *** ***
Re: [HACKERS] Request for supported platforms
Ports list updated: http://candle.pha.pa.us/main/writings/pgsql/sgml/supported-platforms.html --- Andrew Sullivan wrote: On Fri, Oct 25, 2002 at 10:17:22PM -0400, Bruce Momjian wrote: OK, Tom will be away next week, and Thomas will too. I can do it. Folks. start sending in those plaform reports, OS name and version number please. Solaris 7, 2xUltraSPARC-II 400 MHz, 2.5 Gig, gcc 2.95.3; all tests pass. Solaris 8 forthcoming. A -- Andrew Sullivan 204-4141 Yonge Street Liberty RMS Toronto, Ontario Canada [EMAIL PROTECTED] M2P 2A8 +1 416 646 3304 x110 ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [HACKERS] Request for supported platforms
Ports list updated: http://candle.pha.pa.us/main/writings/pgsql/sgml/supported-platforms.html --- Andrew Sullivan wrote: On Mon, Oct 28, 2002 at 05:32:04PM -0500, Andrew Sullivan wrote: Solaris 7, 2xUltraSPARC-II 400 MHz, 2.5 Gig, gcc 2.95.3; all tests pass. Solaris 8 forthcoming. I should have mentioned that this is for beta 3; I don't have the necessary bison installed to compile from CVS. Solaris 8, 2xUltraSPARC-II 400 MHz, 3G RAM, gcc 3.2 also passes. The details I'll put in the regression database. A -- Andrew Sullivan 204-4141 Yonge Street Liberty RMS Toronto, Ontario Canada [EMAIL PROTECTED] M2P 2A8 +1 416 646 3304 x110 ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
Re: [HACKERS] Request for supported platforms
Linux alpha. An Redhat 6.2, Linux gsX 2.4.19-pre6 #4 Thu Apr 11 07:17:39 CEST 2002 alpha unknown (ev56 ruffian). gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release) ./configure \ --prefix=/usr/local/pgsql-7.3b3 \ --with-maxbackends=512 \ --with-tcl \ --without-tk \ --with-perl\ --with-openssl \ --enable-odbc \ --with-CXX The box passes every tests except Horology. It's wintertime here aswell, as i read in some other report. It installs and runs nicely. Magnus ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
Re: [HACKERS] Request for supported platforms
Ports list updated: http://candle.pha.pa.us/main/writings/pgsql/sgml/supported-platforms.html --- Magnus Naeslund(f) wrote: Linux alpha. An Redhat 6.2, Linux gsX 2.4.19-pre6 #4 Thu Apr 11 07:17:39 CEST 2002 alpha unknown (ev56 ruffian). gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release) ./configure \ --prefix=/usr/local/pgsql-7.3b3 \ --with-maxbackends=512 \ --with-tcl \ --without-tk \ --with-perl\ --with-openssl \ --enable-odbc \ --with-CXX The box passes every tests except Horology. It's wintertime here aswell, as i read in some other report. It installs and runs nicely. Magnus -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [HACKERS] Request for supported platforms
Are you compiling from CVS or from a released tarball? The bison requirement was recently raised to bison 1.5 or above (1.75 was recently released also.) This is an issue only when compiling from CVS, since the bison stuff is preprocessed for released tarballs. So you might want to try the just release beta3. On Mon, 2002-10-28 at 08:32, Jason Tishler wrote: Dave, Thanks for the heads up... On Mon, Oct 28, 2002 at 10:31:00AM -, Dave Page wrote: -Original Message- From: Bruce Momjian [mailto:pgman;candle.pha.pa.us] Sent: 26 October 2002 03:17 Subject: [HACKERS] Request for supported platforms Folks. start sending in those plaform reports, OS name and version number please. CYGWIN_NT-5.1 PC9 1.3.10(0.51/3/2) 2002-02-25 11:14 i686 unknown ^^ Please try with Cygwin 1.3.14-1 while I attempt to deal with at least the following Cygwin build issues with PostgreSQL CVS as of today at about 7:00 AM EST: 1. pg_config.h.in HAVE_FSEEKO ifdef: make[4]: Entering directory `/home/jt/src/pgsql/src/backend/access/common' gcc -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -I../../../../src/include -DBUILDING_DLL -c -o heaptuple.o heaptuple.c In file included from ../../../../src/include/c.h:56, from ../../../../src/include/postgres.h:48, from heaptuple.c:21: /usr/include/stdio.h:207: parse error before `(' 2. Cygwin bison limit exceeded: make[4]: Entering directory `/home/jt/src/pgsql/src/interfaces/ecpg/preproc' [snip] bison -y -d preproc.y preproc.y:5560: fatal error: maximum table size (32767) exceeded Make check failed with the normal spurious errors. I would stick with make installcheck due to the Cygwin (i.e., Windows) backlog issue. Make installcheck also failed on horology, copy2 and domain - see attached output. The clocks changed here on Saturday night, so I guess that shouldn't have caused the first error (or should the docs be updated?). The second 2 errors are both with copys - related to the problem with the listen() backlog queue in the parallel test perhaps? I haven't looked into the above yet due to the build problems. Any help regarding these issues is gratefully appreciated. Thanks, Jason ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
Re: [HACKERS] Request for supported platforms
I have updated CVS and re-added getopt.c, now in /port, and updated win32.mak. That should help. --- Dave Page wrote: -Original Message- From: Bruce Momjian [mailto:pgman;candle.pha.pa.us] Sent: 26 October 2002 03:17 To: PostgreSQL-development Cc: Thomas Lockhart; Tom Lane Subject: [HACKERS] Request for supported platforms Folks. start sending in those plaform reports, OS name and version number please. Windows XP Professional SP1 Client build fails :-( Regards, Dave. C:\cygwin\usr\local\src\postgresql-7.3b3\srcnmake /f win32.mak Microsoft (R) Program Maintenance Utility Version 6.00.8168.0 Copyright (C) Microsoft Corp 1988-1998. All rights reserved. cd include if not exist pg_config.h copy pg_config.h.win32 pg_config.h 1 file(s) copied. cd .. cd interfaces\libpq nmake /f win32.mak Microsoft (R) Program Maintenance Utility Version 6.00.8168.0 Copyright (C) Microsoft Corp 1988-1998. All rights reserved. Building the Win32 static library... if not exist .\Release/ mkdir .\Release cl.exe @C:\DOCUME~1\dpage\LOCALS~1\Temp\nma04188. dllist.c cl.exe @C:\DOCUME~1\dpage\LOCALS~1\Temp\nmb04188. md5.c cl.exe @C:\DOCUME~1\dpage\LOCALS~1\Temp\nmc04188. wchar.c cl.exe @C:\DOCUME~1\dpage\LOCALS~1\Temp\nmd04188. encnames.c cl.exe @C:\DOCUME~1\dpage\LOCALS~1\Temp\nme04188. win32.c fe-auth.c fe-connect.c fe-exec.c fe-lobj.c fe-misc.c fe-print.c fe-secure.c pqexpbuffer.c link.exe -lib @C:\DOCUME~1\dpage\LOCALS~1\Temp\nmf04188. cl.exe @C:\DOCUME~1\dpage\LOCALS~1\Temp\nmg04188. libpqdll.c rc.exe /l 0x409 /fo.\Release\libpq.res libpq.rc link.exe @C:\DOCUME~1\dpage\LOCALS~1\Temp\nmh04188. Creating library .\Release\libpqdll.lib and object .\Release\libpqdll.exp cd ..\..\bin\psql nmake /f win32.mak Microsoft (R) Program Maintenance Utility Version 6.00.8168.0 Copyright (C) Microsoft Corp 1988-1998. All rights reserved. if not exist .\Release/ mkdir .\Release NMAKE : fatal error U1073: don't know how to make '..\..\utils\getopt.c' Stop. NMAKE : fatal error U1077: 'C:\Program Files\Microsoft Visual Studio\VC98\bin\N MAKE.EXE' : return code '0x2' Stop. C:\cygwin\usr\local\src\postgresql-7.3b3\src -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
Re: [HACKERS] Request for supported platforms
On Saturday 26 October 2002 04:17, Bruce Momjian wrote: OK, Tom will be away next week, and Thomas will too. I can do it. Folks. start sending in those plaform reports, OS name and version number please. The current platform list is: http://developer.postgresql.org/docs/postgres/supported-platforms.html ianb uname -a IRIX64 Komma 6.5 07121148 IP27 ianb gcc -v Reading specs from /usr/local/lib/gcc-lib/mips-sgi-irix6.5/3.2/specs Configured with: ../configure --with-ld=/usr/bin/ld Thread model: single gcc version 3.2 Building 7.3b3; failed on four tests: abstime, tinterval, horology, join The first three are I presume due to the change to winter time (CET) earlier today (27.10), see http://www.postgresql.org/idocs/index.php?regress-evaluation.html#AEN18382 ; the join failure is a row ordering difference. Should it be of any use the regression.diffs file is here: http://home.akademie.de/~IBarwick/IRIX_65_regression.diffs Otherwise no apparent problems and the server started fine. Ian Barwick [EMAIL PROTECTED] ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [HACKERS] Request for supported platforms
Ports list updated: http://candle.pha.pa.us/main/writings/pgsql/sgml/supported-platforms.html --- Ian Barwick wrote: On Saturday 26 October 2002 04:17, Bruce Momjian wrote: OK, Tom will be away next week, and Thomas will too. I can do it. Folks. start sending in those plaform reports, OS name and version number please. The current platform list is: http://developer.postgresql.org/docs/postgres/supported-platforms.html ianb uname -a IRIX64 Komma 6.5 07121148 IP27 ianb gcc -v Reading specs from /usr/local/lib/gcc-lib/mips-sgi-irix6.5/3.2/specs Configured with: ../configure --with-ld=/usr/bin/ld Thread model: single gcc version 3.2 Building 7.3b3; failed on four tests: abstime, tinterval, horology, join The first three are I presume due to the change to winter time (CET) earlier today (27.10), see http://www.postgresql.org/idocs/index.php?regress-evaluation.html#AEN18382 ; the join failure is a row ordering difference. Should it be of any use the regression.diffs file is here: http://home.akademie.de/~IBarwick/IRIX_65_regression.diffs Otherwise no apparent problems and the server started fine. Ian Barwick [EMAIL PROTECTED] ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED] -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [HACKERS] Request for supported platforms
Bruce Momjian [EMAIL PROTECTED] writes: Ports list updated: Shouldn't the join regression test failure be fixed? Cheers, Neil -- Neil Conway [EMAIL PROTECTED] || PGP Key ID: DB3C29FC ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
Re: [HACKERS] Request for supported platforms
On an rh6.2, Linux gsX 2.4.19-pre6 #4 Thu Apr 11 07:17:39 CEST 2002 alpha unknown (ev56 ruffian) i get this failure. Should ./configure options gmake gmake check be the only things i need to do? == creating database regression == /home/mag/d/postgresql/postgresql-7.3b3/src/test/regress/./tmp_check/ins tall//usr/local/pgsql/bin/pg_encoding: error in loading shared libraries: /home/mag/d/postgresql/postgresql-7.3b3/src/test/regress/./tmp_check/ins tall//usr/local/pgsql/bin/pg_encoding: undefined symbol: pg_char_to_encoding createdb: SQL_ASCII is not a valid encoding name pg_regress: createdb failed gmake[2]: *** [check] Error 2 gmake[2]: Leaving directory `/home/mag/d/postgresql/postgresql-7.3b3/src/test/regress' gmake[1]: *** [check] Error 2 gmake[1]: Leaving directory `/home/mag/d/postgresql/postgresql-7.3b3/src/test' gmake: *** [check] Error 2 Magnus ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [HACKERS] Request for supported platforms
Updated: http://candle.pha.pa.us/main/writings/pgsql/sgml/supported-platforms.html --- Tom Lane wrote: Bruce Momjian [EMAIL PROTECTED] writes: Folks. start sending in those plaform reports, OS name and version number please. I've checked CVS tip on: HPUX 10.20, using both gcc and vendor's cc PPC Linux Mac OS X 10.1 regards, tom lane ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED] -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
Re: [HACKERS] Request for supported platforms
Updated: http://candle.pha.pa.us/main/writings/pgsql/sgml/supported-platforms.html --- Doug McNaught wrote: Doug McNaught [EMAIL PROTECTED] writes: OK, compile went fine, but I get multiple regression test failures: test geometry ... FAILED After realizing that my disk had filled up (thanks Alvaro) I reran the tests and 'geometry' is the only failure. I'm guessing this is due to floating-point differences? If this is OK, then Linux/Sparc (Debian 3.0) is a PASS. -Doug -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
Re: [HACKERS] Request for supported platforms
On Sat, Oct 26, 2002 at 04:01:17PM -0400, Bruce Momjian wrote: Updated: http://candle.pha.pa.us/main/writings/pgsql/sgml/supported-platforms.html Linux 2.4 on IA32 passes also. -- Alvaro Herrera (alvherre[a]dcc.uchile.cl) La felicidad no es maƱana. La felicidad es ahora ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
Re: [HACKERS] Request for supported platforms
Ports list updated: http://candle.pha.pa.us/main/writings/pgsql/sgml/supported-platforms.html --- Alvaro Herrera wrote: On Sat, Oct 26, 2002 at 04:01:17PM -0400, Bruce Momjian wrote: Updated: http://candle.pha.pa.us/main/writings/pgsql/sgml/supported-platforms.html Linux 2.4 on IA32 passes also. -- Alvaro Herrera (alvherre[a]dcc.uchile.cl) La felicidad no es ma?ana. La felicidad es ahora -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
Re: [HACKERS] Request for supported platforms
Tom Lane [EMAIL PROTECTED] writes: Bruce Momjian [EMAIL PROTECTED] writes: Folks. start sending in those plaform reports, OS name and version number please. I've checked CVS tip on: HPUX 10.20, using both gcc and vendor's cc PPC Linux Mac OS X 10.1 I get the following on Linux/Sparc, Debian 3.0: make[3]: Entering directory `/home/doug/src/pgsql/src/backend/utils/mb/conversion_procs/ascii_and_mic' gcc -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fpic -I../../../../../../src/include -c -o ascii_and_mic.o ascii_and_mic.c ascii_and_mic.c:19: syntax error before `extern' ascii_and_mic.c:21: syntax error before `extern' make[3]: *** [ascii_and_mic.o] Error 1 make[3]: Leaving directory `/home/doug/src/pgsql/src/backend/utils/mb/conversion_procs/ascii_and_mic' make[2]: *** [all] Error 2 make[2]: Leaving directory `/home/doug/src/pgsql/src/backend/utils/mb/conversion_procs' make[1]: *** [all] Error 2 make[1]: Leaving directory `/home/doug/src/pgsql/src' make: *** [all] Error 2 My gcc version: doug@varsoon:~/src/pgsql$ gcc -v Reading specs from /usr/lib/gcc-lib/sparc-linux/2.95.4/specs gcc version 2.95.4 20011002 (Debian prerelease) This is CVS tip as of about 11:30 EST Saturday. Looking into it, we have in ascii_and_mic.c: PG_FUNCTION_INFO_V1(ascii_to_mic) PG_FUNCTION_INFO_V1(mic_to_ascii) Putting a semicolon after each such line fixes that compile, but there are other files under conversion_procs with the same problem. Is my gcc not expanding the macro properly? -Doug ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
Re: [HACKERS] Request for supported platforms
Doug McNaught [EMAIL PROTECTED] writes: make[3]: Entering directory `/home/doug/src/pgsql/src/backend/utils/mb/conversion_procs/ascii_and_mic' gcc -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fpic -I../../../../../../src/include -c -o ascii_and_mic.o ascii_and_mic.c ascii_and_mic.c:19: syntax error before `extern' ascii_and_mic.c:21: syntax error before `extern' That should be fixed as of now. regards, tom lane ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
Re: [HACKERS] Request for supported platforms
Tom Lane [EMAIL PROTECTED] writes: Doug McNaught [EMAIL PROTECTED] writes: make[3]: Entering directory `/home/doug/src/pgsql/src/backend/utils/mb/conversion_procs/ascii_and_mic' gcc -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fpic -I../../../../../../src/include -c -o ascii_and_mic.o ascii_and_mic.c ascii_and_mic.c:19: syntax error before `extern' ascii_and_mic.c:21: syntax error before `extern' That should be fixed as of now. OK, compile went fine, but I get multiple regression test failures: test geometry ... FAILED select_views ... FAILED foreign_key ... FAILED limit... FAILED plpgsql ... FAILED copy2... FAILED temp ... FAILED domain ... FAILED rangefuncs ... FAILED prepare ... FAILED without_oid ... FAILED conversion ... FAILED truncate ... FAILED alter_table ... FAILED I have attached a gzipped copy of regression.diffs. Let me know if I can supply any other help. -Doug regression.diffs.gz Description: regression diffs ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [HACKERS] Request for supported platforms
Bruce Momjian [EMAIL PROTECTED] writes: Folks. start sending in those plaform reports, OS name and version number please. I've checked CVS tip on: HPUX 10.20, using both gcc and vendor's cc PPC Linux Mac OS X 10.1 regards, tom lane ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [HACKERS] Request for supported platforms
On 26 Oct 2002, Doug McNaught wrote: Tom Lane [EMAIL PROTECTED] writes: Doug McNaught [EMAIL PROTECTED] writes: make[3]: Entering directory `/home/doug/src/pgsql/src/backend/utils/mb/conversion_procs/ascii_and_mic' gcc -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fpic -I../../../../../../src/include -c -o ascii_and_mic.o ascii_and_mic.c ascii_and_mic.c:19: syntax error before `extern' ascii_and_mic.c:21: syntax error before `extern' That should be fixed as of now. OK, compile went fine, but I get multiple regression test failures: test geometry ... FAILED select_views ... FAILED foreign_key ... FAILED limit... FAILED plpgsql ... FAILED copy2... FAILED temp ... FAILED domain ... FAILED rangefuncs ... FAILED prepare ... FAILED without_oid ... FAILED conversion ... FAILED truncate ... FAILED alter_table ... FAILED I have attached a gzipped copy of regression.diffs. Let me know if I can supply any other help. The geometry one looked like rounding issues. Did you run out of space on where the data directory was mounted? At least some of the other errors were complaining about no space left on device. ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [HACKERS] Request for supported platforms
Doug McNaught [EMAIL PROTECTED] writes: OK, compile went fine, but I get multiple regression test failures: test geometry ... FAILED After realizing that my disk had filled up (thanks Alvaro) I reran the tests and 'geometry' is the only failure. I'm guessing this is due to floating-point differences? If this is OK, then Linux/Sparc (Debian 3.0) is a PASS. -Doug ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
[HACKERS] Request for supported platforms
Thomas Lockhart wrote: Seems like someone ought to issue a call for port reports. The supported platforms list hasn't been touched ... Good point. Thomas, can you take that on? No, at least not now. I'm not able to communicate reliably with the mailing lists, and so can not coordinate anything :( Not sure when or if that will be resolved, but I'll be out of town next week so... [ Reposted with proper subject line.] OK, Tom will be away next week, and Thomas will too. I can do it. Folks. start sending in those plaform reports, OS name and version number please. The current platform list is: http://developer.postgresql.org/docs/postgres/supported-platforms.html -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html