Re: [HACKERS] Re: [SQL] possible row locking bug in 7.0.3 & 7.1

2001-03-27 Thread Hiroshi Inoue
Tom Lane wrote: > > Philip Warner <[EMAIL PROTECTED]> writes: > >> The workaround for Forest is to make the final SELECT be a SELECT FOR > >> UPDATE, so that it's playing by the same rules as the earlier commands. > > > Eek. Does this seem good to you? > > I did call it a workaround ;-) > > I d

Re: [HACKERS] Re: Call for platforms

2001-03-27 Thread Tatsuo Ishii
> Tatsuo Ishii <[EMAIL PROTECTED]> writes: > >> What gcc version does that platform have? > > > gcc version egcs-2.90.25 980302 (egcs-1.0.2 prerelease) > > Can you try a known-stable gcc version? 2.95.2 say? I don't have time right know. Will do maybe for 7.1.1 or 7.2.. -- Tatsuo Ishii --

Re: [HACKERS] Re: Call for platforms

2001-03-27 Thread Tom Lane
Tatsuo Ishii <[EMAIL PROTECTED]> writes: >> What gcc version does that platform have? > gcc version egcs-2.90.25 980302 (egcs-1.0.2 prerelease) Can you try a known-stable gcc version? 2.95.2 say? regards, tom lane ---(end of broadcast)--

Re: [HACKERS] Re: Call for platforms

2001-03-27 Thread Tatsuo Ishii
> I think you've got a badly broken compiler there. There's no way that > ExecReplace should be entered for a SELECT. The backtrace is wrong on > its face anyway --- ExecutePlan does not call itself. Yes, I have suspected that. > What gcc version does that platform have? gcc version egcs-2.90

Re: [HACKERS] Re: Call for platforms

2001-03-27 Thread Tom Lane
Tatsuo Ishii <[EMAIL PROTECTED]> writes: > > mklinux PPC750 7.0 2000-04-13, Tatsuo Ishii > If compiled with -O2 or -O2 -g, I got 10 tests FAILED. misc test > failed due to a backend crash. The SQL caused the crash was: > select i, length(t), octet_length(t), oldstyle_length(i,t) from > oldst

Re: [HACKERS] 7.1 RC1 RPM

2001-03-27 Thread Hiroshi Inoue
Lamar Owen wrote: > > Tom Lane wrote: > > It would appear you have a conflict about whether MULTIBYTE is defined > > or not --- the code thinks so, but the makefile does not, since > > multibyte.o is not seen in the link command. > > > The identical technique is used in libpq's makefile, so I'm n

[HACKERS] Re: Feature Request: ALTER FUNCTION (or something like that)

2001-03-27 Thread Tom Lane
Joel Burton <[EMAIL PROTECTED]> writes: > If I have your ear on the subject, tgl, is there any ugly-but-working hack > to update the function by modifying the system tables directly? For interpreted function languages, UPDATE pg_proc SET prosrc = 'new body' WHERE proname = '...' will work as lo

[HACKERS]

2001-03-27 Thread Brian Baquiran
set nomail ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html

Re: [HACKERS] Re: Call for platforms

2001-03-27 Thread Tom Lane
"Mark Knox" <[EMAIL PROTECTED]> writes: > { > BlockIdData ip_blkid; > OffsetNumber ip_posid; > +#ifdef __arm__ > +} __attribute__((packed)) ItemPointerData; > +#else > } > +#endif That would fix it for ARM but not for anyplace else with similar alignment behavior. Would you try thi

RE: [HACKERS] Feature Request: ALTER FUNCTION (or something like that)

2001-03-27 Thread Christopher Kings-Lynne
Actually, This reminds me of something I have been meaning to ask. All the new performance features are cool, but what I really need are all the ALTER TABLE ... functions implemented. In 7.0.x you could only add columns and foreign keys. You couldn't drop anything or add stuff like CHECK const

[HACKERS] Re: Feature Request: ALTER FUNCTION (or something like that)

2001-03-27 Thread Joel Burton
On Tue, 27 Mar 2001, Tom Lane wrote: > Joel Burton <[EMAIL PROTECTED]> writes: > > . add a command like ALTER FUNCTION foo(text) TO foo(text) returns text as > > > > This is on the TODO list already, I believe. Yikes. I should have read it more carefully. My apologies. There are so many go

Re: [HACKERS] Re: Call for platforms

2001-03-27 Thread Mark Knox
The following section of this message contains a file attachment prepared for transmission using the Internet MIME message format. If you are using Pegasus Mail, or any another MIME-compliant system, you should be able to save it or view it from within your mailer. If you cannot, please ask your s

Re: [HACKERS] Re: Call for platforms

2001-03-27 Thread Mark Knox
-BEGIN PGP SIGNED MESSAGE- On 27 Mar 2001, at 20:49, Mark Knox wrote: > > > I suspect it might be an alignment problem > > > > Sort of. I am suspicious that sizeof(ItemPointerData) is returning > > 8 rather than 6 as one might expect. > > Maybe it's padding the structure to a dword bo

Re: [HACKERS] Re: Vaccuum Failure w/7.1beta4 on Linux/Sparc -- FALSEALARM

2001-03-27 Thread Ryan Kirkpatrick
On Mon, 26 Mar 2001, Tom Lane wrote: > Ryan Kirkpatrick <[EMAIL PROTECTED]> writes: > > On Mon, 12 Mar 2001, Ryan Kirkpatrick wrote: > >> While testing some existing database applications on 7.1beta4 on > >> my Sparc 20 running Debian GNU/Linux 2.2, I got the following error on > >> attempting to

Re: [HACKERS] Re: 7.1 RC1 RPM

2001-03-27 Thread Lamar Owen
Thomas Lockhart wrote: > FYI: I successfully built a beta4 RPM for Mandrake, having to make only > the following changes: > 1) add -fno-fast-math to the CFLAGS set from RPM_OPT_FLAGS. This fixes > the date/time rounding problems. Would seem to be a non-invasive fix to > put this in for every buil

Re: [HACKERS] Spinlocks on SGI's

2001-03-27 Thread Robert E. Bruccoleri
Dear Mathijs, > > Wouldn't it be best to build IRIX 6.2 binaries? Those should run properly on > IRIX 6.2 and anything newer. Of course, having both IRIX 6.2 and 6.5 binaries > wouldn't really hurt... It's not feasible to do this, nor is it worth it. Irix 6.5 is much more reliable than Irix 6.2.

Re: [HACKERS] Re: Call for platforms

2001-03-27 Thread Mark Knox
-BEGIN PGP SIGNED MESSAGE- On 26 Mar 2001, at 23:14, Tom Lane wrote: > "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 creat

Re: [HACKERS] Re: Call for platforms

2001-03-27 Thread Tatsuo Ishii
> > mklinux PPC750 7.0 2000-04-13, Tatsuo Ishii > > > > Any luck with RC1? > > I will try today or tomorrow... In summary no, improvemnets seen. If compiled with -O2 or -O2 -g, I got 10 tests FAILED. misc test failed due to a backend crash. The SQL caused the crash was: select i, length(t

Re: Solaris 7 SPARC passes tests (was Re: [HACKERS] Re: [BUGS] Tests randomly failed)

2001-03-27 Thread Tom Lane
Mathijs Brands <[EMAIL PROTECTED]> writes: > No luck :( Tests still randomly crash. (This is an Ultra 10 machine.) How about if you change the pg_regress script to use TCP connections? (Look for the bit that forces unix_sockets=no for certain OSes, and add solaris) regard

Re: [HACKERS] Spinlocks on SGI's

2001-03-27 Thread Mathijs Brands
On Tue, Mar 27, 2001 at 11:06:20AM -0400, The Hermit Hacker allegedly wrote: > On Tue, 27 Mar 2001, Robert E. Bruccoleri wrote: > > Dear Marc, > > > On Tue, 27 Mar 2001, Robert E. Bruccoleri wrote: > > > > > > > I contributed the first working s_lock.c code for the SGI's over three > > > > years a

Solaris 7 SPARC passes tests (was Re: [HACKERS] Re: [BUGS] Tests randomly failed)

2001-03-27 Thread Mathijs Brands
On Wed, Mar 28, 2001 at 02:40:00AM +0200, Mathijs Brands allegedly wrote: > On Tue, Mar 27, 2001 at 07:17:47PM +0200, Peter Eisentraut allegedly wrote: > > Tom Lane writes: > > > > > Alexander Klimov <[EMAIL PROTECTED]> writes: > > > > Yes, it was really just incidence -- I try again, and 15 of 1

[HACKERS] Re: Solaris problems (was Re: SPARC Solaris 8 OK)

2001-03-27 Thread Thomas Lockhart
> Erm, I've just tested 7.1RC1 on Solaris 8 x86 and SPARC. Solaris x86 > works without any problems and passes the regression test (apart from > a few very small roundoff errors in the geometry tests). OK, I've got Solaris/x86 checked off. Thanks! > ... However, on > Solaris SPARC tests randomly

Re: [HACKERS] Feature Request: ALTER FUNCTION (or something like that)

2001-03-27 Thread Tom Lane
Joel Burton <[EMAIL PROTECTED]> writes: > . add a command like ALTER FUNCTION foo(text) TO foo(text) returns text as > This is on the TODO list already, I believe. > This would seem to require that the new function would take the same > parameters (and return the same?) as the old function.

Re: [HACKERS] IANA registration

2001-03-27 Thread Vince Vielhaber
On Tue, 27 Mar 2001, Tom Lane wrote: > Vince Vielhaber <[EMAIL PROTECTED]> writes: > >> Maybe we should arrange for a more stable path to the "current release" > >> docs, ie a symlink without a version number? > > > But there is... > > > http://www.postgresql.org/docs/special/protocol.html > > No

Re: [HACKERS] Re: [BUGS] Tests randomly failed

2001-03-27 Thread Mathijs Brands
On Tue, Mar 27, 2001 at 07:17:47PM +0200, Peter Eisentraut allegedly wrote: > Tom Lane writes: > > > Alexander Klimov <[EMAIL PROTECTED]> writes: > > > Yes, it was really just incidence -- I try again, and 15 of 15 `make > > > check' passed with TCP sockets, but only 3 of 15 passed with UNIX > >

[HACKERS] Feature Request: ALTER FUNCTION (or something like that)

2001-03-27 Thread Joel Burton
(I know that everyone is focusing on 7.1. This is a question about how hard it would be to plan a feature for 7.2 or later) One of the small annoyances in PG is that I use many functions to handle small details, and these functions are called by views. If I want to improve a function, I have to

Re: [HACKERS] IANA registration

2001-03-27 Thread Tom Lane
Vince Vielhaber <[EMAIL PROTECTED]> writes: >> Maybe we should arrange for a more stable path to the "current release" >> docs, ie a symlink without a version number? > But there is... > http://www.postgresql.org/docs/special/protocol.html No, that's just the first page of that chapter. If the

Solaris problems (was Re: [HACKERS] SPARC Solaris 8 OK)

2001-03-27 Thread Mathijs Brands
On Tue, Mar 27, 2001 at 10:34:13AM -0600, Brian P Millett allegedly wrote: > == > All 76 tests passed. > == > > vlad: uname -a > SunOS vlad 5.8 Generic_108528-06 sun4u sparc SUNW,Ultra-5_10 > > Reading specs from /opt/sfw/lib/gcc-lib/sparc-sun-solaris2.8/

Re: [HACKERS] IANA registration

2001-03-27 Thread Vince Vielhaber
On Tue, 27 Mar 2001, Tom Lane wrote: > Ok, fine here. BTW, I was thinking that rather than filling in their > webform in any detail, it'd make the most sense to just supply a link > to our protocol documentation, presently > > http://www.postgresql.org/users-lounge/docs/7.0/postgres/protocol.htm

[HACKERS] Re: IANA registration

2001-03-27 Thread Thomas Lockhart
> > > 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. > > > Might someone with a reasonable grasp of the low level messages in

Re: [HACKERS] IANA registration

2001-03-27 Thread Tom Lane
The Hermit Hacker <[EMAIL PROTECTED]> writes: >> This seemed like a Marc job to me. Marc? > Will do ... *nod* Ok, fine here. BTW, I was thinking that rather than filling in their webform in any detail, it'd make the most sense to just supply a link to our protocol documentation, presently htt

Re: [HACKERS] IANA registration

2001-03-27 Thread The Hermit Hacker
On Tue, 27 Mar 2001, Bruce Momjian wrote: > > Pete Forman <[EMAIL PROTECTED]> writes: > > > 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

[ADMIN] pgmonitor and Solaris

2001-03-27 Thread Bruce Momjian
I believe I have found the cause of the pgmonitor problem on Solaris. pgmonitor assumes you have a working 'ps' status display, which shows user/database/connection, and query type. I have learned from a Great Bridge employee that his Solaris box is not updating the ps display for 7.1beta, and I

[HACKERS] Re: 7.1 RC1 RPM

2001-03-27 Thread Thomas Lockhart
FYI: I successfully built a beta4 RPM for Mandrake, having to make only the following changes: 1) add -fno-fast-math to the CFLAGS set from RPM_OPT_FLAGS. This fixes the date/time rounding problems. Would seem to be a non-invasive fix to put this in for every build, or to flag it as a Mandrake-on

Re: [HACKERS] IANA registration

2001-03-27 Thread Bruce Momjian
> Pete Forman <[EMAIL PROTECTED]> writes: > > 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. > > Might someone with a reasonable g

Re: [HACKERS] Re: Call for platforms

2001-03-27 Thread thomas graichen
Tom Ivar Helbekkmo <[EMAIL PROTECTED]> wrote: > 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 fol

Re: [HACKERS] Re: Call for platforms

2001-03-27 Thread Tom Lane
Mathijs Brands <[EMAIL PROTECTED]> writes: > Even if you fix this it won't work (I tried it). Robert mailed > why. Check the URL below for more information. It crashes on semctl :( > http://freeware.sgi.com/shared/howto.html#b1 Ugh. Given the semctl compatibility problem, I suspect we'd better

Re: [HACKERS] IANA registration

2001-03-27 Thread Tom Lane
Pete Forman <[EMAIL PROTECTED]> writes: > 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. > Might someone with a reasonable grasp of th

[HACKERS] Re: Call for platforms

2001-03-27 Thread Tom Ivar Helbekkmo
I wrote: > > 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. Hmm. No go here: everything looks peachy until I've started the postmaster, and attempt to connect to it:

Re: [HACKERS] 7.1 RC1 RPM

2001-03-27 Thread Lamar Owen
Tom Lane wrote: > It would appear you have a conflict about whether MULTIBYTE is defined > or not --- the code thinks so, but the makefile does not, since > multibyte.o is not seen in the link command. > The identical technique is used in libpq's makefile, so I'm not sure > why you do not see a

Re: [HACKERS] 7.1 RC1 RPM

2001-03-27 Thread Lamar Owen
Lamar Owen wrote: > Well, in any case, preliminary 7.1RC1 RPMS are up. There are some odd > issues with the packaging that I am working on. Be sure to read > README.rpm-dist -- attached to this message for your convenience. Forgot to attach the file. :-(. -- Lamar Owen WGCR Internet Radio 1 Pet

Re: [HACKERS] RC1 core dumps in initdb on Solaris 2.6

2001-03-27 Thread Tom Lane
Pete Forman <[EMAIL PROTECTED]> writes: > The regression test is failing early on, during initdb. The core file > indicates that there is a SIGBUS. Hopefully the bugs fixed as a > result of the "More bogus alignment assumptions" thread will sort > things out. Sure looks like this is the same is

Re: [HACKERS] 7.1 RC1 RPM

2001-03-27 Thread Tom Lane
Lamar Owen <[EMAIL PROTECTED]> writes: > BIG NOTE: These are built on Red Hat _7.0_ NOT 6.2 as previous ones > have been. The ODBC client build on 6.2 has been broken -- it built at > beta4, but now gives this error set at beta6/RC1: > ar crs libpsqlodbc.a info.o bind.o columninfo.o connection.o

[HACKERS] RC1 core dumps in initdb on Solaris 2.6

2001-03-27 Thread Pete Forman
The regression test is failing early on, during initdb. The core file indicates that there is a SIGBUS. Hopefully the bugs fixed as a result of the "More bogus alignment assumptions" thread will sort things out. Here are initdb.log and the stack trace. If needs be I can recompile with -g but u

Re: [HACKERS] 7.1 RC1 RPM

2001-03-27 Thread Lamar Owen
Lamar Owen wrote: > > Mike Cannon-Brookes wrote: > > > > Any change of getting a 7.1 RC1 RPM? I'm using the beta4 RPMs at the moment > > but don't seem to be any more recent ones. > > I'm building a quickie RC1-1 RPM right now. There are some other things > I need to do on the RPMset before fin

Re: [HACKERS] Ultrix port

2001-03-27 Thread Tom Lane
Alexander Klimov <[EMAIL PROTECTED]> writes: > First problem is sys/socket.h. Here it has no guards in it (like > #ifdef _SOCKET_H > #endif), so it could not be included twice, and I have to remove its > unnecesarry inclusions. Are you sure these are unnecessary? What are the odds this patch wi

Re: [HACKERS] Backend crash (segfault) on query with inheritance hierarchy

2001-03-27 Thread Tom Lane
"Oliver Elphick" <[EMAIL PROTECTED]> writes: > Table `job' is inherited by `manufactured_job' and `purchased_job'. This > query works on either inherited table but not on the whole hierarchy: I've committed a fix to CVS. regards, tom lane ---(end

Re: [HACKERS] Ultrix port

2001-03-27 Thread Peter Eisentraut
Alexander Klimov writes: > After two days of strugle I have compiled pgsql on ultrix, patch is in > attachment. I still can't run `gmake check', because of shell problems > in install.log: > > install: no destination specified > gmake[6]: *** [install-lib-shared] Error 1 > gmake[6]: Leaving

[HACKERS] pgmonitor 0.30 released

2001-03-27 Thread Bruce Momjian
I have just released pgmonitor 0.30. I have added a new 'set debug' option that should help with porting. I know some people are testing Solaris and this may help. README and CHANGES files attached. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED]

Re: [HACKERS] 7.1 RC1 RPM

2001-03-27 Thread Lamar Owen
Mike Cannon-Brookes wrote: > > Any change of getting a 7.1 RC1 RPM? I'm using the beta4 RPMs at the moment > but don't seem to be any more recent ones. I'm building a quickie RC1-1 RPM right now. There are some other things I need to do on the RPMset before final release -- and I plan on workin

[HACKERS] Ultrix port

2001-03-27 Thread Alexander Klimov
Hi all. After two days of strugle I have compiled pgsql on ultrix, patch is in attachment. I still can't run `gmake check', because of shell problems in install.log: install:no destination specified gmake[6]: *** [install-lib-shared] Error 1 gmake[6]: Leaving directory `/tmp_mnt/hosts/wi

Re: [HACKERS] Re: [BUGS] Tests randomly failed

2001-03-27 Thread Peter Eisentraut
Tom Lane writes: > Alexander Klimov <[EMAIL PROTECTED]> writes: > > Yes, it was really just incidence -- I try again, and 15 of 15 `make > > check' passed with TCP sockets, but only 3 of 15 passed with UNIX > > sockets. So, final decision is `Unix sockets are not relaible on Solaris' What become

Re: [HACKERS] docs toolchain appears broke?

2001-03-27 Thread Bruce Momjian
> Bruce Momjian <[EMAIL PROTECTED]> writes: > > I still have it. I am waiting for someone to comment on it. Seems you > > are the one to comment. Applying now. > > I was waiting for Peter E. to comment ... Yea, me too. -- Bruce Momjian| http://candle.pha.pa.us [

Re: [HACKERS] Re: Call for platforms

2001-03-27 Thread Tom Lane
"Mayers, Philip J" <[EMAIL PROTECTED]> writes: > I've already reported this to the webpage, but I got a fail on the random > test: > random ... failed (ignored) See http://www.postgresql.org/devel-corner/docs/postgres/regress.html especially the last item ...

Re: [HACKERS] docs toolchain appears broke?

2001-03-27 Thread Tom Lane
Bruce Momjian <[EMAIL PROTECTED]> writes: > I still have it. I am waiting for someone to comment on it. Seems you > are the one to comment. Applying now. I was waiting for Peter E. to comment ... regards, tom lane ---(end of broadcast)-

Re: [HACKERS] docs toolchain appears broke?

2001-03-27 Thread Bruce Momjian
Applied. Thanks. > 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='*.sgml' --exclude=ref *.html -C `cd .

Re: [HACKERS] docs toolchain appears broke?

2001-03-27 Thread Bruce Momjian
I still have it. I am waiting for someone to comment on it. Seems you are the one to comment. Applying now. [ Charset ISO-8859-1 unsupported, converting... ] > Can Ian's patch be committed, please? > > Thanks. > LER > > > >> Original Message << > > On 3/26

[HACKERS] SPARC Solaris 8 OK

2001-03-27 Thread Brian P Millett
== All 76 tests passed. == vlad: uname -a SunOS vlad 5.8 Generic_108528-06 sun4u sparc SUNW,Ultra-5_10 Reading specs from /opt/sfw/lib/gcc-lib/sparc-sun-solaris2.8/2.95.2/specs gcc version 2.95.2 19991024 (release) CFLAGS=-O6 -mcpu=v8 -Wa,-xarch=v8plusa

Re: [HACKERS] Spinlocks on SGI's

2001-03-27 Thread Peter Eisentraut
The Hermit Hacker writes: > Robert, any possibility of getting pre-compiled binaries for SGI that we > can put up on the site? For those that can't afford the extra cost of the > compilers? :) I think this http://freeware.sgi.com/Installable/postgresql-7.0.html is the canonical place to put t

Re: [HACKERS] Re: Call for platforms

2001-03-27 Thread Mathijs Brands
On Tue, Mar 27, 2001 at 09:57:45AM -0500, Bruce Momjian allegedly wrote: > We just fixed that yesterday. Can you grab the most recent CVS and give > it a try? Even if you fix this it won't work (I tried it). Robert mailed why. Check the URL below for more information. It crashes on semctl :( ht

Re: [HACKERS] Re: [BUGS] Tests randomly failed

2001-03-27 Thread Tom Lane
Alexander Klimov <[EMAIL PROTECTED]> writes: > Yes, it was really just incidence -- I try again, and 15 of 15 `make > check' passed with TCP sockets, but only 3 of 15 passed with UNIX > sockets. So, final decision is `Unix sockets are not relaible on Solaris' So, shall we change pg_regress.sh to

Re: [HACKERS] Error: file pg_psort*

2001-03-27 Thread Tom Lane
Juan Manuel =?iso-8859-1?Q?Garc=EDa?= Arias <[EMAIL PROTECTED]> writes: > ¿What is this file? > ¿what can I do? One of this file is of 2.6 Gb Files named like that are just temporary files for sorting; you can remove them if the creating process isn't around anymore. BTW, consider updating to a

RE: [HACKERS] Re: Call for platforms

2001-03-27 Thread Mayers, Philip J
I've already reported this to the webpage, but I got a fail on the random test: random ... failed (ignored) This is on a stock RedHat 7.0 kernel box with the SMP kernel (but running a single processor): [pjm3@localhost regress]$ less regression.diffs *** ./expected/random.out

Re: [HACKERS] docs toolchain appears broke?

2001-03-27 Thread Larry Rosenman
Can Ian's patch be committed, please? Thanks. LER >> Original Message << On 3/26/01, 5:13:39 AM, Larry Rosenman <[EMAIL PROTECTED]> wrote regarding Re: [HACKERS] docs toolchain appears broke?: > * Ian Lance Taylor <[EMAIL PROTECTED]> [010326 01:14]: > > Tom L

Re: [HACKERS] Spinlocks on SGI's

2001-03-27 Thread The Hermit Hacker
On Tue, 27 Mar 2001, Robert E. Bruccoleri wrote: > Dear Marc, > > > > On Tue, 27 Mar 2001, Robert E. Bruccoleri wrote: > > > > > I contributed the first working s_lock.c code for the SGI's over three > > > years ago (using the test_and_set library calls). It's been working > > > for me ever since

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

2001-03-27 Thread Peter Eisentraut
Mathijs Brands writes: > I just tried to compile 7.1RC1 on my IRIX 6.5 box using gcc 2.95.2. According to the information at http://freeware.sgi.com/shared/howto.html#b1 it probably won't work to compile PostgreSQL with GCC on Irix. Or it might work and crash when run. Be warned. (I think it i

Re: [HACKERS] Re: Majordomo Delivery Error

2001-03-27 Thread The Hermit Hacker
gone On Tue, 27 Mar 2001, Thomas Swan wrote: > At 3/27/2001 03:21 AM, [EMAIL PROTECTED] wrote: > >This message was created automatically by mail delivery software. > >A Majordomo message could not be delivered to the following addresses: > > > > [EMAIL PROTECTED]: > > 450 4.7.1 <[EMAIL PRO

Re: [HACKERS] Spinlocks on SGI's

2001-03-27 Thread Tom Lane
[EMAIL PROTECTED] (Robert E. Bruccoleri) writes: > I contributed the first working s_lock.c code for the SGI's over three > years ago (using the test_and_set library calls). It's been working > for me ever since in a heavy multi-user environment. Please don't > change it unless there's an overwhel

Re: [HACKERS] Re: Call for platforms

2001-03-27 Thread Tom Lane
Jeff Duffy <[EMAIL PROTECTED]> writes: > s_lock.c:235: parse error before `_volatile__' That typo is fixed in current sources (should be OK in last night's snapshot) but there's still some doubt as to how well the MIPS assembly code works ... regards, tom lane --

Re: [HACKERS] FAQ_AIX and AIX C++ patches (was: Call for platforms)

2001-03-27 Thread Bruce Momjian
Applied because it is AIX-specific changes. Thanks. [ Charset ISO-8859-1 unsupported, converting... ] > > The following patch updates the FAQ_AIX and makes C++ code work with > more recent versions of the IBM C++ compiler (now called VisualAge C++). > The C++ part was previously broken (g++ a

Re: [HACKERS] Re: Call for platforms

2001-03-27 Thread Bruce Momjian
We just fixed that yesterday. Can you grab the most recent CVS and give it a try? > One that didn't compilei RC1: > > BIGBOY 71# uname -a > IRIX BIGBOY 6.5 05190003 IP22 > > On an Indigo2 (R4000), gcc 2.95.2 , with the following error: > > gcc -Wall -Wmissing-prototypes -Wmissing-declarati

[HACKERS] 7.1 RC1 RPM

2001-03-27 Thread Mike Cannon-Brookes
Any change of getting a 7.1 RC1 RPM? I'm using the beta4 RPMs at the moment but don't seem to be any more recent ones. It would seem dangerous to me to produce a 7.1 RPM without testing the RPM build process? -mike ---(end of broadcast)--- TIP 6

[HACKERS] Re: Majordomo Delivery Error

2001-03-27 Thread Thomas Swan
At 3/27/2001 03:21 AM, [EMAIL PROTECTED] wrote: >This message was created automatically by mail delivery software. >A Majordomo message could not be delivered to the following addresses: > > [EMAIL PROTECTED]: > 450 4.7.1 <[EMAIL PROTECTED]>... Can not check MX records for > recipient host

[HACKERS] Error: files pg_psort.*

2001-03-27 Thread Juan Manuel García Arias
¿What is this file? ¿what can I do? One of this file is of 2.6 Bbytes the DB is of 50 Mb Is urgent. Thanks you. ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere"

Re: [HACKERS] Spinlocks on SGI's

2001-03-27 Thread Matthew Kirkwood
On Tue, 27 Mar 2001, Robert E. Bruccoleri wrote: > BTW, SGI is distributing its compilers for Linux/Intel under an > open source license. Depending on the progress of Intel chips > versus MIPS chips, the cost issue of the compilers on SGI's will > eventually disappear. Do you mean their ia64 co

Re: [HACKERS] 7.1 docs

2001-03-27 Thread He Weiping(Laser Henry)
> > en_GB would be a "British English" translation. I don't think this is > what you wanted to do. > cn_GB, sorry. :-D Regards Laser Henry ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "

[HACKERS] Error: file pg_psort*

2001-03-27 Thread Juan Manuel García Arias
¿What is this file? ¿what can I do? One of this file is of 2.6 Gb the DB is of 50 Mb Is urgent. Thanks you. ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl

[HACKERS] Re: Call for platforms

2001-03-27 Thread Jeff Duffy
One that didn't compilei RC1: BIGBOY 71# uname -a IRIX BIGBOY 6.5 05190003 IP22 On an Indigo2 (R4000), gcc 2.95.2 , with the following error: gcc -Wall -Wmissing-prototypes -Wmissing-declarations -I../../../../src/include -U_NO_XOPEN4 -c s_lock.c -o s_lock.o s_lock.c: In function `s_lock':

Re: [HACKERS] Re: Call for platforms

2001-03-27 Thread Mark Knox
-BEGIN PGP SIGNED MESSAGE- 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? It seems that the wrong attlen is being > computed for ctid fields during bootstrap, but the regression test > output (if i

Re: [HACKERS] Spinlocks on SGI's

2001-03-27 Thread Robert E. Bruccoleri
Dear Marc, > > On Tue, 27 Mar 2001, Robert E. Bruccoleri wrote: > > > I contributed the first working s_lock.c code for the SGI's over three > > years ago (using the test_and_set library calls). It's been working > > for me ever since in a heavy multi-user environment. Please don't > > change it

[HACKERS] Re: Call for platforms

2001-03-27 Thread Henry B. Hotz
At 5:14 PM + 3/26/01, Thomas Lockhart wrote: >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 sti

Re: [HACKERS] Spinlocks on SGI's

2001-03-27 Thread The Hermit Hacker
On Tue, 27 Mar 2001, Robert E. Bruccoleri wrote: > I contributed the first working s_lock.c code for the SGI's over three > years ago (using the test_and_set library calls). It's been working > for me ever since in a heavy multi-user environment. Please don't > change it unless there's an overwhe

Re: [HACKERS] Spinlocks on SGI's

2001-03-27 Thread Robert E. Bruccoleri
Dear Mathijs, > > > > > Also, the GNU compiler systems works poorly on SGI's. In this > > environment, you need to stick to the SGI provided compilers. Once you > > get used to them, they work fairly well. > > The problem is that SGI wants a couple of hundred dollars for it :( Unfortunately, t

Re: [HACKERS] Spinlocks on SGI's

2001-03-27 Thread Mathijs Brands
On Tue, Mar 27, 2001 at 08:59:45AM -0500, Robert E. Bruccoleri allegedly wrote: > I contributed the first working s_lock.c code for the SGI's over three > years ago (using the test_and_set library calls). It's been working > for me ever since in a heavy multi-user environment. Please don't > chang

[HACKERS] Spinlocks on SGI's

2001-03-27 Thread Robert E. Bruccoleri
I contributed the first working s_lock.c code for the SGI's over three years ago (using the test_and_set library calls). It's been working for me ever since in a heavy multi-user environment. Please don't change it unless there's an overwhelming reason. Also, the GNU compiler systems works poorly

Re: [HACKERS] CVS tags for betas and release candidate

2001-03-27 Thread Alfred Perlstein
* The Hermit Hacker <[EMAIL PROTECTED]> [010327 05:31] wrote: > On Tue, 27 Mar 2001, Alfred Perlstein wrote: > > > * The Hermit Hacker <[EMAIL PROTECTED]> [010327 04:53] wrote: > > > On Mon, 26 Mar 2001, Matthias Juchem wrote: > > > > > > > Hi there. > > > > > > > > I was just looking for the CVS

Re: [HACKERS] CVS tags for betas and release candidate

2001-03-27 Thread The Hermit Hacker
On Tue, 27 Mar 2001, Alfred Perlstein wrote: > * The Hermit Hacker <[EMAIL PROTECTED]> [010327 04:53] wrote: > > On Mon, 26 Mar 2001, Matthias Juchem wrote: > > > > > Hi there. > > > > > > I was just looking for the CVS tags for downloading the beta6 and the > > > RC1 of 7.1 but there are only th

Re: [HACKERS] CVS tags for betas and release candidate

2001-03-27 Thread Alfred Perlstein
* The Hermit Hacker <[EMAIL PROTECTED]> [010327 04:53] wrote: > On Mon, 26 Mar 2001, Matthias Juchem wrote: > > > 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 >

Re: [HACKERS] CVS tags for betas and release candidate

2001-03-27 Thread The Hermit Hacker
On Mon, 26 Mar 2001, Matthias Juchem wrote: > 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? Nope ... doin

[HACKERS] Re: [BUGS] Tests randomly failed

2001-03-27 Thread Alexander Klimov
On Mon, 26 Mar 2001, Justin Clift wrote: > Out of curiosity, how many times are you running the tests? > > I've been building 7.1RC1 over the weekend, and from one compiled > version I ran the regression tests 5 times before getting things to > pass. No changes anywhere, just re-ran the tests. >

Re: [HACKERS] Re: Call for platforms

2001-03-27 Thread Mathijs Brands
On Tue, Mar 27, 2001 at 06:36:37AM -0500, D'Arcy J.M. Cain allegedly wrote: > Thus spake Tom Ivar Helbekkmo > > > We need some NetBSD folks to speak up! > > I have successfully compiled it from CVS sources on my NetBSD -current but > I can't find the tar file for RC1 to try it with the package sy

Re: [HACKERS] Re: Call for platforms

2001-03-27 Thread D'Arcy J.M. Cain
Thus spake Tom Ivar Helbekkmo > > We need some NetBSD folks to speak up! I have successfully compiled it from CVS sources on my NetBSD -current but I can't find the tar file for RC1 to try it with the package system. Can someone point me to it please. -- D'Arcy J.M. Cain| Democracy is thr

Re: [HACKERS] Fix for possible pg_dump core dump

2001-03-27 Thread Pete Forman
Philip Warner writes: > At 10:20 27/03/01 +0100, Pete Forman wrote: > >I've fixed this bug in 7.1RC1. It may have been causing core > >dumps by dereferencing a null function pointer. As it was the Sun > >compiler flagged it as an error. (SC5.0 on Solaris 2.6.) > > > > Thanks for this, b

Re: [HACKERS] Fix for possible pg_dump core dump

2001-03-27 Thread Philip Warner
At 10:20 27/03/01 +0100, Pete Forman wrote: >I've fixed this bug in 7.1RC1. It may have been causing core dumps by >dereferencing a null function pointer. As it was the Sun compiler >flagged it as an error. (SC5.0 on Solaris 2.6.) > Thanks for this, but Tom applied a similar patch a few days a

[HACKERS] Backend crash (segfault) on query with inheritance hierarchy

2001-03-27 Thread Oliver Elphick
Table `job' is inherited by `manufactured_job' and `purchased_job'. This query works on either inherited table but not on the whole hierarchy: bray=# select * from manufactured_job AS j where not exists (select * from price where price.product = j.product); product | qty | carriage | qc_sheet

[HACKERS] FAQ_AIX and AIX C++ patches (was: Call for platforms)

2001-03-27 Thread Zeugswetter Andreas SB
The following patch updates the FAQ_AIX and makes C++ code work with more recent versions of the IBM C++ compiler (now called VisualAge C++). The C++ part was previously broken (g++ and xlC), thus this is zero risk. Only AIX specific parts are touched (1 Makefile.shlib line (link with $(COMPILER

[HACKERS] Fix for possible pg_dump core dump

2001-03-27 Thread Pete Forman
I've fixed this bug in 7.1RC1. It may have been causing core dumps by dereferencing a null function pointer. As it was the Sun compiler flagged it as an error. (SC5.0 on Solaris 2.6.) *** src/bin/pg_dump/pg_backup_null.c.orig Sat Mar 24 00:54:54 2001 --- src/bin/pg_dump/pg_backup_null.

[HACKERS] Re: Call for platforms

2001-03-27 Thread Tatsuo Ishii
> mklinux PPC750 7.0 2000-04-13, Tatsuo Ishii > > Any luck with RC1? I will try today or tomorrow... -- Tatsuo Ishii ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMA