Re: [HACKERS] monolithic distro

2006-07-13 Thread Lukas Smith
Lukas Smith wrote: Peter Eisentraut wrote: Lukas Kahwe Smith wrote: whereas PostgreSQL is continuously complaing that MySQL is inferior yet way more popular. Maybe MySQL's popularity is not even PostgreSQL's goal, but I am sure a bit more would be welcome. Does MySQL have a monolithic distrib

[HACKERS] ShmemAlloc() alignment patch

2006-07-13 Thread Qingqing Zhou
In ShmemAlloc() we have: newStart = BUFFERALIGN(newStart); newSpace = (void *) (ShmemBase + newStart); return newSpace; Notice that though newStart is ALIGNOF_BUFFER, ShmemBase is not. Thus the newSpace is not aligned as we disired. Attached please find the patch. Regards, Qingqing Index

Re: [HACKERS] monolithic distro

2006-07-13 Thread Lukas Smith
Peter Eisentraut wrote: Lukas Kahwe Smith wrote: whereas PostgreSQL is continuously complaing that MySQL is inferior yet way more popular. Maybe MySQL's popularity is not even PostgreSQL's goal, but I am sure a bit more would be welcome. Does MySQL have a monolithic distribution? Well obviou

Re: [HACKERS] poor performance with Context Switch Storm at TPC-W.

2006-07-13 Thread Katsuhiko Okano
Hi. Alvaro Herrera wrote: > Katsuhiko Okano wrote: > > > I suspected conflict of BufMappingLock. > > but, collected results are seen, > > occurrence of CSStorm and the increase of BufMappingLock counts > > seem not to correspond. > > Instead, SubtransControlLock and SubTrans were increasing. >

Re: [HACKERS] [PATCHES] include compile problems

2006-07-13 Thread Tom Lane
Bruce Momjian <[EMAIL PROTECTED]> writes: > Patch applied. Thanks. I suspect the point was that limits.h is needed *instead of* math.h, not *in addition to*. How many of those headers had math.h before? regards, tom lane ---(end of broadcast)

Re: [HACKERS] [PATCHES] include compile problems

2006-07-13 Thread Kris Jurka
On Fri, 14 Jul 2006, Tom Lane wrote: I think that Bruce thought that defines INT_MAX and related symbols, whereas the spec is perfectly clear that they're in . However, that's where they are on my machines, and yet CVS tip is not failing for me. I'm not clear why not... What platform are y

Re: [HACKERS] [PATCHES] include compile problems

2006-07-13 Thread Bruce Momjian
Tom Lane wrote: > Kris Jurka <[EMAIL PROTECTED]> writes: > > The attached patch makes the tree build for me again after the recent > > include changes. This patch still violates the postgres.h before all > > system headers rule and I'm still not sure what changed that broke > > everything, but

Re: [HACKERS] [PATCHES] include compile problems

2006-07-13 Thread Tom Lane
Kris Jurka <[EMAIL PROTECTED]> writes: > The attached patch makes the tree build for me again after the recent > include changes. This patch still violates the postgres.h before all > system headers rule and I'm still not sure what changed that broke > everything, but if people need to get work

Re: [HACKERS] Three weeks left until feature freeze

2006-07-13 Thread Bruce Momjian
Tom Lane wrote: > Andrew Dunstan <[EMAIL PROTECTED]> writes: > > Quite so. That's why buildfarm for pl/java will be important when I can > > get it done. > > +1 --- the important point about an arrangement like that is that it'll > be clear from the buildfarm results that pljava is broken, and no

Re: [HACKERS] RESET CONNECTION?

2006-07-13 Thread Tatsuo Ishii
I'm disappointed. Can you point out past discussion for this? -- Tatsuo Ishii SRA OSS, Inc. Japan > Mario Weilguni wrote: > > Will this patch make it into 8.2? > > http://archives.postgresql.org/pgsql-patches/2004-12/msg00228.php > > > > It's a really nice feature, would be extremly useful with

Re: [HACKERS] Updateable views for 8.2 or 8.3?

2006-07-13 Thread Jaime Casanova
On 7/13/06, Bernd Helmle <[EMAIL PROTECTED]> wrote: --On Mittwoch, Juli 12, 2006 20:58:08 -0500 Jaime Casanova <[EMAIL PROTECTED]> wrote: > if nobody step up i can do the list. > > i think this is the last patch that he post: > http://archives.postgresql.org/pgsql-hackers/2006-03/msg00586.php

Re: [HACKERS] Three weeks left until feature freeze

2006-07-13 Thread Tom Lane
Andrew Dunstan <[EMAIL PROTECTED]> writes: > Quite so. That's why buildfarm for pl/java will be important when I can > get it done. +1 --- the important point about an arrangement like that is that it'll be clear from the buildfarm results that pljava is broken, and not the whole system. (Contra

Re: [HACKERS] DISTINCT/Optimizer question

2006-07-13 Thread Tom Lane
Hi Beth, "Beth Jen" <[EMAIL PROTECTED]> writes: > Right now, the distinct clause adds its targets to the sort clause list when > it is parsed. Yeah, the DISTINCT/DISTINCT ON implementation is currently rather tightly tied to sorting :-(. This is ancient code and badly in need of redesign, but it

Re: [HACKERS] Three weeks left until feature freeze

2006-07-13 Thread Andrew Dunstan
Marc G. Fournier wrote: On Thu, 13 Jul 2006, Andrew Dunstan wrote: Marc G. Fournier wrote: Second, its assuming that Thomas, or any other pl/java developer, *isn't* going to watching for any changes to the API fairly closely, considering they know it does happen, and, therefore, won't make

Re: [HACKERS] Three weeks left until feature freeze

2006-07-13 Thread Marc G. Fournier
On Thu, 13 Jul 2006, Jonah H. Harris wrote: On 7/13/06, Tom Lane <[EMAIL PROTECTED]> wrote: This is really the whole issue right here: you want a monolithic "core" distribution. I cannot begin to list the number of things wrong with that approach, but suffice it to say that that's not the way

Re: [HACKERS] 8.2 features?

2006-07-13 Thread Jonah H. Harris
On 7/13/06, Stephen Frost <[EMAIL PROTECTED]> wrote: I agree that it's probably not going to happen for 8.2 but I certainly have uses for the SQL spec's definition of MERGE (table-level instead of the individual-tuple case). I'd like to see the individual-tuple UPSERT/REPLACE issue handled as we

Re: [HACKERS] Three weeks left until feature freeze

2006-07-13 Thread Marc G. Fournier
On Thu, 13 Jul 2006, Andrew Dunstan wrote: Marc G. Fournier wrote: Second, its assuming that Thomas, or any other pl/java developer, *isn't* going to watching for any changes to the API fairly closely, considering they know it does happen, and, therefore, won't make a change to their develo

Re: [HACKERS] Three weeks left until feature freeze

2006-07-13 Thread Marc G. Fournier
On Thu, 13 Jul 2006, Andrew Dunstan wrote: Tom Lane wrote: The right way to proceed is what was mentioned in another message: work harder at educating packagers about which non-core projects are worth including in their packages. I have to confess contributing to the problem, as I'm not curre

Re: [HACKERS] 8.2 features?

2006-07-13 Thread Stephen Frost
* Peter Eisentraut ([EMAIL PROTECTED]) wrote: > Andrew Dunstan wrote: > > . MERGE (at least in PK case) > > I think that died after we figured out that it didn't do the sort of > UPDATE-else-INSERT thing that people wanted out of it. I agree that it's probably not going to happen for 8.2 but I ce

Re: [HACKERS] Three weeks left until feature freeze

2006-07-13 Thread Andrew Dunstan
Marc G. Fournier wrote: Second, its assuming that Thomas, or any other pl/java developer, *isn't* going to watching for any changes to the API fairly closely, considering they know it does happen, and, therefore, won't make a change to their development code to accommodate that when the time

Unix Installer (Was: Re: [HACKERS] Three weeks left until ... )

2006-07-13 Thread Marc G. Fournier
On Thu, 13 Jul 2006, Jonah H. Harris wrote: On 7/13/06, Marc G. Fournier <[EMAIL PROTECTED]> wrote: 'k, but, again, this comes to someone (you?) stepping forward and dedicating the time/energy to developing a 'mega distribution', and being willing to provide support for it True. Then maybe w

Re: [HACKERS] Three weeks left until feature freeze

2006-07-13 Thread Marc G. Fournier
On Fri, 14 Jul 2006, Satoshi Nagayasu wrote: However, several extensions, such as pl/java, strongly depend on the backend internal functions and arguments. If they are suddenly changed, the extension XX couldn't be compiled anymore, and the users will waste their time. There are several flaw

Re: [HACKERS] Fwd: Three weeks left until feature freeze

2006-07-13 Thread Marc G. Fournier
On Thu, 13 Jul 2006, Joshua D. Drake wrote: Marc G. Fournier wrote: On Thu, 13 Jul 2006, Joshua D. Drake wrote: Most people who run FreeBSD have no need for Mammoth, until possibly they want to upgrade via ports to a new version of PostgreSQL but they don't want to upgrade FreeBSD. 'k, up

Re: [HACKERS] Fwd: Three weeks left until feature freeze

2006-07-13 Thread Joshua D. Drake
I believe it was Lukas who mentioned elsewhere, this is not a vendor nuetral project. I actually am already working on a adding a list of os/package options to the download page based on other feedback, are people comfortable allowing mammothpostgresql to go on that list? (I wouldn't be main

Re: [HACKERS] Fwd: Three weeks left until feature freeze

2006-07-13 Thread Joshua D. Drake
Marc G. Fournier wrote: On Thu, 13 Jul 2006, Joshua D. Drake wrote: Most people who run FreeBSD have no need for Mammoth, until possibly they want to upgrade via ports to a new version of PostgreSQL but they don't want to upgrade FreeBSD. 'k, up to now, you had me ... but what does upgrading

Re: [HACKERS] monolithic distro

2006-07-13 Thread Marc G. Fournier
On Fri, 14 Jul 2006, Peter Eisentraut wrote: Lukas Kahwe Smith wrote: whereas PostgreSQL is continuously complaing that MySQL is inferior yet way more popular. Maybe MySQL's popularity is not even PostgreSQL's goal, but I am sure a bit more would be welcome. Does MySQL have a monolithic distr

Re: [HACKERS] Three weeks left until feature freeze

2006-07-13 Thread Marc G. Fournier
On Fri, 14 Jul 2006, Thomas Hallgren wrote: Marc G. Fournier wrote: But Thomas, that means finding someone willing to do the work to build the port ... :) PL/java should be very easy to port. In fact, I'm not sure any specific porting is needed. There might be some minor makefile quirk (that

Re: [HACKERS] Fwd: Three weeks left until feature freeze

2006-07-13 Thread Marc G. Fournier
On Thu, 13 Jul 2006, Robert Treat wrote: On Thursday 13 July 2006 15:39, Joshua D. Drake wrote: Marc G. Fournier wrote: On Thu, 13 Jul 2006, Joshua D. Drake wrote: Aside from obviously the big issue of who maintains all the pgfoundry stuff, I also think that the PostgreSQL family would benefi

Re: [HACKERS] Fwd: Three weeks left until feature freeze

2006-07-13 Thread Marc G. Fournier
On Thu, 13 Jul 2006, Joshua D. Drake wrote: Most people who run FreeBSD have no need for Mammoth, until possibly they want to upgrade via ports to a new version of PostgreSQL but they don't want to upgrade FreeBSD. 'k, up to now, you had me ... but what does upgrading to a new version of Pos

Re: [HACKERS] Fwd: Three weeks left until feature freeze

2006-07-13 Thread Joshua D. Drake
I believe it was Lukas who mentioned elsewhere, this is not a vendor nuetral project. I actually am already working on a adding a list of os/package options to the download page based on other feedback, are people comfortable allowing mammothpostgresql to go on that list? (I wouldn't be main

RPM packaging (was :Re: [HACKERS] Three weeks left until feature freeze)

2006-07-13 Thread Devrim GUNDUZ
Hi, On Thu, 2006-07-13 at 15:33 -0400, Chris Browne wrote: > If we have an interestingly large set of packages at pgFoundry that > are "that RPMable," then they *will* come. Personally I am interested in building all RPMable PostgreSQL related projects. Currently I do packaging for PostgreSQL, p

Re: [HACKERS] Fwd: Three weeks left until feature freeze

2006-07-13 Thread Robert Treat
On Thursday 13 July 2006 15:39, Joshua D. Drake wrote: > Marc G. Fournier wrote: > > On Thu, 13 Jul 2006, Joshua D. Drake wrote: > >>> Aside from obviously the big issue of who maintains all the pgfoundry > >>> stuff, I also think that the PostgreSQL family would benefit from a > >>> distribution t

Re: [HACKERS] Fwd: Three weeks left until feature freeze

2006-07-13 Thread Joshua D. Drake
Peter Eisentraut wrote: Joshua D. Drake wrote: Were trying man :) I have people building for most major distributions at this point. We should have FreeBSD soon, as well as MacOSX. How is this different (or better) than what is already in FreeBSD ports? There is no functional difference. It

[HACKERS] Standards conforming strings

2006-07-13 Thread Chris Browne
I understand that we have an issue, with Slony-I, concerning the new "standards_conforming_strings" option in 8.2. Slony-I uses the "legacy" quoting conventions, which, such as it is, is fine. If a particular server is set to standards_conforming_strings=on, this will presumably lead to certain b

Re: [HACKERS] Three weeks left until feature freeze

2006-07-13 Thread Thomas Hallgren
Marc G. Fournier wrote: But Thomas, that means finding someone willing to do the work to build the port ... :) PL/java should be very easy to port. In fact, I'm not sure any specific porting is needed. There might be some minor makefile quirk (that is what has bitten me on other platforms). I

Re: [HACKERS] Three weeks left until feature freeze

2006-07-13 Thread Marc G. Fournier
On Thu, 13 Jul 2006, Chris Browne wrote: kleptog@svana.org (Martijn van Oosterhout) writes: On Thu, Jul 13, 2006 at 01:26:30PM -0400, Tom Lane wrote: The right way to proceed is what was mentioned in another message: work harder at educating packagers about which non-core projects are worth in

Re: [HACKERS] Three weeks left until feature freeze

2006-07-13 Thread Joshua D. Drake
Hey JD, I notice that we don't have a port for plphp either ... if one of your guys wants to create one, I can get it committed ... DarcyB is supposed to be handling that :) Joshua D. Drake Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email . [EMAIL PRO

Re: [HACKERS] 8.2 features?

2006-07-13 Thread Peter Eisentraut
Andrew Dunstan wrote: > . MERGE (at least in PK case) I think that died after we figured out that it didn't do the sort of UPDATE-else-INSERT thing that people wanted out of it. > . multiple values clauses for INSERT Susanne Ebrecht <[EMAIL PROTECTED]> was last heard to work on it. Updates, Sus

Re: [HACKERS] Three weeks left until feature freeze

2006-07-13 Thread Marc G. Fournier
On Fri, 14 Jul 2006, Thomas Hallgren wrote: Marc G. Fournier wrote: I'm confused here ... "has been on gborg for several weeks, but only available through the wiki" ... On: http://gborg.postgresql.org/project/pljava/projdisplay.php ... I can't find any way of downloading 1.3.0 (or, older r

Re: [HACKERS] Three weeks left until feature freeze

2006-07-13 Thread Satoshi Nagayasu
Kris Jurka wrote: > > > On Thu, 13 Jul 2006, Tom Lane wrote: > >> The people who think PL/Java is an essential checklist item >> undoubtedly also think JDBC is an essential checklist item, but I'm >> not seeing any groundswell of support for putting JDBC back into >> core. Instead we expect

Re: [HACKERS] Three weeks left until feature freeze

2006-07-13 Thread Marc G. Fournier
On Thu, 13 Jul 2006, D'Arcy J.M. Cain wrote: On Thu, 13 Jul 2006 19:54:19 -0300 (ADT) "Marc G. Fournier" <[EMAIL PROTECTED]> wrote: Well NetBSD doesn't offer pl/java now so I'm not sure what point you are trying to make. Sure it would be nice if every OS provided every version of every package

Re: [HACKERS] monolithic distro

2006-07-13 Thread Peter Eisentraut
Lukas Kahwe Smith wrote: > whereas PostgreSQL is continuously complaing that > MySQL is inferior yet way more popular. Maybe MySQL's popularity is not > even PostgreSQL's goal, but I am sure a bit more would be welcome. Does MySQL have a monolithic distribution? ---(end

Re: [HACKERS] set search_path in dump output considered harmful

2006-07-13 Thread Tom Lane
Phil Frost <[EMAIL PROTECTED]> writes: > I've recently migrated one of my databases to using veil. This involved > creating a 'private' schema and moving all tables to it. > ... > In doing so, I found to my extreme displeasure that although the > database continues to function flawlessly, I can no

Re: [HACKERS] Three weeks left until feature freeze

2006-07-13 Thread Thomas Hallgren
Marc G. Fournier wrote: ... the only reason 'NetBSD doesn't offer pl/java now' is because nobody a) is using it under NetBSD or b) submitted a port to their system Should be fairly straight forward if the PostgreSQL SDK and gcj 4.0 or later is installed. Download the PL/Java source tarball, ma

Re: [HACKERS] Fwd: Three weeks left until feature freeze

2006-07-13 Thread Peter Eisentraut
Joshua D. Drake wrote: > Were trying man :) I have people building for most major distributions > at this point. We should have FreeBSD soon, as well as MacOSX. How is this different (or better) than what is already in FreeBSD ports? ---(end of broadcast)-

Re: [HACKERS] Three weeks left until feature freeze

2006-07-13 Thread D'Arcy J.M. Cain
On Thu, 13 Jul 2006 19:54:19 -0300 (ADT) "Marc G. Fournier" <[EMAIL PROTECTED]> wrote: > > Well NetBSD doesn't offer pl/java now so I'm not sure what point you are > > trying to make. Sure it would be nice if every OS provided every version > > of > > every package, but when they don't what are

Re: [HACKERS] Three weeks left until feature freeze

2006-07-13 Thread Peter Eisentraut
Jonah H. Harris wrote: > True. Then maybe we should just all work together to make a > distribution suggestion to packagers of the major components and their > versions. That way the packagers at least have a good idea of what we > believe is "good-to-go" with X version of PostgreSQL. Which oper

Re: [HACKERS] Three weeks left until feature freeze

2006-07-13 Thread Thomas Hallgren
Marc G. Fournier wrote: I'm confused here ... "has been on gborg for several weeks, but only available through the wiki" ... On: http://gborg.postgresql.org/project/pljava/projdisplay.php ... I can't find any way of downloading 1.3.0 (or, older releases even) ... have you been uploading, bu

Re: [HACKERS] Three weeks left until feature freeze

2006-07-13 Thread Marc G. Fournier
On Fri, 14 Jul 2006, Thomas Hallgren wrote: Marc G. Fournier wrote: How would I go about taking advantage of that? And who did the 1.2.0 upload? I certainly didn't. There is alot more then then just 1.2.0 ... check out the FTP site ... As for taking advantage of that ... upload files to the

Re: [HACKERS] Three weeks left until feature freeze

2006-07-13 Thread Marc G. Fournier
On Thu, 13 Jul 2006, Bruce Momjian wrote: Marc G. Fournier wrote: On Thu, 13 Jul 2006, Rod Taylor wrote: A slight restructuring of the FTP tree should probably be made. It's currently very easy to find the main pgsql, pgadmin and odbc components. Finding pl/java (what the heck is that gborg o

Re: [HACKERS] Three weeks left until feature freeze

2006-07-13 Thread Thomas Hallgren
Marc G. Fournier wrote: How would I go about taking advantage of that? And who did the 1.2.0 upload? I certainly didn't. There is alot more then then just 1.2.0 ... check out the FTP site ... As for taking advantage of that ... upload files to the file section in *either* gborg or pgfoundry,

Re: [HACKERS] Three weeks left until feature freeze

2006-07-13 Thread Marc G. Fournier
On Thu, 13 Jul 2006, Kris Jurka wrote: On Thu, 13 Jul 2006, D'Arcy J.M. Cain wrote: Wouldn't that be the job of the platform providers? Certainly I would expect NetBSD to make it available as a package, both source and binary, on every platform they support as they do for the thousands of o

Re: [HACKERS] Three weeks left until feature freeze

2006-07-13 Thread Peter Eisentraut
Jonah H. Harris wrote: > Because, the fact is that it's a PITA and many people don't even go > far enough to look. If major components of PostgreSQL were included > in the core, it would make it much easier for people; especially those > familiar with commercial-class database systems. Those fami

Re: [HACKERS] Three weeks left until feature freeze

2006-07-13 Thread Marc G. Fournier
On Thu, 13 Jul 2006, Bort, Paul wrote: Does PL/Java really have to be in core to be tested in the build farm? Could the build farm code be enhanced to test non-core stuff? (I like the idea of a separate status 'light' for non-core.) Andrew posted about his desires for the future of the Buildf

Re: [HACKERS] Three weeks left until feature freeze

2006-07-13 Thread Marc G. Fournier
On Fri, 14 Jul 2006, Thomas Hallgren wrote: Marc G. Fournier wrote: So, let's try ftp ... ftp.postgresql.org:/pub/projects/gborg/pljava/stable: Nothing there newer then November 2005: ftp> ls -lt 227 Entering Passive Mode (66,98,251,159,248,251) 150 Opening ASCII mode data connection for /b

Re: [HACKERS] Three weeks left until feature freeze

2006-07-13 Thread Kris Jurka
On Thu, 13 Jul 2006, D'Arcy J.M. Cain wrote: Wouldn't that be the job of the platform providers? Certainly I would expect NetBSD to make it available as a package, both source and binary, on every platform they support as they do for the thousands of other packages they deal with. Well Net

Re: [HACKERS] 8.2 features?

2006-07-13 Thread Joe Conway
Tom Lane wrote: Andrew Dunstan <[EMAIL PROTECTED]> writes: What is the state of the following items that have been previously discussed? . multiple values clauses for INSERT Also not done, but if we are willing to accept a limited patch (ie, not necessarily everything that SQL92 says you can

Re: [HACKERS] 8.2 features?

2006-07-13 Thread David Fetter
On Thu, Jul 13, 2006 at 05:09:32PM -0400, Jonah H. Harris wrote: > On 7/13/06, Andrew Dunstan <[EMAIL PROTECTED]> wrote: > >>>. multiple values clauses for INSERT > > > >I would be very happy to see it accepted. > > Same here. Me, too! Cheers, D -- David Fetter <[EMAIL PROTECTED]> http://fetter

Re: [HACKERS] Three weeks left until feature freeze

2006-07-13 Thread Thomas Hallgren
Marc G. Fournier wrote: So, let's try ftp ... ftp.postgresql.org:/pub/projects/gborg/pljava/stable: Nothing there newer then November 2005: ftp> ls -lt 227 Entering Passive Mode (66,98,251,159,248,251) 150 Opening ASCII mode data connection for /bin/ls. total 23026 -rw-r--r-- 1 80 1009 206

Re: [HACKERS] Three weeks left until feature freeze

2006-07-13 Thread Thomas Hallgren
Jonah H. Harris wrote: But, I can't find anything there to download ... just a pointer to a Wiki, which, I'm sorry, would definitely not be my first thought to go look at for a downloads ... Hmm, yes... just saw that and it is a bit odd. Thomas, I like the layout of the Wiki... but could we

Re: [HACKERS] Three weeks left until feature freeze

2006-07-13 Thread Thomas Hallgren
Joshua D. Drake wrote: JDBC is different, in that it doesn't require the PostgreSQL core to build. It's 100% native Java, and as such, I see benefit to it being distributed separately. PLJava does not need PostgreSQL core to build either. It needs: pgxs + Postgresql libs + PostgreSQL headers

Re: [HACKERS] Three weeks left until feature freeze

2006-07-13 Thread D'Arcy J.M. Cain
On Thu, 13 Jul 2006 16:15:04 -0500 (EST) Kris Jurka <[EMAIL PROTECTED]> wrote: > The fact that the JDBC driver requires no compilation for anyone on any > platform is one reason for that. Anyone can visit the website and be > working within minutes with no understanding of the build environment

Re: [HACKERS] buildfarm future

2006-07-13 Thread Kris Jurka
Andrew Dunstan wrote: I intended to post this anyway as a followup to the conference session, but I have been spurred to do it nowby the Pl/J(ava) discussion. Another thought I had today was the ability to attach notes to the web site. For example a recent commit broke the 7.3 branch for

Re: [HACKERS] Three weeks left until feature freeze

2006-07-13 Thread Kris Jurka
On Thu, 13 Jul 2006, Tom Lane wrote: The people who think PL/Java is an essential checklist item undoubtedly also think JDBC is an essential checklist item, but I'm not seeing any groundswell of support for putting JDBC back into core. Instead we expect packagers (like the RPM set) to make

Re: [HACKERS] 8.2 features?

2006-07-13 Thread Jonah H. Harris
On 7/13/06, Andrew Dunstan <[EMAIL PROTECTED]> wrote: >>. multiple values clauses for INSERT I would be very happy to see it accepted. Same here. -- Jonah H. Harris, Software Architect | phone: 732.331.1300 EnterpriseDB Corporation| fax: 732.331.1301 33 Wood Ave S, 2nd Floor

Re: [HACKERS] 8.2 features?

2006-07-13 Thread Andrew Dunstan
Tom Lane wrote: . multiple values clauses for INSERT Also not done, but if we are willing to accept a limited patch (ie, not necessarily everything that SQL92 says you can do with VALUES, but at least the INSERT case) I think it could get done. I might even volunteer to do it ... but won'

Re: [HACKERS] monolithic distro

2006-07-13 Thread Joshua D. Drake
Yeah, but if PostgreSQL decides to endorse one monolithic distro in the way I described it could give that project hopefully the necessary lift. And the ultimate goal is obviously that some of those newbies coming by way of the monolithic distro turn into people that bring ressources to the P

Re: [HACKERS] monolithic distro

2006-07-13 Thread Lukas Kahwe Smith
Marc G. Fournier wrote: Yeah, but if PostgreSQL decides to endorse one monolithic distro in the way I described it could give that project hopefully the necessary lift. And the ultimate goal is obviously that some of those newbies coming by way of the monolithic distro turn into people that br

Re: [HACKERS] monolithic distro

2006-07-13 Thread Marc G. Fournier
On Thu, 13 Jul 2006, Lukas Kahwe Smith wrote: Marc G. Fournier wrote: But, that isn't our role ... that should be the role of whomever takes on the role of 'maintainer' for such a monolithic distribution ... its no more our role to decide that pl/Java is better or worse then pl/J ... our role

Re: [HACKERS] monolithic distro

2006-07-13 Thread Andrew Dunstan
Marc G. Fournier wrote: But, that isn't our role ... that should be the role of whomever takes on the role of 'maintainer' for such a monolithic distribution ... its no more our role to decide that pl/Java is better or worse then pl/J ... our role is to provide that core for everyone else to

Re: [HACKERS] AIX buildfarm failure

2006-07-13 Thread Bruce Momjian
Rocco Altier wrote: > Now it dies on nodeSubplan.c... > > I am guessing there will be others as well. I check them all the math.h mentions. --- > > Perhaps a check to make sure postgres.h is first in the includes can be >

Re: [HACKERS] monolithic distro

2006-07-13 Thread Lukas Kahwe Smith
Marc G. Fournier wrote: But, that isn't our role ... that should be the role of whomever takes on the role of 'maintainer' for such a monolithic distribution ... its no more our role to decide that pl/Java is better or worse then pl/J ... our role is to provide that core for everyone else to b

Re: [HACKERS] monolithic distro (was: Re: Fwd: Three weeks left

2006-07-13 Thread Marc G. Fournier
On Thu, 13 Jul 2006, Lukas Smith wrote: Joshua D. Drake wrote: Aside from obviously the big issue of who maintains all the pgfoundry stuff, I also think that the PostgreSQL family would benefit from a distribution that is more "and the kitchen sink" style. I do not know exactly if Bizgres cou

Re: [HACKERS] AIX buildfarm failure

2006-07-13 Thread Rocco Altier
Now it dies on nodeSubplan.c... I am guessing there will be others as well. Perhaps a check to make sure postgres.h is first in the includes can be added to the include checking scripts you have been updating? Thanks, -rocco > -Original Message- > From: Bruce Momjian [mailto:[EM

[HACKERS] monolithic distro (was: Re: Fwd: Three weeks left until feature freeze)

2006-07-13 Thread Lukas Smith
Joshua D. Drake wrote: Aside from obviously the big issue of who maintains all the pgfoundry stuff, I also think that the PostgreSQL family would benefit from a distribution that is more "and the kitchen sink" style. I do not know exactly if Bizgres could be considered just that? Or maybe it co

Re: [HACKERS] AIX buildfarm failure

2006-07-13 Thread Bruce Momjian
Fixed. --- Tom Lane wrote: > "Rocco Altier" <[EMAIL PROTECTED]> writes: > > If I move down after "postgres.h" in nodeHash.c, the problem > > goes away. > > Bruce, you broke it. Have you forgotten the fundamental inclusion

Re: [HACKERS] Three weeks left until feature freeze

2006-07-13 Thread Bruce Momjian
Marc G. Fournier wrote: > On Thu, 13 Jul 2006, Rod Taylor wrote: > > > A slight restructuring of the FTP tree should probably be made. It's > > currently very easy to find the main pgsql, pgadmin and odbc components. > > Finding pl/java (what the heck is that gborg or pgfoundry project?) is > >

Re: [HACKERS] Three weeks left until feature freeze

2006-07-13 Thread Chris Browne
kleptog@svana.org (Martijn van Oosterhout) writes: > On Thu, Jul 13, 2006 at 01:26:30PM -0400, Tom Lane wrote: >> The right way to proceed is what was mentioned in another message: >> work harder at educating packagers about which non-core projects >> are worth including in their packages. I have

Re: [HACKERS] RESET CONNECTION?

2006-07-13 Thread Bruce Momjian
Mario Weilguni wrote: > Will this patch make it into 8.2? > http://archives.postgresql.org/pgsql-patches/2004-12/msg00228.php > > It's a really nice feature, would be extremly useful with tools like pgpool. No, it will not because RESET CONNECTION can mess up interface code that doesn't want the

Re: [HACKERS] 8.2 features?

2006-07-13 Thread Jonah H. Harris
On 7/13/06, Tom Lane <[EMAIL PROTECTED]> wrote: > . recursive WITH queries I believe Jonah has given up on fixing the originally-submitted patch, but he mentioned at the code sprint that non-recursive WITH is potentially doable in time for 8.2. Not sure if that's a sufficiently important case t

Re: [HACKERS] Three weeks left until feature freeze

2006-07-13 Thread Joshua D. Drake
Sounds kinda like our discussions: You've got to download it. And then you have to go check the website. Download some drivers and PLs. You have to check your version dependencies. Compile your binaries and/or install them. Probably do that once or twice. It's just so easy. And so simple. I don'

Re: [HACKERS] Fwd: Three weeks left until feature freeze

2006-07-13 Thread Joshua D. Drake
Marc G. Fournier wrote: On Thu, 13 Jul 2006, Joshua D. Drake wrote: Aside from obviously the big issue of who maintains all the pgfoundry stuff, I also think that the PostgreSQL family would benefit from a distribution that is more "and the kitchen sink" style. I do not know exactly if Bizgre

Re: [HACKERS] AIX buildfarm failure

2006-07-13 Thread Tom Lane
"Rocco Altier" <[EMAIL PROTECTED]> writes: > If I move down after "postgres.h" in nodeHash.c, the problem > goes away. Bruce, you broke it. Have you forgotten the fundamental inclusion rule? postgres.h (or postgres_fe.h, or c.h) first, then system headers, then our own other headers.

Re: [HACKERS] Three weeks left until feature freeze

2006-07-13 Thread Joshua D. Drake
So why put the load on the Core distro? Agreed ... but, maybe on our FTP/download pages, we should add a link for 'Distributions', that would include mammothpostgresql.org and Ubuntu? so that ppl knew about them? We do it for support related stuff ... That is a great idea :) Joshua D.

Re: [HACKERS] Fwd: Three weeks left until feature freeze

2006-07-13 Thread Joshua D. Drake
Marc G. Fournier wrote: On Thu, 13 Jul 2006, Jonah H. Harris wrote: Aside from obviously the big issue of who maintains all the pgfoundry stuff, I also think that the PostgreSQL family would benefit from a distribution that is more "and the kitchen sink" style. This has been suggested before

Re: [HACKERS] Three weeks left until feature freeze

2006-07-13 Thread Joshua D. Drake
Jonah H. Harris wrote: On 7/13/06, Marc G. Fournier <[EMAIL PROTECTED]> wrote: Why? Because, the fact is that it's a PITA and many people don't even go far enough to look. If major components of PostgreSQL were included in the core, it would make it much easier for people; especially those fa

Re: [HACKERS] Three weeks left until feature freeze

2006-07-13 Thread Joshua D. Drake
Major component for whom exactly? What %age of PostgreSQL users are using pl/Java? Are using Java, period? There is only one *major component* and that is the RDBMS itself ... everything else is an add on specific to each end users requirements ... in all of my years of hosting PostgreSQL-

Re: [HACKERS] 8.2 features?

2006-07-13 Thread Tom Lane
Andrew Dunstan <[EMAIL PROTECTED]> writes: > What is the state of the following items that have been previously > discussed? > . MERGE (at least in PK case) No submitted patch; no one working on it AFAIK; doesn't look like something that could get done in the next three weeks. > . multiple valu

Re: [HACKERS] Three weeks left until feature freeze

2006-07-13 Thread Jonah H. Harris
On 7/13/06, Tom Lane <[EMAIL PROTECTED]> wrote: No, the correct way to say that is "if major components were included in the readily-available distributions of Postgres" then newbies would find it easier to find them. OK, I agree. Damn semantics :) That doesn't lead to concluding that we sho

Re: [HACKERS] Three weeks left until feature freeze

2006-07-13 Thread Marc G. Fournier
On Thu, 13 Jul 2006, Joshua D. Drake wrote: No matter what we want people to do, if someone wants PostgreSQL, they go to PostgreSQL's site, download PostgreSQL, and install PostgreSQL. The fact is, most people generally don't read the, "don't see it in the distribution, check out pgfoundry"-li

Re: [HACKERS] Three weeks left until feature freeze

2006-07-13 Thread Jonah H. Harris
On 7/13/06, Marc G. Fournier <[EMAIL PROTECTED]> wrote: 'k, but, again, this comes to someone (you?) stepping forward and dedicating the time/energy to developing a 'mega distribution', and being willing to provide support for it True. Then maybe we should just all work together to make a dist

Re: [HACKERS] Three weeks left until feature freeze

2006-07-13 Thread Dave Page
-Original Message- From: "Marc G. Fournier" <[EMAIL PROTECTED]> To: "Rod Taylor" <[EMAIL PROTECTED]> Cc: "Jonah H. Harris" <[EMAIL PROTECTED]>; "postgres hackers" Sent: 13/07/06 20:06 Subject: Re: [HACKERS] Three weeks left until feature freeze > The gborg vs pgfoundry issue is being

Re: [HACKERS] Three weeks left until feature freeze

2006-07-13 Thread Tom Lane
"Jonah H. Harris" <[EMAIL PROTECTED]> writes: > On 7/13/06, Marc G. Fournier <[EMAIL PROTECTED]> wrote: >> Why? > Because, the fact is that it's a PITA and many people don't even go > far enough to look. If major components of PostgreSQL were included > in the core, it would make it much easier f

Re: [HACKERS] Three weeks left until feature freeze

2006-07-13 Thread Marc G. Fournier
On Thu, 13 Jul 2006, Jonah H. Harris wrote: Sounds kinda like our discussions: You've got to download it. And then you have to go check the website. Download some drivers and PLs. You have to check your version dependencies. Compile your binaries and/or install them. Probably do that once or twi

Re: [HACKERS] Three weeks left until feature freeze

2006-07-13 Thread Jonah H. Harris
On 7/13/06, Marc G. Fournier <[EMAIL PROTECTED]> wrote: Again, that goes to your 'kitchen sink distribution' ... its been suggested many times before, nobody cared enough to run with the idea and do something about it ... do you? I certainly care, but I don't have the time. Which, I know, is t

Re: [HACKERS] Fwd: Three weeks left until feature freeze

2006-07-13 Thread Marc G. Fournier
On Thu, 13 Jul 2006, Joshua D. Drake wrote: Aside from obviously the big issue of who maintains all the pgfoundry stuff, I also think that the PostgreSQL family would benefit from a distribution that is more "and the kitchen sink" style. I do not know exactly if Bizgres could be considered jus

Re: [HACKERS] Three weeks left until feature freeze

2006-07-13 Thread Jonah H. Harris
On 7/13/06, Marc G. Fournier <[EMAIL PROTECTED]> wrote: Major component for whom exactly? What %age of PostgreSQL users are using pl/Java? Are using Java, period? Got me, but I don't think you have the facts to dispute it either. As I said, we're discussing this in a vacuum. There is only

Re: [HACKERS] Three weeks left until feature freeze

2006-07-13 Thread Marc G. Fournier
On Thu, 13 Jul 2006, Joshua D. Drake wrote: I don't think we should include everything, and I belive that "collapse" is debatable. The important part is how the distro itself is managed. One can easily create a "core" distribution which includes PL/Java, ODBC, JDBC, etc. All of them don't h

Re: [HACKERS] Three weeks left until feature freeze

2006-07-13 Thread Marc G. Fournier
On Thu, 13 Jul 2006, Rod Taylor wrote: A slight restructuring of the FTP tree should probably be made. It's currently very easy to find the main pgsql, pgadmin and odbc components. Finding pl/java (what the heck is that gborg or pgfoundry project?) is pretty difficult. The gborg vs pgfoundry

Re: [HACKERS] Three weeks left until feature freeze

2006-07-13 Thread Marc G. Fournier
On Thu, 13 Jul 2006, Jonah H. Harris wrote: On 7/13/06, Dave Cramer <[EMAIL PROTECTED]> wrote: The official JDBC driver is not being shipped with the project for exactly the same reasons, I fail to see any compelling reason to ship either java PL. IMHO, we should be shipping the JDBC driver..

  1   2   >