Re: [HACKERS] Regression test failures

2004-08-27 Thread Stefan Kaltenbrunner
Tom Lane wrote: Bruce Momjian <[EMAIL PROTECTED]> writes: I am still seeing random regression test failures on my SMP BSD/OS machine. It basically happens when doing 'gmake check'. I have tried running repeated tests and can't get it to reproduce, but when checking patches it has happened perhaps

Re: [HACKERS] FYI: 8.0beta2 on Monday

2004-08-27 Thread Marc G. Fournier
On Fri, 27 Aug 2004, Tom Lane wrote: "Marc G. Fournier" <[EMAIL PROTECTED]> writes: If you have stuff on your list 'to fix', do you want to put off beta2 a few extra days, so that its that much cleaner for testers? Say, put it to Wednesday so that you aren't sapping your weekend time? [ shrug... ]

Re: [HACKERS] Contrib -- PostgreSQL shared variables

2004-08-27 Thread pgsql
> I don't see how this is different from "CREATE TABLE shared_variables > (name > VARCHAR PRIMARY KEY, value VARCHAR)" and > inserting/updating/deleting/selecting from that. Perhaps these are > per-session shared variables? IN which case, what is the utility if > sharing > them across shared memor

Re: [HACKERS] FYI: 8.0beta2 on Monday

2004-08-27 Thread Tom Lane
"Marc G. Fournier" <[EMAIL PROTECTED]> writes: > If you have stuff on your list 'to fix', do you want to put off beta2 a > few extra days, so that its that much cleaner for testers? Say, put it to > Wednesday so that you aren't sapping your weekend time? [ shrug... ] There will always be stuff

Re: [HACKERS] FYI: 8.0beta2 on Monday

2004-08-27 Thread Marc G. Fournier
On Fri, 27 Aug 2004, Tom Lane wrote: Philip Warner <[EMAIL PROTECTED]> writes: At 03:25 AM 28/08/2004, Tom Lane wrote: If you've got any "must fix" issues, please get 'em in over the weekend. Is the 'magic_tablespace' variable going to be there? Likely not :-( ... I've just found about three issue

Re: [HACKERS] FYI: 8.0beta2 on Monday

2004-08-27 Thread Tom Lane
Philip Warner <[EMAIL PROTECTED]> writes: > At 03:25 AM 28/08/2004, Tom Lane wrote: >> If you've got any "must fix" issues, please get 'em in over the weekend. > Is the 'magic_tablespace' variable going to be there? Likely not :-( ... I've just found about three issues I need to fix, plus there's

Re: [HACKERS] FYI: 8.0beta2 on Monday

2004-08-27 Thread Philip Warner
At 03:25 AM 28/08/2004, Tom Lane wrote: If you've got any "must fix" issues, please get 'em in over the weekend. Is the 'magic_tablespace' variable going to be there? Philip Warner| __---_ Albatross Consult

Re: [HACKERS] psql questions: SQL, progname, copyright dates

2004-08-27 Thread Jon Jensen
On Fri, 27 Aug 2004, Greg Sabino Mullane wrote: > 3. I'd like to rearrange the ORDER BY on some objects to show > user-created objects before system ones. Currently, if I create > a new function and do a \df, I have to wade through all the > system functions in the pg_catalog schema before seeing

Re: [HACKERS] Contrib -- PostgreSQL shared variables

2004-08-27 Thread Jonathan Gardner
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Wednesday 25 August 2004 02:15 pm, [EMAIL PROTECTED] wrote: > This is a first pass on a simple shared memory variable system for > PostgreSQL. I would appriciate anyone interested in this functionality to > rip it apart. > > It basically adds this f

[HACKERS] psql questions: SQL, progname, copyright dates

2004-08-27 Thread Greg Sabino Mullane
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I was looking through the code of psql and had a few questions: 1. Do we want to use quote_ident on object names? Ideally, column names with a space in them, for example, should be surrounded by double quotes. 2. There is a disconnect between w

Re: [HACKERS] Regression test failures

2004-08-27 Thread Tom Lane
Bruce Momjian <[EMAIL PROTECTED]> writes: > I am still seeing random regression test failures on my SMP BSD/OS > machine. It basically happens when doing 'gmake check'. > I have tried running repeated tests and can't get it to reproduce, but > when checking patches it has happened perhaps once a

Re: [HACKERS] FYI: 8.0beta2 on Monday

2004-08-27 Thread Gaetano Mendola
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Tom Lane wrote: | Just so you know --- core has agreed that it's about time for beta2. | If you've got any "must fix" issues, please get 'em in over the weekend. | Are you going to insert the SetQuerySnapshot between conmmands in a plpgsql function ? Re

Re: [HACKERS] FYI: 8.0beta2 on Monday

2004-08-27 Thread Dave Page
-Original Message- From: [EMAIL PROTECTED] on behalf of Magnus Hagander Sent: Fri 8/27/2004 7:17 PM To: Tom Lane; [EMAIL PROTECTED] Subject: Re: [HACKERS] FYI: 8.0beta2 on Monday > >Just so you know --- core has agreed that it's about time for beta2. > >If you've got any "must fix" iss

Re: [HACKERS] FYI: 8.0beta2 on Monday

2004-08-27 Thread Tom Lane
"Magnus Hagander" <[EMAIL PROTECTED]> writes: > The kill(0) patch from Dave for win32 is much needed (assuming it fixes > the issue. Unfortunatly Ive been swamped the past couple of weeks and > not able to do much pg). I don't see it on the unapplied patches list, > but it's a trivial patch so it s

[HACKERS] DCO and postgresql

2004-08-27 Thread Gaetano Mendola
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi all, I was reading this two articles: http://www.osdl.org/newsroom/press_releases/2004/2004_05_24_beaverton.html http://www.osdl.org/newsroom/press_releases/2004/2004_05_24_dco.html and I'm wondering if is a good idea apply a similar process to postg

Re: [HACKERS] FYI: 8.0beta2 on Monday

2004-08-27 Thread Magnus Hagander
>Just so you know --- core has agreed that it's about time for beta2. >If you've got any "must fix" issues, please get 'em in over >the weekend. The kill(0) patch from Dave for win32 is much needed (assuming it fixes the issue. Unfortunatly Ive been swamped the past couple of weeks and not able t

Re: [HACKERS] PANIC: right sibling's left-link doesn't match

2004-08-27 Thread Marc G. Fournier
On Fri, 27 Aug 2004, Tom Lane wrote: "Marc G. Fournier" <[EMAIL PROTECTED]> writes: The above error refers to a btree index, correct? Do/will a REINDEX fix that, or do I have to physically DROP/CREATE the INDEX? REINDEX should fix it --- but how did it get that way? For lack of a better way of say

Re: [HACKERS] PANIC: right sibling's left-link doesn't match

2004-08-27 Thread Tom Lane
"Marc G. Fournier" <[EMAIL PROTECTED]> writes: > The above error refers to a btree index, correct? Do/will a REINDEX fix > that, or do I have to physically DROP/CREATE the INDEX? REINDEX should fix it --- but how did it get that way? regards, tom lane --

[HACKERS] FYI: 8.0beta2 on Monday

2004-08-27 Thread Tom Lane
Just so you know --- core has agreed that it's about time for beta2. If you've got any "must fix" issues, please get 'em in over the weekend. regards, tom lane ---(end of broadcast)--- TIP 1: subscribe and unsubscribe command

[HACKERS] PANIC: right sibling's left-link doesn't match

2004-08-27 Thread Marc G. Fournier
The above error refers to a btree index, correct? Do/will a REINDEX fix that, or do I have to physically DROP/CREATE the INDEX? This is a 7.4 database, if that matters ... Thanks ... Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email: [EMAIL PROTECTED]

Re: [HACKERS] [ppa-cvs] CVS: webdb/lang/recoded

2004-08-27 Thread Robert Treat
setting reply-to to ppa-dev since I am pretty sure thats the list this was meant for :-) Chris, I don't have strong feelings one way or the other, but you do have the option to vacuum full, so it could lock the table... Robert Treat On Thu, 2004-08-26 at 21:16, Christopher Kings-Lynne wrote: >

Re: [HACKERS] contrib/start-scripts/linux on Debian

2004-08-27 Thread Thomas F . O'Connell
Sure. I didn't know there was a Debian start script. Because we frequently keep up with the latest changes in postgres (which we regularly use), I always build postgres from source. But that would be a perfectly acceptable solution. -tfo On Aug 27, 2004, at 12:45 AM, Peter Eisentraut wrote: Tho