AW: AW: AW: [HACKERS] Re: RELEASE STOPPER? nonportable int64 constant s in pg_crc.c

2001-03-26 Thread Zeugswetter Andreas SB
> Mainly it's a schedule-driven thing. I don't want to take any risk that > a last-minute patch to work around AIX's broken compiler will break any > other platforms. If we had found this problem before beta cycle > started, I would be more willing to say "let's try it and find out > whether it

Re: [HACKERS] docs toolchain appears broke?

2001-03-26 Thread Larry Rosenman
* Ian Lance Taylor <[EMAIL PROTECTED]> [010326 01:14]: > Tom Lane <[EMAIL PROTECTED]> writes: > > > Larry Rosenman <[EMAIL PROTECTED]> writes: > > > gmake[1]: Leaving directory `/home/ler/pg-dev/pgsql/doc/src/sgml' > > > cd sgml && tar -cf ../programmer.tar --exclude=Makefile > > > --exclude='*.s

re : [HACKERS] Prob with regexp

2001-03-26 Thread pejac
Hi, There's no bug with regexp, because "*" operator in regex match zero or more times. So if you want match exactly your patern try ~ 'ibd01.*' . "." match an arbitrary character. Cheers, PEJAC Pascal ---(end of broadcast)--- TIP 5: Have you ch

Re: [HACKERS] Release Candidate 1 ...

2001-03-26 Thread Gordon A. Runkle
In article <[EMAIL PROTECTED]>, "Tom Lane" <[EMAIL PROTECTED]> wrote: > No, just compile and install. If you'd been on beta5 or earlier, you'd > need to run contrib/pg_resetxlog to update pg_control format, but still > no initdb. Thanks, Tom! Just so you know:  I've built a test database in Pos

[HACKERS] Dead locks

2001-03-26 Thread Rainer Mager
Hi all, We're using PG 7.0 and 7.1beta and are having dead lock problems. The docs say the Postgres detects dead locks and automatically rolls back 1 transaction to recover but this is not our experience. Are the docs incorrect or is this more serious? Thanks, --Rainer --

Re: [HACKERS] Dead locks

2001-03-26 Thread Tom Lane
"Rainer Mager" <[EMAIL PROTECTED]> writes: > We're using PG 7.0 and 7.1beta and are having dead lock problems. The docs > say the Postgres detects dead locks and automatically rolls back 1 > transaction to recover but this is not our experience. Are the docs > incorrect or is this more serious? W

[HACKERS] IANA registration

2001-03-26 Thread Pete Forman
PostgreSQL typically uses port 5432 for client-server communications. It would be a good idea to register this with IANA. This will help to avoid a clash with other services that might try to use the port. DB2, Interbase, MS SQL, MySQL, Oracle, Sybase, etc. are already registered. Might someone

Re: [HACKERS] Re: Call for platforms

2001-03-26 Thread Thomas Lockhart
> >> Suddenly I obtain access to > >> ULTRIX black 4.3 1 RISC > > Uh ... what kind of processor is that? Offhand I don't see any > > indication that any of the entries in s_lock.h are supposed to work > > for Ultrix. As mentioned earlier, Ultrix on RISC means that it is a MIPS processor. DEC imp

[HACKERS] Re: Call for platforms

2001-03-26 Thread Thomas Lockhart
The list of unreported or "in progress" platforms has gotten much shorter. If anyone can help on the remaining problems, we'll be able to move closer to release status, which is A Good Thing (tm) ;) btw, if we get most of these qualified, we will be on around 30 platforms -

[HACKERS] OBSD resultmap changes needed.

2001-03-26 Thread bpalmer
I posted this to the list a few days ago, but it was not addressed. Can someone please make the changes to the src/test/regress/resultmap? Thanks. - brandon b. palmer, [EMAIL PROTECTED] pgp: www.crimelabs.net/bpalmer.pgp5 *** resultmap.orig Fri Mar 23 12:34:56 2001 --- resultmap.n

Re: [HACKERS] OBSD resultmap changes needed.

2001-03-26 Thread Bruce Momjian
Applied. I thought there was some openbsd confusion results so I ignored the previous patch. > I posted this to the list a few days ago, but it was not addressed. Can > someone please make the changes to the src/test/regress/resultmap? > > Thanks. > > - brandon > > > b. palmer, [EMAIL PRO

Re: [HACKERS] Re: Call for platforms

2001-03-26 Thread Peter Eisentraut
Thomas Lockhart writes: > SCO OpenServer 5 x86 7.1 2001-03-13, Billy Allie Where did you see this? I don't find it in the archives or in Vince's database. -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/ ---(end of broadcast)-

Re: [HACKERS] Re: Call for platforms

2001-03-26 Thread Thomas Lockhart
> > SCO OpenServer 5 x86 7.1 2001-03-13, Billy Allie > Where did you see this? I don't find it in the archives or in Vince's > database. In FAQ_SCO. I was looking to try to figure out what the differences were between the SCO products :) - Thomas --

Re: [HACKERS] Re: Call for platforms

2001-03-26 Thread Larry Rosenman
Since the SCO UDK works on both UnixWare and OpenServer, I think we are pretty safe. Also, there was a post to -HACKERS about the accept bug and we changed the workaround to include OSR5. I'd leave it until disproved. I don't have a OSR5 installation to check it with, however. LER >

Re: [HACKERS] Re: Call for platforms

2001-03-26 Thread Tom Lane
Thomas Lockhart <[EMAIL PROTECTED]> writes: > Linux 2.2.18 PPC750 7.1 2001-03-19, Tom Lane "PPC750"? What's that? "PPC G3" might be more likely to mean something to onlookers ... regards, tom lane ---(end of broadcast)---

Re: [HACKERS] OBSD resultmap changes needed.

2001-03-26 Thread Tom Lane
Bruce Momjian <[EMAIL PROTECTED]> writes: > Applied. I thought there was some openbsd confusion results so I > ignored the previous patch. Yeah, I thought there was still some debate about whether we knew the correct resultmap for *bsd or not ... regards, tom lane -

Re: [HACKERS] Re: Call for platforms

2001-03-26 Thread Tom Lane
Thomas Lockhart <[EMAIL PROTECTED]> writes: > As mentioned earlier, Ultrix on RISC means that it is a MIPS processor. >> I suspect that some one of the implementations in s_lock.h was intended >> to be usable on Ultrix, and we've somehow dropped the declarations >> needed to make it go. You migh

Re: [HACKERS] Re: Call for platforms

2001-03-26 Thread Peter Eisentraut
Thomas Lockhart writes: > > > SCO OpenServer 5 x86 7.1 2001-03-13, Billy Allie > > Where did you see this? I don't find it in the archives or in Vince's > > database. > > In FAQ_SCO. I was looking to try to figure out what the differences were > between the SCO products :) I wouldn't necessar

[HACKERS] Unsigned ints

2001-03-26 Thread Adriaan Joubert
Hi, I know I'm a bit early to submit stuff for 7.2, but attached is a patch (agains 7.1RC1) to add uint2 and uint4 as new types. I haven't put in all the possible combinations of signed and unsigned ints as arguments to operators -- I was going insane just doing it for all combinations of

Re: [HACKERS] Re: Call for platforms

2001-03-26 Thread Thomas Lockhart
> "PPC750"? What's that? "PPC G3" might be more likely to mean something > to onlookers ... Actually "G3" means nothing outside of Apple afaict. The 750 series is a follow-on to the 60x series, and there is a 7xxx series also. From my pov, using an accepted label, rather than a marketing (re)la

Re: [HACKERS] Re: Call for platforms

2001-03-26 Thread Thomas Lockhart
> > As mentioned earlier, Ultrix on RISC means that it is a MIPS processor. > > Any hints for Alexander on how to do it *if* it is a MIPS processor? > Not sure. The only info I see in s_lock.h is in the "SGI" section: > * This stuff may be supplemented in the future with Masato Kataoka's MIPS-II

Re: [HACKERS] Re: Call for platforms

2001-03-26 Thread Thomas Lockhart
> > > > SCO OpenServer 5 x86 7.1 2001-03-13, Billy Allie > > > Where did you see this? I don't find it in the archives or in Vince's > > > database. > > In FAQ_SCO. I was looking to try to figure out what the differences were > > between the SCO products :) > I wouldn't necessarily count someth

Re: [HACKERS] Re: Call for platforms

2001-03-26 Thread Larry Rosenman
I would. 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 7

Re: [HACKERS] Re: Call for platforms

2001-03-26 Thread Tom Lane
Karl DeBisschop <[EMAIL PROTECTED]> writes: > In my tests on sparc/7 my compile died at line 3088 of > postgresql-7.1beta6/src/interfaces/python/pgmodule.c: > ./pgmodule.c:3088: parse error before `init_pg' > That's line 3137 of today's (22Mar) snapshot, which reads: > /* Initialization functio

Re: [HACKERS] Re: Call for platforms

2001-03-26 Thread Mathijs Brands
Hi Is there a list somewhere listing the platforms 7.1 is being tested on right now? I'd be able to run regression tests on the following platforms, if necessary: FreeBSD 3.3 (x86) FreeBSD 4.2 (x86) Linux (x86 - 2.2 & 2.4 kernels, Redhat & Debian distro's) Solaris 7 (SPARC) Solaris 8 (

Re: [HACKERS] Re: Call for platforms

2001-03-26 Thread Lamar Owen
Thomas Lockhart wrote: > Linux 2.2.x Alpha 7.1 2001-01-23, Ryan Kirkpatrick > Linux 2.2.x armv4l 7.1 2001-03-22, Mark Knox > Linux 2.2.18 PPC750 7.1 2001-03-19, Tom Lane > Linux 2.2.x S/390 7.1 2000-11-17, Neale Ferguson > Linux 2.2.15 Sparc 7.1 2001-01-30, Ryan Kirkpatrick > Linux 2.2.16 x86

Re: [HACKERS] Re: Call for platforms

2001-03-26 Thread Trond Eivind Glomsrød
Lamar Owen <[EMAIL PROTECTED]> writes: > Thomas Lockhart wrote: > > Linux 2.2.x Alpha 7.1 2001-01-23, Ryan Kirkpatrick > > Linux 2.2.x armv4l 7.1 2001-03-22, Mark Knox > > Linux 2.2.18 PPC750 7.1 2001-03-19, Tom Lane > > Linux 2.2.x S/390 7.1 2000-11-17, Neale Ferguson > > Linux 2.2.15 Sparc 7.

Re: [HACKERS] Re: Call for platforms

2001-03-26 Thread Thomas Lockhart
> Did you get the message from Trond about Linux 2.4 x86? I can also > verify all tests passed on a RedHat Public Beta installation with kernel > 2.4. Trond had indicated that it was a 2.4.2 kernel with lots 'o patches, so I figured I'd show the released stuff for now. I mentioned 2.4.2 in the c

Re: [HACKERS] Re: Call for platforms

2001-03-26 Thread Vince Vielhaber
On Tue, 27 Mar 2001, Mathijs Brands wrote: > Hi > > Is there a list somewhere listing the platforms 7.1 is being > tested on right now? I'd be able to run regression tests on > the following platforms, if necessary: > > FreeBSD 3.3 (x86) > FreeBSD 4.2 (x86) > Linux (x86 - 2.2 & 2.4 kernels

Re: [HACKERS] Re: Call for platforms

2001-03-26 Thread Mathijs Brands
On Mon, Mar 26, 2001 at 05:41:31PM -0500, Vince Vielhaber allegedly wrote: > On Tue, 27 Mar 2001, Mathijs Brands wrote: > > Hi > > > > Is there a list somewhere listing the platforms 7.1 is being > > tested on right now? I'd be able to run regression tests on > > the following platforms, if necess

Re: [HACKERS] Re: Call for platforms

2001-03-26 Thread Lamar Owen
Trond Eivind Glomsrød wrote: > Lamar Owen <[EMAIL PROTECTED]> writes: > > Did you get the message from Trond about Linux 2.4 x86? I can also > > verify all tests passed on a RedHat Public Beta installation with kernel > > 2.4. > I haven't put those in the list yet... I'll wait until we release

[HACKERS] Re: Call for platforms

2001-03-26 Thread Thomas Lockhart
Mathijs Brands wrote: > > Hi > > Is there a list somewhere listing the platforms 7.1 is being > tested on right now? I'd be able to run regression tests on > the following platforms, if necessary: http://www.postgresql.org/devel-corner/docs/admin/supported-platforms.html is close to up to date

Re: [HACKERS] Re: Call for platforms

2001-03-26 Thread Tom Lane
Thomas Lockhart <[EMAIL PROTECTED]> writes: >> Anyway, the last CVS update to port/ultrix.h that appears to have come >> from someone actually using Ultrix was rev 1.2 on 7-May-97, which >> predates the very existence of s_lock.h as a separate file. So I'd >> definitely advise Alexander to find a

Re: [HACKERS] Re: Call for platforms

2001-03-26 Thread Mathijs Brands
On Mon, Mar 26, 2001 at 06:35:59PM -0500, Tom Lane allegedly wrote: > Thomas Lockhart <[EMAIL PROTECTED]> writes: > >> Anyway, the last CVS update to port/ultrix.h that appears to have come > >> from someone actually using Ultrix was rev 1.2 on 7-May-97, which > >> predates the very existence of s

[HACKERS] Re: Call for platforms

2001-03-26 Thread Thomas Lockhart
> >NetBSD m68k7.0 2000-04-10, Henry B. Hotz > I no longer have a 68k machine that's fast enough to reasonably test > PG on. I have a IIcx that sometimes serves as a router, but I'm > using some second-generation powermac's mostly now. (You still have > that Centris in your closet Tom?)

Re: [HACKERS] Re: Call for platforms

2001-03-26 Thread Thomas Lockhart
> The non-test-and-set case should work again in current CVS, and I'd > appreciate it if Alexander would verify that. But as far as getting > some test-and-set support for MIPS goes, it looks like the only way > is for someone to sit down with a MIPS assembly manual. I haven't > got one, nor acc

Re: [HACKERS] Re: Call for platforms

2001-03-26 Thread Tom Lane
Thomas Lockhart <[EMAIL PROTECTED]> writes: > That is not already available from the Irix support code? What we have for IRIX is #if defined(__sgi) /* * SGI IRIX 5 * slock_t is defined as a unsigned long. We use the standard SGI * mutex API. * * The following comment is left for historical

Re: [HACKERS] Re: Call for platforms

2001-03-26 Thread Tom Lane
Thomas Lockhart <[EMAIL PROTECTED]> writes: >> "PPC750"? What's that? "PPC G3" might be more likely to mean something >> to onlookers ... > Actually "G3" means nothing outside of Apple afaict. The 750 series is a > follow-on to the 60x series, and there is a 7xxx series also. From my > pov, usi

[HACKERS] Re: [JDBC] Possible large object bug?

2001-03-26 Thread Tom Lane
"Joe Shevland" <[EMAIL PROTECTED]> writes: > Semi-topical I hope ;) Completely irrelevant to JDBC as far as I can see. I've redirected to pghackers. > NOTICE: Rel pg_attribute: TID 1/115: OID IS INVALID. TUPGONE 1. > ... > NOTICE: Rel pg_attribute: TID 1/6087: OID IS INVALID. TUPGONE 1. > NOT

Re: [HACKERS] Re: Call for platforms

2001-03-26 Thread Justin Clift
Hi, I tested Solaris 8 SPARC (32 bit) over the weekend, and can test Solaris 8 INTEL this week/weekend. The results of Solaris 8 SPARC were in Vince's database last time I checked. ??? + Justin Mathijs Brands wrote: > > Hi > > Is there a list somewhere listing the platforms 7.1 is being > t

Re: [HACKERS] Re: Call for platforms

2001-03-26 Thread Justin Clift
I know that Sourceforge has been adding all sorts of machines to their compile farm. Maybe it would be worthwhile taking a look if they have platforms we don't? Regards and best wishes, Justin Clift Thomas Lockhart wrote: > > > The non-test-and-set case should work again in current CVS, and I

Re: [HACKERS] Re: Call for platforms

2001-03-26 Thread Mathijs Brands
On Tue, Mar 27, 2001 at 12:01:24PM +1000, Justin Clift allegedly wrote: > I know that Sourceforge has been adding all sorts of machines to their > compile farm. > > Maybe it would be worthwhile taking a look if they have platforms we > don't? > > Regards and best wishes, > > Justin Clift Compa

Regression test on FBSD 3.3 & 4.2, IRIX 6.5 (was Re: [HACKERS] Re: Call for platforms)

2001-03-26 Thread Mathijs Brands
On Mon, Mar 26, 2001 at 07:09:38PM -0500, Tom Lane allegedly wrote: > Thomas Lockhart <[EMAIL PROTECTED]> writes: > > That is not already available from the Irix support code? > > What we have for IRIX is > > #if defined(__sgi) > /* > * SGI IRIX 5 > * slock_t is defined as a unsigned long. We

Re: [HACKERS] Re: Call for platforms

2001-03-26 Thread Peter Bierman
At 7:53 PM -0500 3/26/01, Tom Lane wrote: >Thomas Lockhart <[EMAIL PROTECTED]> writes: >>> "PPC750"? What's that? "PPC G3" might be more likely to mean something >>> to onlookers ... > >> Actually "G3" means nothing outside of Apple afaict. The 750 series is a >> follow-on to the 60x series, and

Re: Regression test on FBSD 3.3 & 4.2, IRIX 6.5 (was Re: [HACKERS] Re: Call for platforms)

2001-03-26 Thread Tom Lane
Mathijs Brands <[EMAIL PROTECTED]> writes: > Notice the single underscore before volatile. That's definitely wrong --- fixed. > Fixing this causes > as (the SGI version, not GNU as) to choke on the '.global tas' statement. > s_lock.c: At top level: > s_lock.c:234: warning: `tas_dummy' defined b

[HACKERS] Re: Regression test on FBSD 3.3 & 4.2, IRIX 6.5 (was Re: Re: Call for platforms)

2001-03-26 Thread Thomas Lockhart
> Do you know whether anyone uses the GNU assembler on this platform, > or is it always SGI's? I'm wondering if we need two versions of the > assembly code ... Sure. Both compilers are available, with SGI's, uh, unique approach, and with GNU's well understood assembler. > I had missed the fact

Re: [HACKERS] MIPS test-and-set

2001-03-26 Thread Nathan Myers
On Mon, Mar 26, 2001 at 07:09:38PM -0500, Tom Lane wrote: > Thomas Lockhart <[EMAIL PROTECTED]> writes: > > That is not already available from the Irix support code? > > What we have for IRIX is > ... > Doesn't look to me like it's likely to work on anything but IRIX ... I have attached linuxth

[HACKERS] regression test result HP-UX 11.00, PA8500

2001-03-26 Thread Matthias Juchem
Hi there, I just run 'make check' on RC1 and got the output below. I've read about the negative zeros, but I haven't seen someone reporting a failure during the random test, so I thought it would be good to report this one. If you need additional information, please contact me. Regards, Matthi

[HACKERS] CVS tags for betas and release candidate

2001-03-26 Thread Matthias Juchem
Hi there. I was just looking for the CVS tags for downloading the beta6 and the RC1 of 7.1 but there are only the following tags: REL_7_1_BETA2 REL_7_1_BETA3 REL_7_1 Aren't there tags for the versions I am looking for? Regards, Matthias ---(end of broadcast)-

[HACKERS] Re: Call for platforms

2001-03-26 Thread Tom Ivar Helbekkmo
Thomas Lockhart <[EMAIL PROTECTED]> writes: > NetBSD Sparc 7.0 2000-04-13, Tom I. Helbekkmo Fetching the latest source kit now -- hope to have regression tests run and a report back to you within a day or two. > We need some NetBSD folks to speak up! I've once again got a VAX that should

Re: [HACKERS] Re: Call for platforms

2001-03-26 Thread Tom Lane
"Mark Knox" <[EMAIL PROTECTED]> writes: > On 25 Mar 2001, at 16:07, Tom Lane wrote: >> Does that database have any user-created relations in it, or is it >> just a virgin database? > Totally virgin. I created it just for that select you wanted. Okay. Would you create a couple of random tables

[HACKERS] compress package in bzip2

2001-03-26 Thread Xu Yifeng
could anyone compress Postgresql package in bzip2 format? I am behind a slow line, to save me some bandwith, I would like to download a package named postgresql-7.1RC1.tar.bz2 . Regards, XuYifeng ---(end of broadcast)--- TIP 6: Have you search

Re: [HACKERS] MIPS test-and-set

2001-03-26 Thread Ian Lance Taylor
[EMAIL PROTECTED] (Nathan Myers) writes: > Since the actual instruction sequence is probably lifted from the > MIPS manual, it's probably much freer than GPL. For the paranoid, > the actual instructions, extracted, are just > >1: > ll %0,%3 > bnez %0,2f > li %1,1 >