[HACKERS] RC2 tag'd and bundled ...

2003-11-10 Thread Marc G. Fournier
Should be on the mirrors now, will announce it this evening ... things looked to build clean, just would like a second opinion on it ... ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresq

Re: [pgsql-www] [HACKERS] Changes to Contributor List

2003-11-10 Thread Marc G. Fournier
On Mon, 10 Nov 2003, Robert Treat wrote: > On Fri, 2003-11-07 at 13:51, Josh Berkus wrote: > > > really the most important thing here is that we get some movement on the > > > site in order to ditch the old VM the site lives on and get it on our new > > > web VM. > > > > On techdocs? What part

Re: [pgsql-www] [HACKERS] Changes to Contributor List

2003-11-10 Thread Marc G. Fournier
On Mon, 10 Nov 2003, Josh Berkus wrote: > Justin, > > > From memory, the OpenOffice.org surveys still run from the techdocs > > virtual machine too. That may or may not be the case these days, I just > > don't remember. > > Really? I thought that they were running from one of Sun's machines.

Re: [pgsql-www] [HACKERS] Changes to Contributor List

2003-11-10 Thread Marc G. Fournier
In fact: http://oosurvey.gratismania.ro/stats On Mon, 10 Nov 2003, Marc G. Fournier wrote: > > > On Mon, 10 Nov 2003, Josh Berkus wrote: > > > Justin, > > > > > From memory, the OpenOffice.org surveys still run from the techdocs > > > virtual machine t

[HACKERS] [7.3.x] function does not exist ... ?

2003-11-10 Thread Marc G. Fournier
'k, this doesn't look right, but it could be that I'm overlooking something ... The function I created: CREATE FUNCTION month_trunc (timestamp without time zone) RETURNS timestamp without time zone AS 'SELECT date_trunc(''month'', $1 )' LANGUAGE sql IMMUTABLE; The query that fails: a

Re: [HACKERS] [7.3.x] function does not exist ... ?

2003-11-10 Thread Marc G. Fournier
On Mon, 10 Nov 2003, Gaetano Mendola wrote: > Marc G. Fournier wrote: > > > 'k, this doesn't look right, but it could be that I'm overlooking > > something ... > > > > The function I created: > > > > CREATE FUNCTION month_trunc (timesta

Re: [HACKERS] bugzilla (Was: What do you want me to do?)

2003-11-11 Thread Marc G. Fournier
On Tue, 11 Nov 2003, Shridhar Daithankar wrote: > --- > Hello, > > My name is <> and I work with postgresql group. Recently we/postgresql > advocay/general group have decided to form a group of people who would help > other projects w.r.t postgresql. > > So feel free to ask me questions.

Re: [HACKERS] About the partial tarballs

2003-11-11 Thread Marc G. Fournier
On Tue, 11 Nov 2003, Peter Eisentraut wrote: > Do we have any data on how many people download the partial tarballs > (-base, -opt, etc.)? I have a feeling that more people are confused by > them than use them. on ftp.postgresql.org itself, since June 4th: 2812 /var/spool/ftp/pub/source/v7.3.

Re: [HACKERS] About the partial tarballs

2003-11-11 Thread Marc G. Fournier
On Tue, 11 Nov 2003, Peter Eisentraut wrote: > Marc G. Fournier writes: > > > > Do we have any data on how many people download the partial tarballs > > > (-base, -opt, etc.)? I have a feeling that more people are confused by > > > them than use them. >

Re: [HACKERS] About the partial tarballs

2003-11-11 Thread Marc G. Fournier
On Wed, 12 Nov 2003, Marko Karppinen wrote: > I agree that the partial tarballs can confuse an ftp user, though. I > think a good solution to this would be to put them one level deeper, > into a subfolder. The full tarball would then be the only thing a casual > user would encounter, but the sou

Re: [HACKERS] About the partial tarballs

2003-11-11 Thread Marc G. Fournier
On Tue, 11 Nov 2003, Nigel J. Andrews wrote: > > On Tue, 11 Nov 2003, Marc G. Fournier wrote: > > ftp://ftp.postgresql.org/pub/README.dist-split > > > > to reduce the confusion, that would be great. I've just symlink'd it into > > the source directori

Re: [HACKERS] About the partial tarballs

2003-11-11 Thread Marc G. Fournier
On Wed, 12 Nov 2003, Christopher Kings-Lynne wrote: > > Even if they weren't useful for anything else, I think there's value in the > > developers having to consider what is optional and what is not. This need > > for constant review probably reduces the chance of bloat, over time even > > in th

[HACKERS] PostgreSQL v7.4 Release Candidate 2

2003-11-10 Thread Marc G. Fournier
We have just packaged up our second Release Candidate for v7.4, with the hopes of producing a full release next week. A full ChangeLog is available at: ftp://ftp.postgresql.org/pub/sources/v7.4/ChangeLog.RC1.to.RC2 But, one of the highlights is that support for tcl8.0.x has been re-int

Re: [HACKERS] rpm support for 7.4 and beyond

2003-11-12 Thread Marc G. Fournier
On Wed, 12 Nov 2003, Lamar Owen wrote: > The biggest issue is going to be 'will it build' on those releases. > The tcl version deal (with tcl prior to 8.1) Tom applied a patch so that the build will continue to work on 8.0.x ... or is this some other issue? ---(end of

Re: [HACKERS] rpm support for 7.4 and beyond

2003-11-13 Thread Marc G. Fournier
On Thu, 13 Nov 2003, Lamar Owen wrote: > On Wednesday 12 November 2003 11:51 pm, Marc G. Fournier wrote: > > On Wed, 12 Nov 2003, Lamar Owen wrote: > > > The biggest issue is going to be 'will it build' on those releases. > > > The tcl version deal (with

Re: [CORE] [HACKERS] 7.4RC2 regression failur and not running stats

2003-11-14 Thread Marc G. Fournier
On Fri, 14 Nov 2003, Josh Berkus wrote: > Tom, > > > Too bad we didn't figure this out yesterday. We are now in code freeze > > for 7.4 release, and I'm hesitant to apply a fix for what is arguably a > > broken platform. Core guys, time for a vote ... do we fix, or hold this > > for 7.4.1? > >

Re: [HACKERS] oh dear ...

2003-11-14 Thread Marc G. Fournier
On Fri, 14 Nov 2003, Tom Lane wrote: > I said: > > This worked in 7.3: > > regression=# select '1999-jan-08'::date; > > ERROR: date/time field value out of range: "1999-jan-08" > > HINT: Perhaps you need a different "datestyle" setting. > > > Setting DateStyle to YMD doesn't help, and in any c

Re: [HACKERS] oh dear ...

2003-11-14 Thread Marc G. Fournier
On Fri, 14 Nov 2003, Bruce Momjian wrote: > Tom Lane wrote: > > I said: > > > This worked in 7.3: > > > regression=# select '1999-jan-08'::date; > > > ERROR: date/time field value out of range: "1999-jan-08" > > > HINT: Perhaps you need a different "datestyle" setting. > > > > > Setting DateSt

Re: [HACKERS] oh dear ...

2003-11-14 Thread Marc G. Fournier
On Fri, 14 Nov 2003, Andrew Dunstan wrote: > I'm confused. My understanding from what Tom said is that it affects all > configurations. the stats collector problem, from what I've seen through this list, affects Solaris, and only some Solaris configuration .. ---(end o

Re: [HACKERS] oh dear ...

2003-11-14 Thread Marc G. Fournier
On Fri, 14 Nov 2003, Tom Lane wrote: > Christopher Kings-Lynne <[EMAIL PROTECTED]> writes: > > Shouldn't you also add a regression test to catch this in the future? > > Yes, I absolutely plan to stick some regression test additions into HEAD. > There's not a need for such changes in the 7.4 bran

Re: [HACKERS] oh dear ...

2003-11-14 Thread Marc G. Fournier
My bad, confused two different issues in one thread :( On Fri, 14 Nov 2003, Joe Conway wrote: > Marc G. Fournier wrote: > > > > On Fri, 14 Nov 2003, Andrew Dunstan wrote: > >>I'm confused. My understanding from what Tom said is that it affects all > >>confi

[HACKERS] We're finally there ...

2003-11-16 Thread Marc G. Fournier
'k, I just tag'd REL7_4 and built the bundles ... the files are available under ftp://ftp.postgresql.org/pub/source/v7.4beta, and I've open'd up the ftp server there to 100 connections so that ppl can get in and test it ... It is 6:15pm AST here right now ... at ~9pm, I will move those files to t

[HACKERS] Release now live ...

2003-11-16 Thread Marc G. Fournier
'k, I just moved the release into the /pub/source/v7.4 directory from the v7.4beta one ... RC2 is still in place, so that I don't break a bunch of links ... tomorrow night, I'll remove the RC2 ... ---(end of broadcast)--- TIP 9: the planner will i

Re: [HACKERS] Release cycle length

2003-11-17 Thread Marc G. Fournier
On Tue, 18 Nov 2003, Peter Eisentraut wrote: > The time from release 7.3 to release 7.4 was 355 days, an all-time high. > We really need to shorten that. We already have a number of significant > improvements in 7.5 now, and several good ones coming up in the next few > weeks. We cannot let peop

Re: [HACKERS] [pgsql-advocacy] Not 7.5, but 8.0 ?

2003-11-17 Thread Marc G. Fournier
On Mon, 17 Nov 2003, Josh Berkus wrote: > Given all that, don't people think it's time to jump to 8.0? Seems like > even 7.4 is hardly recognizable as the same database as 7.0. Discussion like this tends to be more for just before beta, once we have an idea what actually made it in :) You be pu

Re: [HACKERS] Release cycle length

2003-11-17 Thread Marc G. Fournier
On Tue, 18 Nov 2003, Peter Eisentraut wrote: > Marc G. Fournier writes: > > > That is the usual goal *nod* Same goal we try for each release, and never > > quite seem to get there ... we'll try 'yet again' with 7.5 though, as we > > always do :) > >

Re: [HACKERS] Release cycle length

2003-11-17 Thread Marc G. Fournier
Just did a quick search on archives, and the original plan was for a release in mid-2003, which means the beta would have been *at least* a month before that, so beta starting around May: http://archives.postgresql.org/pgsql-hackers/2002-11/msg00975.php On Mon, 17 Nov 2003, Marc G. Fournier

Re: [HACKERS] Release cycle length

2003-11-17 Thread Marc G. Fournier
On Tue, 18 Nov 2003, Christopher Kings-Lynne wrote: > > Everyone on -hackers should have been aware of it, as its always > > discussed at the end of the previous release cycle ... and I don't think > > we've hit a release cycle yet that has actually stayed in the 4 month > > period :( Someone is

Re: [HACKERS] Release cycle length

2003-11-17 Thread Marc G. Fournier
On Tue, 18 Nov 2003, Peter Eisentraut wrote: > Marc G. Fournier writes: > > > Right now, I believe we are looking at an April 1st beta, and a May 1st > > related ... those are, as always, *tentative* dates that will become more > > fine-tuned as those dates become neare

Re: [HACKERS] Release cycle length

2003-11-17 Thread Marc G. Fournier
On Mon, 17 Nov 2003, Neil Conway wrote: > That said, I'm not really sure how we can make better use of the beta > period. One obvious improvement would be making the beta announcements > more visible: the obscurity of the beta process on www.postgresql.org > for 7.4 was pretty ridiculous. Does an

Re: [HACKERS] Release cycle length

2003-11-17 Thread Marc G. Fournier
On Tue, 18 Nov 2003, Peter Eisentraut wrote: > 0. As you say, make it known to the public. Have people test their >in-development applications using a beta. and how do you propose we do that? I think this is the hard part ... other then the first beta, I post a note out to -announce and -ge

Re: [HACKERS] Release cycle length

2003-11-17 Thread Marc G. Fournier
On Mon, 17 Nov 2003, Larry Rosenman wrote: > > I try to test stuff fairly frequently, and this time I didn't know when, > exactly, SCO would make the release of the updated compiler. And there was no way you could predict that your contact there would take off on holidays either :(

[HACKERS] So as not to break it for anyone ...

2003-11-17 Thread Marc G. Fournier
l.org/pub/src/[167].* vs ftp://ftp.postgresql.org/pub/source/v[167].* Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email: [EMAIL PROTECTED] Yahoo!: yscrappy ICQ: 7615664 ---(end of broadcast)-

Re: [HACKERS] Release cycle length

2003-11-17 Thread Marc G. Fournier
On Tue, 18 Nov 2003, Neil Conway wrote: > "Marc G. Fournier" <[EMAIL PROTECTED]> writes: > > On Tue, 18 Nov 2003, Peter Eisentraut wrote: > > > >> 0. As you say, make it known to the public. Have people test their > >>in-development applicat

Re: [HACKERS] Is there going to be a port to Solaris 9 x86 in the

2003-11-18 Thread Marc G. Fournier
On Tue, 18 Nov 2003, Christoper Smiga wrote: > All: > > Does anyone know if there is going to be a port to Solaris 9 x86 in the > near future. What is the decission to develop on this platform since Sun > is pushing Solaris x86 harder than ever. Doesn't it work? I've run on Solaris 8 x86 extensi

Re: [pgsql-www] [HACKERS] Release cycle length

2003-11-18 Thread Marc G. Fournier
On Tue, 18 Nov 2003, Andrew Dunstan wrote: > Josh Berkus wrote: > > >Guys, > > > >I agree with Neil ... it's not the length of the development part of the > >cycle, it's the length of the beta testing. > > > >I do think an online bug tracker (bugzilla or whatever) would help. I also > >think tha

Re: [pgsql-www] [HACKERS] Release cycle length

2003-11-18 Thread Marc G. Fournier
ey just use > the CVS version? We do do nightly builds ... have for years now ... Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email: [EMAIL PROTECTED] Yahoo!: yscrappy ICQ: 7615664 ---(end of broadcast)---

Re: [HACKERS] Commercial binary support?

2003-11-19 Thread Marc G. Fournier
on't either, nor do we worry about specific platforms ... Marc G. Fournier PostgreSQL, Inc (http://www.pgsql.com) Email: [EMAIL PROTECTED] Yahoo!: yscrappy ICQ: 7615664 ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [HACKERS] 4 Clause license?

2003-11-20 Thread Marc G. Fournier
nobody else large enough to bother with ... its going to be interesting to see :) ---- Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email: [EMAIL PROTECTED] Yahoo!: yscrappy ICQ: 7615664 ---(end of bro

Re: [HACKERS] 4 Clause license?

2003-11-20 Thread Marc G. Fournier
of the stack) ... > > Marc G. Fournier wrote: > > >On Thu, 20 Nov 2003, Andrew Dunstan wrote: > > > > > > > >>Of course, now that SCO is claiming ownership of BSD code . > >> > >> > >> > > > >Interesting thread t

[HACKERS] [7.4] statistics collector: Protocol not supported

2003-11-22 Thread Marc G. Fournier
/usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data -S (postgres) pgsql 60121 0.0 0.1 4908 3316 ?? SJ3:32AM 0:00.00 postmaster: stats buffer process(postgres) pgsql 60123 0.0 0.1 3964 3364 ?? SJ3:32AM 0:00.00 postmaster: stats collector process(postgres) ---- Marc G

Re: [HACKERS] [7.4] statistics collector: Protocol not supported

2003-11-23 Thread Marc G. Fournier
On Sun, 23 Nov 2003, Tom Lane wrote: > Kurt Roeckx <[EMAIL PROTECTED]> writes: > > On Sat, Nov 22, 2003 at 11:32:18PM -0400, Marc G. Fournier wrote: > >> I suspect it might be because I'm running in a jail'd environment, but > >> what should I be lookin

Re: [HACKERS] Executable files in CVS

2003-11-23 Thread Marc G. Fournier
ke perl scripts. > > Sure, but couldn't we automatically turn off the write bits? Just curious, but what do the write bits harm? Everyone that has access to that VM has acccess to CVSROOT, either through CVS or directly ... Marc G. Fournier Hub.Org Networking Services (http://

Re: [HACKERS] 7.5 Plans

2003-11-26 Thread Marc G. Fournier
ng part of the manual? Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email: [EMAIL PROTECTED] Yahoo!: yscrappy ICQ: 7615664 ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [HACKERS] 7.5 Plans

2003-11-26 Thread Marc G. Fournier
a checkout and this change is made, will he have problems committing? Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email: [EMAIL PROTECTED] Yahoo!: yscrappy ICQ: 7615664 ---(end of broadcast)---

[HACKERS] $Id$ -> $PostgreSQL$ Change

2003-11-26 Thread Marc G. Fournier
Based on discussions on -hackers, and baring any objections betwen now and then, I'm going to go through all files in CVS and change: $Id$ -> $PostgreSQL$ I will do this the evening of Friday, November 29th ... ---- Marc G. Fournier Hub.Org Networking Servic

Re: [HACKERS] about explain analyze

2003-11-28 Thread Marc G. Fournier
never noticed such a > large discrepancy myself. Actually, I'm noticing similar "problems" with v7.4 ... "EXPLAIN ANALYZE" seems to be showing some *very* high ms for execution time, but if you run the actual query, it doesn't seem to take even 1/10th the ti

Re: [HACKERS] about explain analyze

2003-11-28 Thread Marc G. Fournier
On Fri, 28 Nov 2003, Tom Lane wrote: > "Marc G. Fournier" <[EMAIL PROTECTED]> writes: > > Actually, I'm noticing similar "problems" with v7.4 ... "EXPLAIN ANALYZE" > > seems to be showing some *very* high ms for execution time, but if you

Re: [HACKERS] $Id$ -> $PostgreSQL$ Change

2003-11-28 Thread Marc G. Fournier
'K, where do you find docs on the options file? there is nothing on it, that I can find, in 'info cvs'? Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email: [EMAIL PROTECTED] Yahoo!: yscrappy ICQ: 7615664 --

Re: [HACKERS] about explain analyze

2003-11-28 Thread Marc G. Fournier
None that I've heard of ... Sean? Tom, any way of writing a quite test C program for this? Something to 'simulate' the same thing, but without having to build the whole postmaster? On Fri, 28 Nov 2003, Tom Lane wrote: > "Marc G. Fournier" <[EMAIL PROTECTED]&g

Re: [HACKERS] $Id$ -> $PostgreSQL$ Change

2003-11-28 Thread Marc G. Fournier
On Thu, 27 Nov 2003, Rod Taylor wrote: > On Thu, 2003-11-27 at 00:50, Marc G. Fournier wrote: > > Based on discussions on -hackers, and baring any objections betwen now and > > then, I'm going to go through all files in CVS and change: > > > > $Id$ -> $Pos

Re: [HACKERS] about explain analyze

2003-11-28 Thread Marc G. Fournier
On Fri, 28 Nov 2003, Tom Lane wrote: > "Marc G. Fournier" <[EMAIL PROTECTED]> writes: > > did you happen to take a look at the other set of queries I sent you, that > > were showing 39k and 41k explain results? > > You mean this one? Yup ... > > tim

Re: [HACKERS] about explain analyze

2003-11-28 Thread Marc G. Fournier
ld be proud that we've gotten the price of > a seqscan down to the point where a couple of gettimeofday() calls per > row are dominating the runtime. > > regards, tom lane > Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Em

Re: [HACKERS] gettimeofday() goes backwards on FreeBSD 4.9

2003-11-28 Thread Marc G. Fournier
On Fri, 28 Nov 2003, Darcy Buskermolen wrote: > I've been running this code on a pair of FreeBSD (i386) boxen, for some time > now, one of which is a 4.8-STABLE, the other is a 5.2-BETA. > > In 10 minutes of execution the 4.8 box has only shown the following: > > out of order tv_sec: 1070063393 11

Re: [HACKERS] gettimeofday() goes backwards on FreeBSD 4.9

2003-11-28 Thread Marc G. Fournier
On Fri, 28 Nov 2003, Tom Lane wrote: > Could it be a hardware problem on Marc's box? Or specific to some other > aspect of that installation (Marc, is pgsql74.hub.org multi-CPU, for > example?) All the servers are SMP ... pgsql74 is on a Dual-Xeon ... Marc G. Fournier

Re: [HACKERS] gettimeofday() goes backwards on FreeBSD 4.9

2003-11-28 Thread Marc G. Fournier
On Fri, 28 Nov 2003, Tom Lane wrote: > "Marc G. Fournier" <[EMAIL PROTECTED]> writes: > > I'm suspecting that the issue is amplified by load on the server itself > > That would fit right in with my idea that the failure occurs when the > process loses its

Re: [HACKERS] gettimeofday() goes backwards on FreeBSD 4.9

2003-11-28 Thread Marc G. Fournier
On Fri, 28 Nov 2003, Marc G. Fournier wrote: > On Fri, 28 Nov 2003, Tom Lane wrote: > > > "Marc G. Fournier" <[EMAIL PROTECTED]> writes: > > > I'm suspecting that the issue is amplified by load on the server itself > > > > That would fit

Re: [HACKERS] gettimeofday() goes backwards on FreeBSD 4.9

2003-11-28 Thread Marc G. Fournier
On Fri, 28 Nov 2003, Tom Lane wrote: > "Marc G. Fournier" <[EMAIL PROTECTED]> writes: > > Just got my first response on this, and, in fact, this is 'acceptable > > behaviour' to a certain extent ... there is a kernel tuneable called > > kern.ti

Re: [HACKERS] gettimeofday() goes backwards on FreeBSD 4.9

2003-11-28 Thread Marc G. Fournier
30 minutes. what is kern.timecounter.method set to? ---- Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email: [EMAIL PROTECTED] Yahoo!: yscrappy ICQ: 7615664 ---(end of broadcast)--- TI

Re: [HACKERS] gettimeofday() goes backwards on FreeBSD 4.9

2003-11-28 Thread Marc G. Fournier
On Fri, 28 Nov 2003, Neil Conway wrote: > "Marc G. Fournier" <[EMAIL PROTECTED]> writes: > > On Fri, 28 Nov 2003, Neil Conway wrote: > >> $ uname -a > >> FreeBSD home.samurai.com 4.9-RELEASE [...] > > > > what is kern.timecoun

[HACKERS] 7.3.5 to be released this week ...

2003-11-29 Thread Marc G. Fournier
Bruce is going to do whatever magic he needs to on Tuesday, after while I'll bundle it up for testing (at which point in time Peter should point out any oops I happen to have made, no after, eh? *evil grin*) ... then we'll do an announce of its availability on Wednesday ... ---- Marc G

Re: [HACKERS] $Id$ -> $PostgreSQL$ Change

2003-11-29 Thread Marc G. Fournier
Assuming I didn't miss any files, this is now complete ... I grep'd for both $Header: and $Id:, and appear to have gotten them all ... On Fri, 28 Nov 2003, Marc G. Fournier wrote: > On Thu, 27 Nov 2003, Rod Taylor wrote: > > > On Thu, 2003-11-27 at 00:50, Marc G. Fournier

Re: [HACKERS] $Id$ -> $PostgreSQL$ Change

2003-11-29 Thread Marc G. Fournier
k, I see why ... fixing right now ... On Sat, 29 Nov 2003, Tom Lane wrote: > "Marc G. Fournier" <[EMAIL PROTECTED]> writes: > > Assuming I didn't miss any files, this is now complete ... I grep'd for > > both $Header: and $Id:, and appear to have gotten

Re: [HACKERS] $Id$ -> $PostgreSQL$ Change

2003-11-29 Thread Marc G. Fournier
L 'K, changes are made, including the above ... Let me know if I missed anything ... Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email: [EMAIL PROTECTED] Yahoo!: yscrappy ICQ: 7615664 ---(end of broadcast)--

[HACKERS] Updated code to test gettimeofday() ...

2003-11-29 Thread Marc G. Fournier
curtime.tv_sec, curtime.tv_usec, prevtime.tv_sec, prevtime.tv_usec); } last = now; prevtime = curtime; } return 0; } Marc G. Fournier Hub.Org Networking Services (http://www.h

Re: [HACKERS] request for feedback - read-only GUC variables,

2003-12-02 Thread Marc G. Fournier
On Tue, 2 Dec 2003, Joe Conway wrote: > We (mostly Bruce, Tom, Peter, and I) have been having a discussion on > the PATCHES list regarding some new functionality related to read-only > GUC variables. The net result is pasted at the bottom of this post. Here > is a link to the discussion: > http://

[HACKERS] 7.3.5 bundled ...

2003-12-02 Thread Marc G. Fournier
Please take a quick peak at it ... ftp://ftp.postgresql.org/pub/source/v7.3.5 Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email: [EMAIL PROTECTED] Yahoo!: yscrappy ICQ: 7615664 ---(end of broadcast

Re: [HACKERS] Minor (very) feature request...

2003-12-04 Thread Marc G. Fournier
ks! > -- > Steve Wampler -- [EMAIL PROTECTED] > The gods that smiled on your birth are now laughing out loud. > > ---(end of broadcast)------- > TIP 4: Don't 'kill -9' the postmaster > Marc G. Fournier

[HACKERS] 7.4.1 looking good for Wednesday?

2003-12-05 Thread Marc G. Fournier
As Tom mentioned previous, we are aiming for 7.4.1 on Wednesday of next week ... is anyone sitting on anything that they feel *just has to* be in it? Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email: [EMAIL PROTECTED] Yahoo!: yscrappy

[HACKERS] 7.4.1 ... slight change of scheduale ...

2003-12-05 Thread Marc G. Fournier
To accomodate ppls travel scheduales, we are going to move the 7.4.1 release up to Monday, *unless* there is a report before then about something that needs to be fixed first ... we know of nothing outstanding right now ... This means it will be tag'd/bundled on Sunday ... M

Re: [HACKERS] 7.4.1 ... slight change of scheduale ...

2003-12-05 Thread Marc G. Fournier
On Fri, 5 Dec 2003, Peter Eisentraut wrote: > Marc G. Fournier writes: > > > To accomodate ppls travel scheduales, we are going to move the 7.4.1 > > release up to Monday, *unless* there is a report before then about > > something that needs to be fixed first ... we kno

Re: [HACKERS] 7.4.1 ... slight change of scheduale ...

2003-12-05 Thread Marc G. Fournier
On Sat, 6 Dec 2003, Peter Eisentraut wrote: > Marc G. Fournier wrote: > > > A bug in the information schema concerning the bit types must be > > > fixed. > > > > Does anyone have a patch for this? > > I suppose not, but it's being worked on. Is tha

Re: [HACKERS] [COMMITTERS] pgsql-server/src/bin/initdb nls.mk po/it.po

2003-12-11 Thread Marc G. Fournier
time. My delay here ... I've been down with the flu for the past little while, and have been grabbing emails as I can .. will try and get you setup during the day tomrorow, sorry ;( Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email: [EMAIL PROTE

Re: [HACKERS] Resurrecting pg_upgrade

2003-12-12 Thread Marc G. Fournier
a slave, the IP would be the master server itself ... in the case of pg_upgrade, it would be localhost? Then again, in the case of pg_upgrade, wouldn't just disabling access from anywhere except localhost prevent others from getting in? Marc G. Fournier Hub.Org Networking

Re: [HACKERS] Resurrecting pg_upgrade

2003-12-12 Thread Marc G. Fournier
might not be slower > than copying all the files to a new PGDATA ... being able to do a dump to a gzip'd tar file might be an option here also ... should take a significantly less footprint to create the "backup", and on an idle server, shouldn't take any longer then other

Re: [HACKERS] Limiting per user and per db accesse (was TODO list)

2003-12-17 Thread Marc G. Fournier
out if user is part of GroupA and, if so, increment that count ... no? Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email: [EMAIL PROTECTED] Yahoo!: yscrappy ICQ: 7615664 ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [HACKERS] replace all with * in pg_hba.conf

2003-12-19 Thread Marc G. Fournier
idea. > > Probably we ought to go with that, on backwards-compatibility grounds. why not do both, but deprecate the use of all in the docs? say with an eventual goal of removing the use of all altogether in 2 releases? Marc G. Fournier Hub.Org Networking Services (http://w

Re: [HACKERS] [pgsql-advocacy] PostgreSQL speakers needed for OSCON 2004

2003-12-20 Thread Marc G. Fournier
e could just forward them all through to the PostgreSQL project? > > Would this be at all useful? Someone mentioned that the 'fees' were relatively high though ... that you lose a fair amount off the top *to* Sourceforge? Marc G. Fournier Hub.Org Networking Servic

Re: [HACKERS] [pgsql-advocacy] PostgreSQL speakers needed for OSCON 2004

2003-12-21 Thread Marc G. Fournier
ave yet to any major complaints about their services ... we haven't found any major complaints about our current one, but we just find we're losing too much money in the way of fees ... Marc G. Fournier Hub.Org Networking Services (http://www.h

[HACKERS] 7.4.1 tag'd and bundled ...

2003-12-21 Thread Marc G. Fournier
will do a general announce Monday afternoon, but if someone can test and confirm that I haven't missed anything, that would be great... Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email: [EMAIL PROTECTED] Yahoo!: yscrappy ICQ: 76

Re: [HACKERS] [COMMITTERS] pgsql-server/doc/src/sgml Tag: REL7_4_STABLE

2003-12-22 Thread Marc G. Fournier
target, so that it happens as part of the bundle build? or maybe a 'make release_prep' target could be created, that would include stuff like this that gets done just before release? Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email: [EMAIL PROT

Re: [HACKERS] [COMMITTERS] pgsql-server/doc/src/sgml Tag: REL7_4_STABLE

2003-12-22 Thread Marc G. Fournier
INSTALL too. Confused here, but how "up to date" is HISTORY in CVS to start with? I don't go out of my way to watch for them, but commits to HISTORY don't seem to be all that often to start with ... and how many ppl actually look at the HISTORY file *except* at relea

Re: [HACKERS] [COMMITTERS] pgsql-server/doc/src/sgml Tag: REL7_4_STABLE

2003-12-22 Thread Marc G. Fournier
On Mon, 22 Dec 2003, Bruce Momjian wrote: > Marc G. Fournier wrote: > > On Mon, 22 Dec 2003, Bruce Momjian wrote: > > > > > The only problem with removing HISTORY from CVS is that we will not have > > > an easily reable list of release changes _until_ we pack

Re: [HACKERS] [COMMITTERS] pgsql-server/doc/src/sgml Tag: REL7_4_STABLE

2003-12-22 Thread Marc G. Fournier
STORY' in CVS would just be a URL to that online version, while 'HISTORY' in a release would be the full HISTORY file ... ? Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email: [EMAIL PROTECTED] Yahoo!: yscrappy ICQ: 7615664

Re: [HACKERS] What's planned for 7.5?

2004-01-12 Thread Marc G. Fournier
_ > Do you Yahoo!? > Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes > http://hotjobs.sweepstakes.yahoo.com/signingbonus > > ---(end of broadcast)--- > TIP 6: Have you searched our list archives? > >http://archiv

Re: [HACKERS] What's planned for 7.5?

2004-01-12 Thread Marc G. Fournier
/pgsql/win32.html > > The first isn't new, but as for what I know, it's a new aproach that Jan has for > adding replication to the server. Nope, pgreplication has nothing to do with Jan ... he's working on Slonik-1 ... Marc G. Fournier Hub.Org Networking Servi

Re: [HACKERS] nomenclature

2004-01-16 Thread Marc G. Fournier
lar things. "Psql" for the client and "postmaster" for the daemon > are the ones that really confuse people, I think. I don't know, doesn't one of the databases out there use 'monitor' as their equivalent to psql? Marc G. Fournier Hub.Org N

Re: [HACKERS] nomenclature

2004-01-16 Thread Marc G. Fournier
t is the process that sorts out the incoming connections and assigns them to backend processes ... just like the postmaster does with your mail ... Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email: [EMAIL PROTECTED] Yahoo!: yscrappy

[HACKERS] And ppl complain about *our* beta cycles ...

2004-01-16 Thread Marc G. Fournier
>From the Firebird FAQ: "The first beta was released on January 29, 2003. We are hoping to be close to a full release some time around Easter 2003." They are at RC8 right now ... running a *wee* bit behind scheduale :) Marc G. Fournier Hub.Org Networking S

Re: [HACKERS] nomenclature

2004-01-16 Thread Marc G. Fournier
h, keeps it short ... or we could go even shorter with just pgd ... But, I'm not, in any stretch of the imagination, advocating for change on this ... Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email: [EMAIL PROTECTED] Yahoo!: yscrappy

[HACKERS] [7.4] "permissions problem" with pl/pgsql function

2004-01-19 Thread Marc G. Fournier
rycolumn" line 19 at execute statement the database was created as: CREATE DATABASE WITH OWNER = and I'm connected to the database as the owner ... shouldn't the "system tables" also be owned by the owner? Marc G. Fournier Hub.Org Networking Service

PostGIS dropgeometrycolumn function (Was: Re: [HACKERS] [7.4] "permissions problem" with pl/pgsql function )

2004-01-20 Thread Marc G. Fournier
On Mon, 19 Jan 2004, Tom Lane wrote: > "Marc G. Fournier" <[EMAIL PROTECTED]> writes: > > Just had a client point this out to me, and am wondering if its supposed > > to happen: > > > 420_test=> select > > dropgeometrycolumn('420_test',&

Re: PostGIS dropgeometrycolumn function (Was: Re: [HACKERS] [7.4]

2004-01-20 Thread Marc G. Fournier
On Tue, 20 Jan 2004, Tom Lane wrote: > "Marc G. Fournier" <[EMAIL PROTECTED]> writes: > > On Mon, 19 Jan 2004, Tom Lane wrote: > >> in particular, what SQL command is it trying to execute when it chokes? > > > The function is executing: > > &

[HACKERS] testing mail relays ...

2004-01-21 Thread Marc G. Fournier
we lost a mail relay, so teseting to make sure configuration is still working after replacing it with other local machines we have more contrl over ... Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email: [EMAIL PROTECTED] Yahoo!: yscrappy

Re: [HACKERS] [pgsql-advocacy] PostgreSQL installation CD based on Morphix

2004-01-23 Thread Marc G. Fournier
maybe Robert can comment on what is on it before u spend alot of time recreating it? It might be something you two can collaborate on, if it doesn't contain everything your Japanese version already does? Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Em

Re: [HACKERS] [pgsql-advocacy] PostgreSQL installation CD based on Morphix

2004-01-24 Thread Marc G. Fournier
On Sat, 24 Jan 2004, Robert Bernier wrote: > I recompiled the kernel to get the 'elephant' (does it have a name??) Slonik ... Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email: [EMAIL PROTECTED] Yahoo!: yscrappy

Re: [HACKERS] postgresql.org reverse lookup fail

2004-01-27 Thread Marc G. Fournier
care of this problem? > -- > Tatsuo Ishii > > ---(end of broadcast)--- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED]) > Marc G. Fournier

[HACKERS] Stupid question on Read Committed Isolation Level

2004-01-29 Thread Marc G. Fournier
ABORTng Trans1 will rollback to the original value, no? Or am I reading that section wrong? :( ---- Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email: [EMAIL PROTECTED] Yahoo!: yscrappy ICQ: 7615664

Re: [HACKERS] Stupid question on Read Committed Isolation Level

2004-01-29 Thread Marc G. Fournier
On Thu, 29 Jan 2004, Jeroen T. Vermeulen wrote: > On Thu, Jan 29, 2004 at 01:33:48PM -0400, Marc G. Fournier wrote: > > > What happens if I abort on the first transaction? If I'm reading this > > Doesn't matter, because your second transaction doesn't read a

Re: [HACKERS] Stupid question on Read Committed Isolation Level

2004-01-29 Thread Marc G. Fournier
On Thu, 29 Jan 2004, Tom Lane wrote: > "Marc G. Fournier" <[EMAIL PROTECTED]> writes: > > What happens if I abort on the first transaction? If I'm reading this > > right, if Trans2 does the exact same as above, and COMMITs before Trans1 > > Aborts,

<    9   10   11   12   13   14   15   16   17   18   >