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

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

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

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

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

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] 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] 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 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 or

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 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

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

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. aolMe, too!/aol Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/

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] 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

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

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

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

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

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, 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

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 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, but

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 operating

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 you going

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

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,

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 longer

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 of

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] 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 packagers

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

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,

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

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

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

[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 bits

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

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 that is more

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,

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

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

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

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

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

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

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

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 we

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

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

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

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

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

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] 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] 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's

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. (Contrast

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 The

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 tools

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 not the

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 done

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 if people

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 math.h defines INT_MAX and related symbols, whereas the spec is perfectly clear that they're in limits.h. 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

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. I do not

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

<    1   2