[HACKERS] rc1 fedora core rpms

2004-12-03 Thread Joe Conway
As promised, I've posted 8.0.0rc1 rpms here: http://www.joeconway.com/postgresql-8.0.0rc/ Again note that these are not "official" PGDG rpms, just my own home brew. In addition to the change of Postgres itself from beta5 to rc1, I updated jdbc to latest beta (pg80b1.308*). Joe

Re: [HACKERS] So is there a 8.0RC1 tomorrow

2004-12-03 Thread lsunley
CONGRATULATIONS BTW - I have the OS/2 port running through to creating the template0 and template1 databases with initdb. I have a glitch with the fork() processing that seems to be in the OS/2 GCC 3.3.5 runtime, but I expect to have that resolved shortly. I am going to apply the patches fro

Re: [HACKERS] So is there a 8.0RC1 tomorrow

2004-12-03 Thread Bruce Momjian
[EMAIL PROTECTED] wrote: > Out of all of the messages on this thread, I am still not sure... > > Is there an RC1 coming out RSN? Yes, it has been packaged and is now propogating to the mirrors. It is on the main ftp site now under /pub/beta/*rc1*. -- Bruce Momjian| h

Re: [HACKERS] So is there a 8.0RC1 tomorrow

2004-12-03 Thread lsunley
Out of all of the messages on this thread, I am still not sure... Is there an RC1 coming out RSN? Lorne -- --- [EMAIL PROTECTED] --- ---(end of broadcast)---

Re: [HACKERS] 8.0RC1 tomorrow

2004-12-03 Thread Andrew Dunstan
I wrote: I started work today on a page that lists all the members. Now viewable here: http://www.pgbuildfarm.org/cgi-bin/show_members.pl In due course, the branch names will be links to the build history. cheers andrew ---(end of broadcast)--- TIP

Re: [HACKERS] somebody working on: Prevent default re-use of sysids

2004-12-03 Thread Bruce Momjian
Kris Jurka wrote: > > > On Fri, 3 Dec 2004, Bruce Momjian wrote: > > > > What about Alvaro's shared dependencies work: > > > > > > http://archives.postgresql.org/pgsql-hackers/2004-10/msg00963.php > > > > That is for allowing comments on global tables like pg_shadow and > > pg_database. I don

Re: [HACKERS] somebody working on: Prevent default re-use of sysids

2004-12-03 Thread Kris Jurka
On Fri, 3 Dec 2004, Bruce Momjian wrote: > > What about Alvaro's shared dependencies work: > > > > http://archives.postgresql.org/pgsql-hackers/2004-10/msg00963.php > > That is for allowing comments on global tables like pg_shadow and > pg_database. I don't think it relates to finding if some

Re: [HACKERS] --prefix="/Program\ Files" and build failures

2004-12-03 Thread Andrew Dunstan
Tom Lane wrote: Darcy Buskermolen <[EMAIL PROTECTED]> writes: While monkeying around with configure --prefix I fond the following. You probably shouldn't backslash the space. Also recall that we have just gone through some pain so we can make a postgres installation relocatable. One of

Re: [HACKERS] somebody working on: Prevent default re-use of sysids

2004-12-03 Thread Bruce Momjian
Kris Jurka wrote: > > > On Fri, 3 Dec 2004, Tom Lane wrote: > > > > 2) Prevent dropping user that still owns objects, or auto-drop the > > > objects > > > > No one has any idea how to do this reasonably --- the problem is you > > have no visibility into databases other than the one you're conn

Re: [HACKERS] --prefix="/Program\ Files" and build failures

2004-12-03 Thread Tom Lane
Darcy Buskermolen <[EMAIL PROTECTED]> writes: > While monkeying around with configure --prefix I fond the following. You probably shouldn't backslash the space. regards, tom lane ---(end of broadcast)--- TIP 7: don't forget

[HACKERS] --prefix="/Program\ Files" and build failures

2004-12-03 Thread Darcy Buskermolen
While monkeying around with configure --prefix I fond the following. (there may be more but this one was still in my scroll back... [...snip..] /usr/local/bin/gmake -C ecpglib install gmake[4]: Entering directory `/usr/local/src/postgresql-8.0.0/src/interface s/ecpg/ecpglib' gcc -O2 -Wa

Re: [HACKERS] rc1 packaged ...

2004-12-03 Thread Tom Lane
"Marc G. Fournier" <[EMAIL PROTECTED]> writes: > look her over ... I forced a sync to the ftp.postgresql.org server, so its > available there ... will announce later this evening baring any 'its > broken' commends ;) Tarball looks alright to me. regards, tom lane --

Re: [HACKERS] somebody working on: Prevent default re-use of sysids for dropped users and groups?

2004-12-03 Thread Tom Lane
Kris Jurka <[EMAIL PROTECTED]> writes: > On Fri, 3 Dec 2004, Tom Lane wrote: >> No one has any idea how to do this reasonably --- the problem is you >> have no visibility into databases other than the one you're connected >> to, so you can't tell what the user owns in other databases. > What about

Re: [HACKERS] somebody working on: Prevent default re-use of sysids

2004-12-03 Thread Kris Jurka
On Fri, 3 Dec 2004, Tom Lane wrote: > > 2) Prevent dropping user that still owns objects, or auto-drop the > > objects > > No one has any idea how to do this reasonably --- the problem is you > have no visibility into databases other than the one you're connected > to, so you can't tell what t

[HACKERS] rc1 packaged ...

2004-12-03 Thread Marc G. Fournier
look her over ... I forced a sync to the ftp.postgresql.org server, so its available there ... will announce later this evening baring any 'its broken' commends ;) Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email: [EMAIL PROTECTED] Yahoo!: yscrappy

Re: [HACKERS] somebody working on: Prevent default re-use of sysids for dropped users and groups?

2004-12-03 Thread Tom Lane
schmidtm <[EMAIL PROTECTED]> writes: > is somebody working on these two issues on the TODO-List? > 1) Prevent default re-use of sysids for dropped users and groups I don't know of anyone actively working on it, but if you check the archives you'll find that the preferred solution approach is pret

Re: [HACKERS] OK, ready for RC1 or Beta6

2004-12-03 Thread Andrew Dunstan
Tom Lane wrote: Andrew Dunstan <[EMAIL PROTECTED]> writes: Tom Lane wrote: It's too bad the buildfarm reports don't show more details about what CVS pull they're using exactly. Snapshot is the UTC time at which the cvs pull was done. That's good but it's of limited use to

Re: Buildfarm coverage (was Re: [HACKERS] OK, ready for RC1 or Beta6)

2004-12-03 Thread Tom Lane
Travis P <[EMAIL PROTECTED]> writes: > You'll probably find multi-OS-testing (various versions of AIX, Linux, > MacOS X on PPC and/or PowerPC) much more important than differentiating > particular pieces of hardware in the PPC or RS6000 category, assuming > both 32-bit and 64-bit is covered and

Re: [HACKERS] OK, ready for RC1 or Beta6

2004-12-03 Thread Marc G. Fournier
On Fri, 3 Dec 2004, Tom Lane wrote: That's good but it's of limited use to me, since the snaps are (I presume) against the anonymous-CVS server which lags commits on the master by I'm-not-sure-how-much. 19 * * * * /projects/update_anoncvs.sh Marc G. Fournier Hub.Org Networking Serv

Re: Buildfarm coverage (was Re: [HACKERS] OK, ready for RC1 or Beta6)

2004-12-03 Thread Travis P
On Dec 3, 2004, at 2:33 PM, Kenneth Marshall wrote: On Fri, Dec 03, 2004 at 03:20:48PM -0500, Tom Lane wrote: PPC tested pretty often by moi RS6000 isn't this same as PPC? This is the IBM Power4 and now Power5 architecture which is different from

Re: [HACKERS] OK, ready for RC1 or Beta6

2004-12-03 Thread Tom Lane
Darcy Buskermolen <[EMAIL PROTECTED]> writes: > http://www.pgbuildfarm.org/cgi-bin/show_log.pl?nm=loris&dt=2004-12-03%2020:54:53 > Lends me to think your tweek didn't push hard enough in the right spots. Yup, you're right. I used a bigger hammer ;-) regards, tom lane --

Re: Buildfarm coverage (was Re: [HACKERS] OK, ready for RC1 or Beta6)

2004-12-03 Thread Tom Lane
"Jim Buttafuoco" <[EMAIL PROTECTED]> writes: > I have setup the following running debian linux. MIPS, MIPSEL, ALPHA, > PARISC, M68K, ARM, SPARC, I386. I have the build farm running local > and I have just started to get the systems registered. Excellent, that's very good news.

Re: [HACKERS] OK, ready for RC1 or Beta6

2004-12-03 Thread Tom Lane
Andrew Dunstan <[EMAIL PROTECTED]> writes: > Tom Lane wrote: >> It's too bad the buildfarm reports don't show more details about what >> CVS pull they're using exactly. > Snapshot is the UTC time at which the cvs pull was done. That's good but it's of limited use to me, since the snaps are (I p

Re: Buildfarm coverage (was Re: [HACKERS] OK, ready for RC1 or Beta6)

2004-12-03 Thread Tom Lane
Andrew Dunstan <[EMAIL PROTECTED]> writes: > The configuration is chosen in the config file for each member, rather > than being dictated centrally. This is good. Now what we need is a little cooperation among the buildfarm team to make sure that the collective set of cases tested covers all the

[HACKERS] somebody working on: Prevent default re-use of sysids for dropped users and groups?

2004-12-03 Thread schmidtm
Hi *, is somebody working on these two issues on the TODO-List? 1) Prevent default re-use of sysids for dropped users and groups Currently, if a user is removed while he still owns objects, a new user given might be given their user id and inherit the previous users objects. 2) Prevent dropp

Re: [HACKERS] OK, ready for RC1 or Beta6

2004-12-03 Thread Andrew Dunstan
Andrew Dunstan wrote: I think that this case might be fixed by the tweaking I did yesterday, but I can't tell whether that run occurred before or after that commit. In any case it's not a real failure, just an output-ordering difference. I am running it again to see. I agree that at worst it

Re: [HACKERS] OK, ready for RC1 or Beta6

2004-12-03 Thread Darcy Buskermolen
On December 3, 2004 11:14 am, Tom Lane wrote: > Darcy Buskermolen <[EMAIL PROTECTED]> writes: > > On December 3, 2004 10:31 am, you wrote: > >> 2. There are critical notices on buildfarm for some more popular > >> platforms such as Solaris 9 and Open BSD. > > > > The OpenBSD error should be fixed b

Re: Buildfarm coverage (was Re: [HACKERS] OK, ready for RC1 or Beta6)

2004-12-03 Thread Andrew Dunstan
Peter Eisentraut wrote: Tom Lane wrote: Where the buildfarm falls down a bit is on the cross-product coverage. But I think you're not going to get the cross product without a call for port reports; there aren't that many people who are going to offer dedicated time on every random platform ther

[HACKERS] 8.0.0beta5 FailedAssertion (Crash) when casting composite types

2004-12-03 Thread kris . shannon
template2=# SELECT version(); version -- PostgreSQL 8.0.0beta5 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.4.2 (Debian 3.4.2-3) (1 row) template2=# CREATE TA

[HACKERS] 1 Hour To RC1 ...

2004-12-03 Thread Marc G. Fournier
Approx ... but, if anyone has anything they want to say before that happens, you have an hour left to "god save your souls" *muhahahaha* Okay, not that bad ... but, just figured I'd give a heads up in case someone was just finishing off something ... Marc G. Fournier Hub.Org Netw

Re: Buildfarm coverage (was Re: [HACKERS] OK, ready for RC1 or Beta6)

2004-12-03 Thread Jim Buttafuoco
Tom/all, I have setup the following running debian linux. MIPS, MIPSEL, ALPHA, PARISC, M68K, ARM, SPARC, I386. I have the build farm running local and I have just started to get the systems registered. I am also willing to aquire other hardware/ operating systems in an effort to give somethi

Re: [HACKERS] OK, ready for RC1 or Beta6

2004-12-03 Thread Andrew Dunstan
Tom Lane wrote: It's too bad the buildfarm reports don't show more details about what CVS pull they're using exactly. Snapshot is the UTC time at which the cvs pull was done. Clients report what files have changed since the last run, and also, in the case of a failure, what files have change

Re: [HACKERS] Error handling in plperl and pltcl

2004-12-03 Thread Thomas Hallgren
Jan Wieck wrote: "as you now suggest"? I don't remember suggesting that. I concluded from your statements that _you_ are against changing Tcl's catch but instead want the savepoint functionality exposed to plain Tcl. So _you_ are against _my_ suggestion because these two are mutually exclusive.

Re: Buildfarm coverage (was Re: [HACKERS] OK, ready for RC1 or Beta6)

2004-12-03 Thread Tom Lane
Peter Eisentraut <[EMAIL PROTECTED]> writes: > Does the build farm turn on all the > compiler options? It really should. I'm looking for > /configure --prefix=SOMEWHERE --enable-thread-safety --with-tcl \ > --with-perl --with-python --with-krb5 --with-pam -with-openssl I was just thinking abo

Re: Buildfarm coverage (was Re: [HACKERS] OK, ready for RC1 or Beta6)

2004-12-03 Thread Kenneth Marshall
On Fri, Dec 03, 2004 at 03:20:48PM -0500, Tom Lane wrote: > "Joshua D. Drake" <[EMAIL PROTECTED]> writes: > > 1. Buildfarm doesn't yet have that many platforms on it. > > It's not as bad as all that. Our current list of supported platforms > (ie, things that got tested last time) is > > AI

Re: Buildfarm coverage (was Re: [HACKERS] OK, ready for RC1 or Beta6)

2004-12-03 Thread Peter Eisentraut
Tom Lane wrote: > Where the buildfarm falls down a bit is on the cross-product > coverage. But I think you're not going to get the cross product > without a call for port reports; there aren't that many people who > are going to offer dedicated time on every random platform there is. Once RC1 is o

Buildfarm coverage (was Re: [HACKERS] OK, ready for RC1 or Beta6)

2004-12-03 Thread Tom Lane
"Joshua D. Drake" <[EMAIL PROTECTED]> writes: > 1. Buildfarm doesn't yet have that many platforms on it. It's not as bad as all that. Our current list of supported platforms (ie, things that got tested last time) is AIX Free/Open/NetBSDcovered by buildfarm HPUX

Re: [HACKERS] Error handling in plperl and pltcl

2004-12-03 Thread Tom Lane
James Robinson <[EMAIL PROTECTED]> writes: > The JDBC interface exposes the savepoint interface, via setSavepoint(), > releaseSavepoint(), and rollback(Savepoint sp) methods on the > Connection, and Thomas's design of PL/Java offers the SPI via mapping > it onto JDBC. Would client-side JDBC als

Re: [HACKERS] Error handling in plperl and pltcl

2004-12-03 Thread James Robinson
On Dec 3, 2004, at 2:04 PM, Jan Wieck wrote: [snip] The point we where coming from was Tom's proposal to wrap each and every single SPI call into its own subtransaction for semantic reasons. My proposal was an improvement to that with respect to performance and IMHO also better matching the sema

[HACKERS] Calling for translation finalization

2004-12-03 Thread Peter Eisentraut
Leading up to the release of PostgreSQL 8.0, the development group has agreed to freeze the message strings, so now is the right time to send in message translations for the 8.0 release. See http://developer.postgresql.org/~petere/nlsinfo/ for information on how to contribute. If there ar

Re: [HACKERS] Error handling in plperl and pltcl

2004-12-03 Thread Tom Lane
Jan Wieck <[EMAIL PROTECTED]> writes: > Your suggestion to expose a plain savepoint interface to the programmer > leads directly to the possiblity to commit a savepoint made by a > sub-function in the caller and vice versa - which if I understood Tom > correctly is what we need to avoid. If we

Re: [HACKERS] OK, ready for RC1 or Beta6

2004-12-03 Thread Tom Lane
Darcy Buskermolen <[EMAIL PROTECTED]> writes: > On December 3, 2004 10:31 am, you wrote: >> 2. There are critical notices on buildfarm for some more popular >> platforms such as Solaris 9 and Open BSD. > The OpenBSD error should be fixed by > http://developer.postgresql.org/cvsweb.cgi/pgsql/src/i

Re: [HACKERS] Error handling in plperl and pltcl

2004-12-03 Thread Jan Wieck
On 12/3/2004 12:23 PM, Thomas Hallgren wrote: Jan Wieck wrote: There is no "try" in Tcl. The syntax is catch { block-of-commands } [variable-name] Catch returns a numeric result, which is 0 if there was no exception thrown inside of the block-of-commands. The interpreter result, which would be th

Re: [HACKERS] OK, ready for RC1 or Beta6

2004-12-03 Thread Darcy Buskermolen
On December 3, 2004 10:31 am, you wrote: > Bruce Momjian wrote: > > Peter Eisentraut wrote: > >>Bruce Momjian wrote: > >>>OK, where are we in the release process? We still have a few open > >>>items, but those can be moved to the TODO list. Do we do RC1 or > >>>Beta6? > >> > >>Considering all the

Re: [HACKERS] OK, ready for RC1 or Beta6

2004-12-03 Thread Marc G. Fournier
On Fri, 3 Dec 2004, Peter Eisentraut wrote: Bruce Momjian wrote: OK, where are we in the release process? We still have a few open items, but those can be moved to the TODO list. Do we do RC1 or Beta6? Considering all the patching that has been going on recently and the fact that we don't have an

Re: [HACKERS] pg_restore --help

2004-12-03 Thread Tom Lane
Peter Eisentraut <[EMAIL PROTECTED]> writes: > Change it right now, and then we'll freeze. :) Done. regards, tom lane ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [HACKERS] OK, ready for RC1 or Beta6

2004-12-03 Thread Joshua D. Drake
Bruce Momjian wrote: Peter Eisentraut wrote: Bruce Momjian wrote: OK, where are we in the release process? We still have a few open items, but those can be moved to the TODO list. Do we do RC1 or Beta6? Considering all the patching that has been going on recently and the fact that we don't have

Re: [HACKERS] pg_restore --help

2004-12-03 Thread Peter Eisentraut
Tom Lane wrote: > Alvaro Herrera <[EMAIL PROTECTED]> writes: > > Do we talk about "output commands" to do things, or directly about > > restoration? I think -O description should be > > -O, --no-owner skip restoration of object ownership > > This seems reasonable, but I wonder whether

Re: [HACKERS] OK, ready for RC1 or Beta6

2004-12-03 Thread Bruce Momjian
Peter Eisentraut wrote: > Bruce Momjian wrote: > > OK, where are we in the release process? We still have a few open > > items, but those can be moved to the TODO list. Do we do RC1 or > > Beta6? > > Considering all the patching that has been going on recently and the > fact that we don't have

Re: [HACKERS] OK, ready for RC1 or Beta6

2004-12-03 Thread Peter Eisentraut
Bruce Momjian wrote: > OK, where are we in the release process? We still have a few open > items, but those can be moved to the TODO list. Do we do RC1 or > Beta6? Considering all the patching that has been going on recently and the fact that we don't have any port reports, I think it's too ear

Re: [HACKERS] pg_restore --help

2004-12-03 Thread Alvaro Herrera
On Fri, Dec 03, 2004 at 12:20:51PM -0500, Tom Lane wrote: > This seems reasonable, but I wonder whether we should hold it for 8.1. > There hasn't been any official declaration that translatable strings > are frozen for 8.0 --- but are we at that point yet? Even if we're > not at hard freeze, mino

Re: [HACKERS] Error handling in plperl and pltcl

2004-12-03 Thread Thomas Hallgren
Jan Wieck wrote: There is no "try" in Tcl. The syntax is catch { block-of-commands } [variable-name] Catch returns a numeric result, which is 0 if there was no exception thrown inside of the block-of-commands. The interpreter result, which would be the exceptions error message in cleartext, is as

Re: [HACKERS] pg_restore --help

2004-12-03 Thread Tom Lane
Alvaro Herrera <[EMAIL PROTECTED]> writes: > Do we talk about "output commands" to do things, or directly about > restoration? I think -O description should be > -O, --no-owner skip restoration of object ownership This seems reasonable, but I wonder whether we should hold it for 8.1.

[HACKERS] OK, ready for RC1 or Beta6

2004-12-03 Thread Bruce Momjian
OK, where are we in the release process? We still have a few open items, but those can be moved to the TODO list. Do we do RC1 or Beta6? -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive,

Re: [PATCHES] [HACKERS] multiline CSV fields

2004-12-03 Thread Bruce Momjian
Patch applied. Thanks. --- Andrew Dunstan wrote: > > > I wrote: > > > > > If it bothers you that much. I'd make a flag, cleared at the start of > > each COPY, and then where we test for CR or LF in CopyAttributeOutCSV,

[HACKERS] Port report--Linux/sparc32

2004-12-03 Thread Doug McNaught
I just compiled 8.0beta5 on my old Sparc 5. All tests passed. This is running Debian 3.0 with a 2.2.20 kernel. Sure took a long time. :) I can test on an ia32/RedHat 6.2 machine if that would be helpful. -Doug ---(end of broadcast)--- TIP 2: y

[HACKERS] pg_restore --help

2004-12-03 Thread Alvaro Herrera
People, In pg_restore --help I see this: -O, --no-owner do not output commands to set object ownership [...] -x, --no-privileges skip restoration of access privileges (grant/revoke) Do we talk about "output commands" to do things, or directly about restoration? I think -O de

Re: [HACKERS] Who's in charge of torrents? [was: Easy way to download all .torrents]

2004-12-03 Thread David Fetter
On Thu, Dec 02, 2004 at 08:34:11PM -0600, Jim C. Nasby wrote: > I've tried emailling David Fetter to no avail; anyone know who's in > charge of the torrents or anyone who can answer my original > question? I'm in charge, and re: your original question, perhaps some creative use of wget could help.

Re: [HACKERS] pg_restore --help

2004-12-03 Thread Alvaro Herrera
On Fri, Dec 03, 2004 at 01:35:55PM -0300, Alvaro Herrera wrote: > In pg_restore --help I see this: > > -O, --no-owner do not output commands to set object ownership > [...] > -x, --no-privileges skip restoration of access privileges > (grant/revoke) Sorry, of course the probl

Re: [HACKERS] Error handling in plperl and pltcl

2004-12-03 Thread Jan Wieck
On 12/2/2004 3:18 AM, Thomas Hallgren wrote: Jan, ... plus that the catch-nesting automatically represents the subtransaction nesting. I can't really see any reason why those two should not be bound together. Does anybody? That depends on what you mean. As a stop-gap solution, cerntanly. But in

Re: [HACKERS] Adding a suffix array index

2004-12-03 Thread Tom Lane
Troels Arvin <[EMAIL PROTECTED]> writes: > How much of[1] is still the case today? > Reference 1: > Stonebraker & Olson: Large Object Support in POSTGRES (1993) > http://epoch.cs.berkeley.edu:8000/postgres/papers/S2K-93-30.pdf Probably almost none of it ... the only thing I know about the Berkeley

Re: [HACKERS] Adding a suffix array index

2004-12-03 Thread Troels Arvin
On Sun, 28 Nov 2004 17:53:38 -0500, Tom Lane wrote: >> But is it cheaper, IO-wise to "jump" around in an index than to go back >> and forth between index and tuple blocks? > > Perhaps not --- but why would you be "jumping around"? Wouldn't the > needed info appear in consecutive locations in the

Re: [HACKERS] 8.0RC1 tomorrow

2004-12-03 Thread Tom Lane
Bruce Momjian <[EMAIL PROTECTED]> writes: > TODO item? Sure: * ANALYZE should record a pg_statistic entry for an all-NULL column regards, tom lane ---(end of broadcast)--- TIP 7: don't forget to increase your free space map

Re: [HACKERS] Ready for RC1

2004-12-03 Thread Jan Wieck
On 12/2/2004 8:16 PM, Bruce Momjian wrote: Tom Lane wrote: Bruce Momjian <[EMAIL PROTECTED]> writes: > One more issue. Until we start RC, patches that are bug fixes will > continue to be applied. Do we want that? By going RC we are basically > saying we need to focus on docs and packaging and we