Re: [HACKERS] CVS HEAD problem: psql: symbol lookup error:

2005-05-06 Thread Oleg Bartunov
On Sat, 7 May 2005, Markus Bertheau wrote: See "FC3 broken with HEAD". I have Slackware 10.1 В Птн, 06/05/2005 в 23:54 +0400, Oleg Bartunov пишет: Just got this problem. Regards, Oleg _ Oleg Bartunov, sci.researche

Re: [HACKERS] FC3 broken with HEAD

2005-05-06 Thread Neil Conway
Tom Lane wrote: Yeah, we will. Please file a bugzilla entry for this though --- I concur that it is a linker bug. Okay, patch reverted. The RH bug is here: https://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=157126 -Neil ---(end of broadcast)---

Re: [HACKERS] Patch for collation using ICU

2005-05-06 Thread Tom Lane
Bruce Momjian writes: > Tom Lane wrote: >> Not until ICU is released under a BSD license ... > Well, readline isn't BSD either, but we use it. It is any different? Did you read the license? Some of the more troubling bits: : It is the understanding of INTERNATIONAL BUSINESS MACHINES CORPORATI

Re: [HACKERS] pl/pgsql enabled by default

2005-05-06 Thread Neil Conway
Andrew Sullivan wrote: Sure it is. "Don't enable anything you don't need," is the first security rule. Everything is turned off by default. If you want it, enable it. So would you have us disable all the non-essential builtin functions? (Many of which have has security problems in the past.) Wh

Re: [HACKERS] Patch for collation using ICU

2005-05-06 Thread John Hansen
Btw, Does it feel right to have pg depend on the bleeding edge version of ICU? On many distro's, even gentoo (known for being bleeding edge) 2.8 is still the default. 2.8 and 3.2 are however incompatible, and supporting both, would bloat the source somewhat. ... John -

Re: [HACKERS] pl/pgsql enabled by default

2005-05-06 Thread Neil Conway
Tom Lane wrote: The denial of service risk in particular (whether intentional or accidental) goes way up. Does it really go "way up"? A malicious user who can execute SQL can DOS the database trivially. Doing the (non-trivial) infrastructure work to fix that is probably a good idea, but I don't s

Re: [HACKERS] Patch for collation using ICU

2005-05-06 Thread John Hansen
> Why do you need to add a mapping of encoding names from iana > to our names? > The pg encoding names are not recognized by ICU, hence the mappings Install ICU 3.2 on your system, and run uconv -l, that will give you a list of valid ICU encoding names. ... John -

[HACKERS] to_char(interval) issues

2005-05-06 Thread Bruce Momjian
Based on this discussion I have added these TODO items: * Prevent to_char() on interval from returning meaningless values For example, to_char('1 month', 'mon') is meaningless. Basically, most date-related parameters to to_char() are meaningless for intervals because interval is not ancho

Re: [HACKERS] Patch for collation using ICU

2005-05-06 Thread Andrew - Supernews
On 2005-05-07, Bruce Momjian wrote: > Tom Lane wrote: >> Bruce Momjian writes: >> > Is this patch ready for application? >> >> Not until ICU is released under a BSD license ... > > Well, readline isn't BSD either, but we use it. It is any different? ICU appears to be under the X license, which

Re: [HACKERS] Patch for collation using ICU

2005-05-06 Thread Bruce Momjian
Tom Lane wrote: > Bruce Momjian writes: > > Is this patch ready for application? > > Not until ICU is released under a BSD license ... Well, readline isn't BSD either, but we use it. It is any different? -- Bruce Momjian| http://candle.pha.pa.us pgman@candle.pha.p

Re: [HACKERS] Patch for collation using ICU

2005-05-06 Thread Tom Lane
Bruce Momjian writes: > Is this patch ready for application? Not until ICU is released under a BSD license ... regards, tom lane ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www

Re: [HACKERS] Patch for collation using ICU

2005-05-06 Thread Bruce Momjian
Is this patch ready for application? http://people.freebsd.org/~girgen/postgresql-icu/pg-802-icu-2005-05-06.diff.gz The web site is: http://people.freebsd.org/~girgen/postgresql-icu/readme.html I do have a few questions: Why don't you use the lc_ctype_is_c() part of this test

Re: [HACKERS] rendezvous

2005-05-06 Thread Alvaro Herrera
On Fri, May 06, 2005 at 03:30:10PM -0700, Joshua D. Drake wrote: > Marc G. Fournier wrote: > >On Fri, 6 May 2005, Joshua D. Drake wrote: > > > >>Should we not change it to bonjour as that is the actual name for it? > > Rendezvous is the Apple network discovery protocol yes? That was renamed > Bon

Re: [HACKERS] rendezvous

2005-05-06 Thread Marc G. Fournier
On Fri, 6 May 2005, Joshua D. Drake wrote: Marc G. Fournier wrote: On Fri, 6 May 2005, Joshua D. Drake wrote: Should we not change it to bonjour as that is the actual name for it? Rendezvous is the Apple network discovery protocol yes? That was renamed Bonjour by apple due to a Trademark problem.

Re: [HACKERS] CVS HEAD problem: psql: symbol lookup error:

2005-05-06 Thread Markus Bertheau
See "FC3 broken with HEAD". Ð ÐÑÐ, 06/05/2005 Ð 23:54 +0400, Oleg Bartunov ÐÐÑÐÑ: > Just got this problem. > > Regards, > Oleg > _ > Oleg Bartunov, sci.researcher, hostmaster of AstroNet, > Sternberg Astronomical Inst

Re: [HACKERS] rendezvous

2005-05-06 Thread Joshua D. Drake
Marc G. Fournier wrote: On Fri, 6 May 2005, Joshua D. Drake wrote: Should we not change it to bonjour as that is the actual name for it? Rendezvous is the Apple network discovery protocol yes? That was renamed Bonjour by apple due to a Trademark problem. huh? Marc G. Fournier Hub.

Re: [HACKERS] rendezvous

2005-05-06 Thread Marc G. Fournier
On Fri, 6 May 2005, Joshua D. Drake wrote: Should we not change it to bonjour as that is the actual name for it? huh? Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email: [EMAIL PROTECTED] Yahoo!: yscrappy ICQ: 7615664 --

[HACKERS] rendezvous

2005-05-06 Thread Joshua D. Drake
Should we not change it to bonjour as that is the actual name for it? Sincerely, Joshua D. Drake -- Your PostgreSQL solutions company - Command Prompt, Inc. 1.800.492.2240 PostgreSQL Replication, Consulting, Custom Programming, 24x7 support Managed Services, Shared and Dedication Hosting Co-Authors

Re: [HACKERS] unix_socket_directory bug or feature?

2005-05-06 Thread Joshua D. Drake
A yoda look alike informed me that I should use -h which does work. Joshua D. Drake wrote: Hello, unix_socket_direct = '/tmp/foo' unix_socket_group = 'postgres' unix_socket_permission = '0200' -bash-3.00$ bin/pg_ctl -D /usr/local/pgsql/etc/ start postmaster starting -bash-3.00$ LOG: could not open

[HACKERS] unix_socket_directory bug or feature?

2005-05-06 Thread Joshua D. Drake
Hello, unix_socket_direct = '/tmp/foo' unix_socket_group = 'postgres' unix_socket_permission = '0200' -bash-3.00$ bin/pg_ctl -D /usr/local/pgsql/etc/ start postmaster starting -bash-3.00$ LOG: could not open Ident usermap file "/usr/local/pgsql/etc/pg_ident.conf": No such file or directory LOG:

Re: [HACKERS] Views, views, views! (long)

2005-05-06 Thread Robert Treat
On Friday 06 May 2005 13:43, Jim C. Nasby wrote: > On Fri, May 06, 2005 at 09:08:10AM -0400, Robert Treat wrote: > > On Thursday 05 May 2005 23:45, Joshua D. Drake wrote: > > > > I was starting to think this... like this should be a project on > > > > foundry called "enhanced system views" that wou

[HACKERS] Releases postponed till Monday

2005-05-06 Thread Tom Lane
Jan Wieck came up with a test case that has exposed two long-standing race conditions. We've pulled the release candidate tarballs from the FTP servers and will be respinning once fixes are in place. More analysis to follow ... regards, tom lane -

Re: [HACKERS] pgFoundry

2005-05-06 Thread Andrew Dunstan
Joshua D. Drake wrote: No that is public presentation of the project not project development. I don't see that people are going to be able to participate in development if they don't use the mailing lists. I am not arguing that but public mailing lists are no place to track status of sub proje

Re: [HACKERS] pgFoundry

2005-05-06 Thread Marc G. Fournier
On Fri, 6 May 2005, Joshua D. Drake wrote: No that is public presentation of the project not project development. I don't see that people are going to be able to participate in development if they don't use the mailing lists. I am not arguing that but public mailing lists are no place to track sta

Re: [HACKERS] pgFoundry

2005-05-06 Thread Joshua D. Drake
No that is public presentation of the project not project development. I don't see that people are going to be able to participate in development if they don't use the mailing lists. I am not arguing that but public mailing lists are no place to track status of sub projects or tasks. They are for

Re: [HACKERS] pgFoundry

2005-05-06 Thread Bruno Wolff III
On Fri, May 06, 2005 at 11:09:36 -0700, "Joshua D. Drake" <[EMAIL PROTECTED]> wrote: > Marc G. Fournier wrote: > >On Fri, 6 May 2005, Joshua D. Drake wrote: > >> > >>1. Public presentation of the project development > > > > > >Sounds like what http://www.postgresql.org is either doing, or should

Re: [HACKERS] pgFoundry

2005-05-06 Thread Chris Browne
[EMAIL PROTECTED] (Russell Smith) writes: > Because it's not the hub of PostgreSQL development. I think it will > be difficult to build a culture of "This" is the place to be unless > we actually kill gborg totally. Currently there are still projects > there, I'm personally never sure where to lo

Re: [HACKERS] Database properties not being duplicated

2005-05-06 Thread Ben Trewern
OK. It just doesn't seem obvious why. Regards, Ben "Tom Lane" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > "Ben Trewern" <[EMAIL PROTECTED]> writes: >> If I have one database say db1 and then do: >> ALTER DATABASE db1 SET DateStyle=iso, dmy; >> Then do >> CREATE DATABASE db2 TE

[HACKERS] CVS HEAD problem: psql: symbol lookup error: /usr/lib/libreadline.so.4: undefined symbol: BC

2005-05-06 Thread Oleg Bartunov
Just got this problem. Regards, Oleg _ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/ ph

Re: [HACKERS] State of Kerberos v4 support

2005-05-06 Thread Kenneth Marshall
On Fri, May 06, 2005 at 05:00:36PM +0200, Magnus Hagander wrote: > I'm working over the "kerberos service principal name" patch that's in > the queue to make it good enough for application. During which I noticed > it touches both kerberos 4 and kerberos 5 code, which leads me to two > questions: >

Re: [HACKERS] Views, views, views! (long)

2005-05-06 Thread Andrew - Supernews
On 2005-05-06, "Jim C. Nasby" <[EMAIL PROTECTED]> wrote: > But yes, the intention is to continue to support backwards compatability > as much as possible. Currently I believe that compatability stops at > versions that don't support schemas, though that could change. I have made no attempt to supp

Re: [HACKERS] pgFoundry

2005-05-06 Thread Andrew Sullivan
On Fri, May 06, 2005 at 11:35:19AM -0700, Joshua D. Drake wrote: > > FYI, a US business can rather successfully sue a Canadian one. Yes, but in Canada, only for actual violations of Canadian law. Most of the time, the practical effect of this is nothing, because the Canadian businesses have US a

Re: [HACKERS] pl/pgsql enabled by default

2005-05-06 Thread elein
I think that plpgsql should be maintained in core, enabled by default with the ability to turn it off. This handles the paranoid dba and security issue while giving the majority of people what they already have by default. Of course the dump create language statements will have to be dealt with a

Re: [HACKERS] Views, views, views! (long)

2005-05-06 Thread elein
Actually bad and good are appropriate. The structure of the system catalogs dates back to the grad student's theses and is not really good. But it is stable and does the job. It really is not user friendly, however. I reassert that I have seen only one decent schema drawing of the system catalo

Re: [HACKERS] what to do with backend flowchart

2005-05-06 Thread Bruce Momjian
I have update the backend flowchart to more closely match current CVS. The web site pulls from our CVS automatically so it should be updated soon on the web site. --- Robert Treat wrote: > On Sunday 20 March 2005 13:24, Tom

Re: [HACKERS] pgFoundry

2005-05-06 Thread Joshua D. Drake
Andrew Sullivan wrote: On Fri, May 06, 2005 at 10:01:45AM -0700, Joshua D. Drake wrote: With PostgreSQL *not* US based, we are not subject to the whim's of the US government, nor its export restrictions, nor its lawyers ... I am not even going to touch this one. Why? Because I think if you think

Re: [HACKERS] pgFoundry

2005-05-06 Thread Andrew Sullivan
On Fri, May 06, 2005 at 10:01:45AM -0700, Joshua D. Drake wrote: > >With PostgreSQL *not* US based, we are not subject to the whim's of the > >US government, nor its export restrictions, nor its lawyers ... > > I am not even going to touch this one. Why? While I wouldn't put the terms exactly t

Re: [HACKERS] pgFoundry

2005-05-06 Thread Joshua D. Drake
Marc G. Fournier wrote: On Fri, 6 May 2005, Joshua D. Drake wrote: This has been discussed several times before ... pgFoundry offers us nothing that we don't already have, Actually it does: 1. Public presentation of the project development Sounds like what http://www.postgresql.org is either d

Re: [HACKERS] Views, views, views! (long)

2005-05-06 Thread elein
On Fri, May 06, 2005 at 01:20:09AM -0500, Jim C. Nasby wrote: > On Fri, May 06, 2005 at 02:43:19AM -, Andrew - Supernews wrote: > > On 2005-05-06, Christopher Kings-Lynne <[EMAIL PROTECTED]> wrote: > > >> Hmmm ... we argued about this. I was in favor of hiding the OIDs > > >> because OIDs are

Re: [HACKERS] Do you have any objections on contributing your improvements of the PostgreSQL core back into the product?

2005-05-06 Thread Dann Corbit
The people to get in touch with are the core developers. They can easily be reached from the PostgreSQL hackers list. For the core team on the hackers list, here is a fascinating experiment which has a very clever treatment via materialized views: http://research.csc.ncsu.edu/selftune/ It could

Re: [HACKERS] Views, views, views! (long)

2005-05-06 Thread Jim C. Nasby
On Fri, May 06, 2005 at 09:08:10AM -0400, Robert Treat wrote: > On Thursday 05 May 2005 23:45, Joshua D. Drake wrote: > > > I was starting to think this... like this should be a project on foundry > > > called "enhanced system views" that would be fairly database version > > > independant and peopl

Re: [HACKERS] Proposed 'cleanup' of ftp ...

2005-05-06 Thread Robert Treat
On Thursday 05 May 2005 23:24, Marc G. Fournier wrote: > Any objections to my creating an 'old' directory and moving the old > versions into it, so that only the latest release on each 'branch' is > visible in /pub/source? > Are you going to do this to all branches or are you going to put some bra

Re: [HACKERS] Views, views, views! (long)

2005-05-06 Thread Jim C. Nasby
On Fri, May 06, 2005 at 12:21:55PM -0400, Tom Lane wrote: > "Jim C. Nasby" <[EMAIL PROTECTED]> writes: > > Aside from that, it's currently rather silly that every admin tool has > > to code up a very complex set of queries to get info from the system > > catalog. It makes much more sense to put tha

Re: [HACKERS] FC3 broken with HEAD

2005-05-06 Thread Tom Lane
Neil Conway <[EMAIL PROTECTED]> writes: > The recent ld --as-needed patch seems to break psql on FC3: it fails to > start with "symbol lookup error: /usr/lib64/libreadline.so.4: undefined > symbol: BC". You can see this on the FC3 build farm machine: Confirmed here on a pretty-nearly-up-to-date

Re: [HACKERS] pgFoundry

2005-05-06 Thread Marc G. Fournier
On Fri, 6 May 2005, Joshua D. Drake wrote: This has been discussed several times before ... pgFoundry offers us nothing that we don't already have, Actually it does: 1. Public presentation of the project development Sounds like what http://www.postgresql.org is either doing, or should be extende

Re: [HACKERS] pgFoundry

2005-05-06 Thread Joshua D. Drake
This has been discussed several times before ... pgFoundry offers us nothing that we don't already have, Actually it does: 1. Public presentation of the project development 2. Public presentation of the project bugs 3. Public presentation of the project tracker and docs Perception is everything

Re: [HACKERS] Views, views, views! (long)

2005-05-06 Thread Andreas Pflug
Tom Lane wrote: "Jim C. Nasby" <[EMAIL PROTECTED]> writes: Aside from that, it's currently rather silly that every admin tool has to code up a very complex set of queries to get info from the system catalog. It makes much more sense to put that complexity into a set of system views that are maintai

Re: [HACKERS] pl/pgsql enabled by default

2005-05-06 Thread Andrew Sullivan
On Fri, May 06, 2005 at 03:37:21PM +1000, Neil Conway wrote: > > But I agree security is not a good argument against enabling it by default. Sure it is. "Don't enable anything you don't need," is the first security rule. Everything is turned off by default. If you want it, enable it. "Enabled

Re: [HACKERS] Views, views, views! (long)

2005-05-06 Thread Tom Lane
"Jim C. Nasby" <[EMAIL PROTECTED]> writes: > Aside from that, it's currently rather silly that every admin tool has > to code up a very complex set of queries to get info from the system > catalog. It makes much more sense to put that complexity into a set of > system views that are maintained as p

Re: [HACKERS] pl/pgsql enabled by default

2005-05-06 Thread Andrew Dunstan
Tom Lane wrote: Another problem with this proposal is that installations without shared-library support will stop working entirely. How do we manage to run regression tests for such installations? I guess the philosphical question is "do we make the default the most common case and provide e

Re: [HACKERS] pl/pgsql enabled by default

2005-05-06 Thread Tom Lane
Andrew Dunstan <[EMAIL PROTECTED]> writes: > Tom Lane wrote: >> Another problem with this proposal is that installations without >> shared-library support will stop working entirely. > How do we manage to run regression tests for such installations? We don't. However, degraded functionality is

Re: [HACKERS] Views, views, views! (long)

2005-05-06 Thread Jim C. Nasby
On Fri, May 06, 2005 at 11:34:49AM -, Greg Sabino Mullane wrote: > > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > > > And what about users who's interface to PostgreSQL is psql? > > Backslash commands. There's a ton of cases the backslash commands don't cover, which others have give

Re: [HACKERS] Database properties not being duplicated

2005-05-06 Thread Tom Lane
"Ben Trewern" <[EMAIL PROTECTED]> writes: > If I have one database say db1 and then do: > ALTER DATABASE db1 SET DateStyle=iso, dmy; > Then do > CREATE DATABASE db2 TEMPLATE db1; > the DateStyle does not get carried accross to the new database. Is this a > bug? No, not in my view. We don't prop

Re: [HACKERS] pgFoundry

2005-05-06 Thread Marc G. Fournier
On Fri, 6 May 2005, Joshua D. Drake wrote: Personally, this is a problem. It's another 2 months away. In that time, I think we also need to focus on getting rid of gborg and redirecting people to pgFoundry. But can the current setup handle the load, and can we get the move from gborg done? Als

Re: [pgsql-advocacy] [HACKERS] Increased company involvement

2005-05-06 Thread Andrew Dunstan
Marc G. Fournier wrote: As far as I know, PLs or contrib files *aren't* tested by the regression tests, so, at best, they are getting 'spotty testing' right now when we release ... we know they build, that's it. And that won't change before/after ... Andrew is looking to add PL testing to the

Re: [HACKERS] pgFoundry

2005-05-06 Thread Joshua D. Drake
Personally, this is a problem. It's another 2 months away. In that time, I think we also need to focus on getting rid of gborg and redirecting people to pgFoundry. But can the current setup handle the load, and can we get the move from gborg done? Also is the upgrade path for moving servers eas

Re: [pgsql-advocacy] [HACKERS] Increased company involvement

2005-05-06 Thread Marc G. Fournier
On Fri, 6 May 2005, Dave Page wrote: Yes, but isn't the point of the so-called WTKS to pull in other projects like PL/R, libpqxx and a range of other external projects from places like Gborg? We have precisely zero control over their quality. Course we have control over it ... if it isn't up to s

Re: [pgsql-advocacy] [HACKERS] Increased company involvement

2005-05-06 Thread Marc G. Fournier
On Fri, 6 May 2005, Stephen Frost wrote: Honestly, I think WTKS will work for you, though you may end up downloading more than you want and you'll have to ignore build failures for those PLs you don't have the interpreters for. Actually, that shouldn't be an issue ... the WTKS tar ball would have a

Re: [pgsql-advocacy] [HACKERS] Increased company involvement

2005-05-06 Thread Stephen Frost
* Magnus Hagander ([EMAIL PROTECTED]) wrote: > If you are on debian or a derivative, of course. I assume we are not > planning to abandon the users who build from source. Not abandon them, no. That's where Marc's stuff comes into play really, and the WTKS stuff. > (won't using apt-get get you a

[HACKERS] Database properties not being duplicated

2005-05-06 Thread Ben Trewern
If I have one database say db1 and then do: ALTER DATABASE db1 SET DateStyle=iso, dmy; Then do CREATE DATABASE db2 TEMPLATE db1; the DateStyle does not get carried accross to the new database. Is this a bug? It seems not to matter which properties I set ie search_path, TimeZone etc. none o

Re: [HACKERS] State of Kerberos v4 support

2005-05-06 Thread Tom Lane
"Magnus Hagander" <[EMAIL PROTECTED]> writes: > 1) Does anybody actually use Kerberos v4? The last time it was proposed that we remove it, somebody popped up and said they were still using it. You could check the archives and try to contact that person for help in testing. If there's no one will

Re: [pgsql-advocacy] [HACKERS] Increased company involvement

2005-05-06 Thread Marc G. Fournier
On Fri, 6 May 2005, Magnus Hagander wrote: For PLs, usually I do. Then I activate them as they are needed. For contribs, no, I usually stick tsearch2 in there, but not many other contribs. See, me, I download/install a PL as required ... so being able to download a nice tiny file that uses my ex

Re: [HACKERS] Packages 7.2.8 thru 8.0.2 built ...

2005-05-06 Thread Tom Lane
"Marc G. Fournier" <[EMAIL PROTECTED]> writes: > On Fri, 6 May 2005, Tom Lane wrote: >> Tarballs match what I have here ... except it looks like you are >> regenerating the 7.3 HISTORY and INSTALL files using slightly different >> tools than what was committed into CVS. I'm not sure it's worth >>

Re: [HACKERS] [ADMIN] A real puzzler: ANY way to recover?

2005-05-06 Thread Geoffrey
Peter Eisentraut wrote: Tom Lane wrote: Although I dislike last-minute fixes, I am strongly tempted to put in the ignore-datallowconn-if-standalone change in all the releases we are about to make. I'm curious as to what the purpose of such a setting might be (datallowconn = false)? Any functional

Re: [pgsql-advocacy] [HACKERS] Increased company involvement

2005-05-06 Thread Dave Page
> -Original Message- > From: Marc G. Fournier [mailto:[EMAIL PROTECTED] > Sent: 06 May 2005 16:04 > To: Dave Page > Cc: Marc G. Fournier; Magnus Hagander; Robert Treat; Tom > Lane; Josh Berkus; pgsql-hackers@postgresql.org > Subject: Re: [pgsql-advocacy] [HACKERS] Increased company inv

Re: [HACKERS] 'kitchen sink' downloads (Was: Re: [pgsql-advocacy]

2005-05-06 Thread Marc G. Fournier
On Fri, 6 May 2005, Thomas Hallgren wrote: Sure. PL/Java has 2 requirements for building. One is that PostgreSQL is installed. The other is that you have either GNU GCJ or a JDK installed. These are both fine ... please note we aren't saying that it has to be pre-built, only that it can't *requir

Re: [pgsql-advocacy] [HACKERS] Increased company involvement

2005-05-06 Thread Marc G. Fournier
On Fri, 6 May 2005, Dave Page wrote: - Who/how will the release processes for all these seperate projects be coordinated? Who does now? As far as I know, PLs or contrib files *aren't* tested by the regression tests, so, at best, they are getting 'spotty testing' right now when we release ... we

Re: [pgsql-advocacy] [HACKERS] Increased company involvement

2005-05-06 Thread Magnus Hagander
> What is being worked on right now is effectively reducing > >> things down > to: > > postgresql-server (including libpq) postgresql- add on here> > >>> > >>> So you mean to get an equivalent of > >> postgresql-8.0.2.tar.bz2, I will > >>> have to download 30+ tarballs? > >> > >

[HACKERS] State of Kerberos v4 support

2005-05-06 Thread Magnus Hagander
I'm working over the "kerberos service principal name" patch that's in the queue to make it good enough for application. During which I noticed it touches both kerberos 4 and kerberos 5 code, which leads me to two questions: 1) Does anybody actually use Kerberos v4? Considering it's been declared

Re: [pgsql-advocacy] [HACKERS] Increased company involvement

2005-05-06 Thread Marc G. Fournier
On Fri, 6 May 2005, Magnus Hagander wrote: What is being worked on right now is effectively reducing things down to: postgresql-server (including libpq) postgresql- So you mean to get an equivalent of postgresql-8.0.2.tar.bz2, I will have to download 30+ tarballs? Or the WTKS one ... which will exi

Re: [HACKERS] 'kitchen sink' downloads (Was: Re: [pgsql-advocacy]

2005-05-06 Thread Thomas Hallgren
Marc G. Fournier wrote: On Fri, 6 May 2005, Thomas Hallgren wrote: Marc G. Fournier wrote: On Thu, 5 May 2005, Thomas Hallgren wrote: Marc G. Fournier wrote: But we need at least one of them ready for a standalone build first ... PL/Java might be ready. Depends on your definition of "standalone

Re: [pgsql-advocacy] [HACKERS] Increased company involvement

2005-05-06 Thread Dave Page
> -Original Message- > From: Marc G. Fournier [mailto:[EMAIL PROTECTED] > Sent: 06 May 2005 15:35 > To: Dave Page > Cc: Marc G. Fournier; Magnus Hagander; Robert Treat; Tom > Lane; Josh Berkus; pgsql-hackers@postgresql.org > Subject: RE: [pgsql-advocacy] [HACKERS] Increased company inv

Re: [HACKERS] Packages 7.2.8 thru 8.0.2 built ...

2005-05-06 Thread Marc G. Fournier
On Fri, 6 May 2005, Tom Lane wrote: "Marc G. Fournier" <[EMAIL PROTECTED]> writes: Let me know if anyone sees any problems with them ... Tarballs match what I have here ... except it looks like you are regenerating the 7.3 HISTORY and INSTALL files using slightly different tools than what was commi

Re: [pgsql-advocacy] [HACKERS] Increased company involvement

2005-05-06 Thread Magnus Hagander
> >> What is being worked on right now is effectively reducing > things down > >> to: > >> > >> postgresql-server (including libpq) > >> postgresql- > > > > So you mean to get an equivalent of > postgresql-8.0.2.tar.bz2, I will > > have to download 30+ tarballs? > > Or the WTKS one ... which w

Re: [pgsql-advocacy] [HACKERS] Increased company involvement

2005-05-06 Thread Marc G. Fournier
On Fri, 6 May 2005, Peter Eisentraut wrote: Am Donnerstag, 5. Mai 2005 23:47 schrieb Marc G. Fournier: have against is that the names could get very long: postgresql-fuzzystrmatch-8.0.2.tar.gz the postgresql part just seems redundant ... Not once you have downloaded it and don't remember where you

Re: [pgsql-advocacy] [HACKERS] Increased company involvement

2005-05-06 Thread Marc G. Fournier
On Fri, 6 May 2005, Dave Page wrote: -Original Message- From: Marc G. Fournier [mailto:[EMAIL PROTECTED] Sent: 06 May 2005 01:15 To: Magnus Hagander Cc: Marc G. Fournier; Dave Page; Robert Treat; Tom Lane; Josh Berkus; pgsql-hackers@postgresql.org Subject: Re: [pgsql-advocacy] [HACKERS] In

Re: [HACKERS] 'kitchen sink' downloads (Was: Re: [pgsql-advocacy]

2005-05-06 Thread Marc G. Fournier
On Fri, 6 May 2005, Thomas Hallgren wrote: Marc G. Fournier wrote: On Thu, 5 May 2005, Thomas Hallgren wrote: Marc G. Fournier wrote: But we need at least one of them ready for a standalone build first ... PL/Java might be ready. Depends on your definition of "standalone build" of course. Can you

Re: [pgsql-advocacy] [HACKERS] Increased company involvement

2005-05-06 Thread Stephen Frost
* Adrian Maier ([EMAIL PROTECTED]) wrote: > Once this 'wtks' will be available, I bet that most people who are > aware of its existance will prefer to download it because it would > be much more convenient.The name of the package will need > to be carefully chosen, though. "wtks" does not se

Re: [pgsql-advocacy] [HACKERS] Increased company involvement

2005-05-06 Thread Magnus Hagander
> > Remind me again how this is actually *better*, and not just making > > life a whole lot worse for me? And more specifically, for a > new user > > that doesn't know which files to download already, and will > just grab > > the default file. > > Or the new user will go 'apt-get install post

Re: [pgsql-advocacy] [HACKERS] Increased company involvement

2005-05-06 Thread Stephen Frost
* Magnus Hagander ([EMAIL PROTECTED]) wrote: > Remind me again how this is actually *better*, and not just making life > a whole lot worse for me? And more specifically, for a new user that > doesn't know which files to download already, and will just grab the > default file. Or the new user will

Re: [HACKERS] pl/pgsql enabled by default

2005-05-06 Thread Tom Lane
Neil Conway <[EMAIL PROTECTED]> writes: > But I agree security is not a good argument against enabling it by default. Isn't it? Even without anything that we regard as a bug, availability of a server-side programming language is still a risk factor from the point of view of any reasonably paranoi

Re: [pgsql-advocacy] [HACKERS] Increased company involvement

2005-05-06 Thread Peter Eisentraut
Am Donnerstag, 5. Mai 2005 23:47 schrieb Marc G. Fournier: > have against is that the names could get very long: > > postgresql-fuzzystrmatch-8.0.2.tar.gz > > the postgresql part just seems redundant ... Not once you have downloaded it and don't remember where you got it from. -- Peter Eisentrau

[HACKERS] FC3 broken with HEAD

2005-05-06 Thread Neil Conway
The recent ld --as-needed patch seems to break psql on FC3: it fails to start with "symbol lookup error: /usr/lib64/libreadline.so.4: undefined symbol: BC". You can see this on the FC3 build farm machine: http://www.pgbuildfarm.org/cgi-bin/show_log.pl?nm=viper&dt=2005-05-06%2004:47:01 My current

Re: [HACKERS] Views, views, views! (long)

2005-05-06 Thread Robert Treat
On Thursday 05 May 2005 23:45, Joshua D. Drake wrote: > > I was starting to think this... like this should be a project on foundry > > called "enhanced system views" that would be fairly database version > > independant and people could install into any databases they needed them > > in. > > You me

[HACKERS] test bed

2005-05-06 Thread Oleg Bartunov
I just talked with AMD Russia and they could provide almost any hw for testing, so I'm looking for test-suite for PostgreSQL. Do we have sort of "official" tests ? Regards, Oleg _ Oleg Bartunov, sci.researcher, host

Re: [HACKERS] Views, views, views! (long)

2005-05-06 Thread Greg Sabino Mullane
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 > And what about users who's interface to PostgreSQL is psql? Backslash commands. -BEGIN PGP SIGNATURE- iD8DBQFCeqzEvJuQZxSWSsgRAgkPAKC1V0Sm3Umi1eGFnoj1P5Qt26V32wCeMjLh +3LX4eUjgKdy+SOKHSRzRxQ= =mSNP -END PGP SIGNATURE-

Re: [HACKERS] pl/pgsql enabled by default

2005-05-06 Thread Russell Smith
On Fri, 6 May 2005 04:45 pm, Jim C. Nasby wrote: > On Fri, May 06, 2005 at 02:59:04PM +1000, Neil Conway wrote: > > Is there a good reason that pl/pgsql is not installed in databases by > > default? > > The only reason I've seen was "if we start with including plpgsql, where > do we draw the line

Re: [HACKERS] pgFoundry

2005-05-06 Thread Russell Smith
On Fri, 6 May 2005 01:32 pm, Joshua D. Drake wrote: > Hello, > > PgFoundry has been brought up quite a bit lately. How we want > it to succeed, how we want it to be the hub of PostgreSQL development. > So my question is... Why isn't it? Because it's not the hub of PostgreSQL development. I think

Re: [HACKERS] Views, views, views! (long)

2005-05-06 Thread Andreas Pflug
Christopher Kings-Lynne wrote: The unimaginable craziness of currently trying to support multiple versions of postgresql is pretty bad, Hu? So you suggest version specific admin tools? *scratch head* Just for curiosity: pgAdmin CVS currently has 80 version checked pieces of code to support 7.3/7.4

Re: [HACKERS] Views, views, views! (long)

2005-05-06 Thread Dawid Kuroczko
On 5/6/05, Greg Sabino Mullane <[EMAIL PROTECTED]> wrote: > As long as they are in a separate schema (like information_schema, > but hopefully not as long). pg_views? pg_info? information_skema? :) > > > But if you think that nobody needs these views, it's because you > > haven't had much contact

Re: [pgsql-advocacy] [HACKERS] Increased company involvement

2005-05-06 Thread Adrian Maier
On 5/6/05, Magnus Hagander <[EMAIL PROTECTED]> wrote: > > > Actually, if the number of "split files" (whatever their names) > > > > >>postgresql-WTKS.tar.gz (with the kitchen sink) file > > that contained > > >> everything for those that really wanted to download "it all" ... > > > > > > That

Re: [HACKERS] 'kitchen sink' downloads (Was: Re: [pgsql-advocacy]

2005-05-06 Thread Thomas Hallgren
Marc G. Fournier wrote: On Thu, 5 May 2005, Thomas Hallgren wrote: Marc G. Fournier wrote: But we need at least one of them ready for a standalone build first ... PL/Java might be ready. Depends on your definition of "standalone build" of course. Can you elaborate? could I download a tar file to

Re: [pgsql-advocacy] [HACKERS] Increased company involvement

2005-05-06 Thread Magnus Hagander
> > Actually, if the number of "split files" (whatever their names) > > increase even further, may I suggest they are moved into a > subdir of > > their own, keeping just the main distribution and the > README about the > > splits in the main dir? > > the "main distribution" will just be > p

Re: [pgsql-advocacy] [HACKERS] Increased company involvement

2005-05-06 Thread Dave Page
> -Original Message- > From: Marc G. Fournier [mailto:[EMAIL PROTECTED] > Sent: 06 May 2005 01:15 > To: Magnus Hagander > Cc: Marc G. Fournier; Dave Page; Robert Treat; Tom Lane; Josh > Berkus; pgsql-hackers@postgresql.org > Subject: Re: [pgsql-advocacy] [HACKERS] Increased company inv

Re: [pgsql-advocacy] [HACKERS] Increased company involvement

2005-05-06 Thread Dave Page
> -Original Message- > From: Magnus Hagander [mailto:[EMAIL PROTECTED] > Sent: 05 May 2005 22:58 > To: Marc G. Fournier; Dave Page > Cc: Robert Treat; Tom Lane; Josh Berkus; pgsql-hackers@postgresql.org > Subject: SV: [pgsql-advocacy] [HACKERS] Increased company involvement > > > p