Re: [HACKERS] linked list rewrite

2004-03-24 Thread Karel Zak
On Tue, Mar 23, 2004 at 01:16:51PM -0500, Bruce Momjian wrote: I agree a renaming of list functions is good. If we had kept the original Berkeley code as-is, we would have a lot fewer developers today. :-) Making drastic cleanups is often worthwile. I write backend code and still can't

Re: [HACKERS] linked list rewrite

2004-03-24 Thread Dustin Sallings
On Mar 23, 2004, at 11:45, Tom Lane wrote: AFAICS, though, CVS is not broken for our needs. I don't see an adequate reason to change. Yes, of course. I guess my point is that if you're going to move away from CVS, please don't just jump to ``slightly better CVS.'' I'm looking forward to a

Re: [HACKERS] [COMMITTERS] pgsql-server/ oc/src/sgml/ref/alter_table.sgml ...

2004-03-24 Thread Neil Conway
On 23-Mar-04, at 3:03 PM, Bruce Momjian wrote: Does removing SET WITHOUT OIDS cause compatibility problems? ALTER TABLE ... SET WITHOUT OIDS has not been removed. -Neil ---(end of broadcast)--- TIP 2: you can get off all lists at once with the

Re: [HACKERS] Chapter on PostreSQL in a book

2004-03-24 Thread Richard Huxton
On Wednesday 24 March 2004 01:38, Christopher Kings-Lynne wrote: I'm at a loss as to how much we should focus on these sections. Do we use what's in GBorg ? Do the hackers have any suggestions ? There are 33 DBA tools and 19 Design tools in GBorg .. are there any specific tools that are

Re: [HACKERS] where can I get the HTML docs

2004-03-24 Thread Richard Huxton
On Wednesday 24 March 2004 00:30, Paul Tillotson wrote: Can anyone show me where to download a zipped tarball of .html files of what exists at the following link? http://www.postgresql.org/docs/7.4/static/index.html Not really a hackers question, you might have been better with the -general

Re: [HACKERS] pg_advisor schema proof of concept

2004-03-24 Thread Richard Huxton
On Monday 22 March 2004 09:38, Fabien COELHO wrote: Hello hackers, please find attached a quick proof of concept for a 'pg_advisor' schema. I'm still pushing my agenda, despite lack of reaction on the list;-) I had time this week-end to improve my current 'pg_advisor' prototype schema.

Re: [HACKERS] Log rotation

2004-03-24 Thread Andrew Dunstan
This thread seems to have died without a conclusion. AFAICS, we have 5 options: . the apache program - see below pro: robust, portable, extremely well tested, no effort to import con: possible license issues, limited features . Peter Eisentraut's program pro: portable, better featured, no

Re: [HACKERS] pg_advisor schema proof of concept

2004-03-24 Thread Fabien COELHO
Dear Richard, (1) should it use pg_catalog.* or information_schema.*? Not sure portability is important, but using information_schema will presumably make it less likely that things will change between versions. Another issue I found is that, although all the contents of information_schema

Re: subversion vs cvs (Was: Re: [HACKERS] linked list rewrite)

2004-03-24 Thread Frank Wiles
On Tue, 23 Mar 2004 23:03:03 -0400 (AST) Marc G. Fournier [EMAIL PROTECTED] wrote: On Tue, 23 Mar 2004, Sailesh Krishnamurthy wrote: Which brings me to another question .. has anybody considered using subversion instead of CVS ? Why? not that I'm for a chance from something that isn't

Re: [HACKERS] pg_advisor schema proof of concept

2004-03-24 Thread Tom Lane
Fabien COELHO [EMAIL PROTECTED] writes: (1) should it use pg_catalog.* or information_schema.*? Not sure portability is important, but using information_schema will presumably make it less likely that things will change between versions. Another issue I found is that, although all the

Re: [HACKERS] Log rotation

2004-03-24 Thread Andrew Sullivan
On Wed, Mar 24, 2004 at 09:55:34AM -0500, Andrew Dunstan wrote: This thread seems to have died without a conclusion. AFAICS, we have 5 options: . the apache program - see below pro: robust, portable, extremely well tested, no effort to import con: possible license issues, limited

Re: [HACKERS] Log rotation

2004-03-24 Thread scott.marlowe
On Wed, 24 Mar 2004, Andrew Dunstan wrote: . Peter Eisentraut's program pro: portable, better featured, no license issues con: code state uncertain, less well tested Where is Peter's code available, I'd like to try it out. ---(end of

Re: [HACKERS] Chapter on PostreSQL in a book

2004-03-24 Thread Josh Berkus
Sailesh, First off, I'd suggest reopening this topic on Advocacy or Docs. Hackers is really not the list for this, and I think you'd get more feedback on those other lists. - Database Design and Querying Tools Well, I think there is no question that phpPgAdmin and pgAdminIII are our two

Re: [HACKERS] pg_advisor schema proof of concept

2004-03-24 Thread Fabien COELHO
Dear Tom, This is necessarily so, as the information_schema by definition covers only concepts standardized by the SQL spec. Since the SQL spec considers things like indexes to be implementation details, it is simply not possible for information_schema to tell you everything you want to

Re: [HACKERS] Log rotation

2004-03-24 Thread Bruce Momjian
Andrew Dunstan wrote: This thread seems to have died without a conclusion. AFAICS, we have 5 options: . the apache program - see below pro: robust, portable, extremely well tested, no effort to import con: possible license issues, limited features . Peter Eisentraut's program

Re: [HACKERS] pg_advisor schema proof of concept

2004-03-24 Thread Richard Huxton
On Wednesday 24 March 2004 15:52, Tom Lane wrote: If plpgsql works OK, I say stick with it. Hmmm. I'm not very happy with plpgsql, I don't know where you are planning on going with this. If it's only to be a contrib tool, it's okay to depend on plpgsql. But we couldn't incorporate it

[HACKERS] My chat addresses

2004-03-24 Thread Bruce Momjian
Here are my instant messaging addresses: AIM bmomjian ICQ 151255111 Yahoo bmomjian MSN [EMAIL PROTECTED] IRC bmomjian on #postgresql via FreeNode or EFNet I find it useful to help developers work on PostgreSQL and keep in touch with

Re: [HACKERS] pg_advisor schema proof of concept

2004-03-24 Thread Tom Lane
Richard Huxton [EMAIL PROTECTED] writes: On Wednesday 24 March 2004 15:52, Tom Lane wrote: I don't know where you are planning on going with this. If it's only to be a contrib tool, it's okay to depend on plpgsql. But we couldn't incorporate it into the base system because plpgsql isn't part

Re: subversion vs cvs (Was: Re: [HACKERS] linked list rewrite)

2004-03-24 Thread Dustin Sallings
On Mar 24, 2004, at 7:29, Frank Wiles wrote: [cool feature list] Arch has all of that except for the checking out part of a directory thing (would you really just check out the backend, submit a change, and not build and test it?). Additionally: * Repositories can be easily replicated so

LOOK - KITTENS! (was Re: [HACKERS] pg_advisor schema proof of concept)

2004-03-24 Thread Richard Huxton
On Wednesday 24 March 2004 18:02, Tom Lane wrote: Richard Huxton [EMAIL PROTECTED] writes: So Tom, are you suggesting: 1. A core in the base distribution (C / SQL) 2. command-line tool in the base distro (pg_advisor) 3. more open project (gborg?) to let people design/add tests, some of

Re: [HACKERS] subversion vs cvs

2004-03-24 Thread David Garamond
Sailesh Krishnamurthy wrote: I've had plenty of pain with cvs in terms of directories not being first-class etc .. but I don't really contribute to pgsql so you guys probably don't have the same experience. I was just curious as it looks like eventually subversion (or arch :-) will be an

[HACKERS] rotatelogs integration in pg_ctl

2004-03-24 Thread Andrew Hammond
I've attached a patch for pg_ctl which integrates the Apache project's rotatelogs for logging. Is there any interested in the community for such a thing? I have not yet added the appropriate stuff to autoconf to completely integrate this. I would appreciate any suggestions for improvement.

Re: subversion vs cvs (Was: Re: [HACKERS] linked list rewrite)

2004-03-24 Thread David Garamond
Dustin Sallings wrote: On Mar 24, 2004, at 11:45, David Garamond wrote: So one might ask, what *will* motivate a die-hard CVS user? A real-close Bitkeeper clone? :-) Since it's illegal for anyone who uses Bitkeeper's free license to contribute to another project, does anyone know if there

Re: [HACKERS] rotatelogs integration in pg_ctl

2004-03-24 Thread Tom Lane
Andrew Hammond [EMAIL PROTECTED] writes: I've attached a patch for pg_ctl which integrates the Apache project's rotatelogs for logging. Why bother? You just pipe pg_ctl's output to rotatelogs and you're done. regards, tom lane ---(end of

Re: subversion vs cvs (Was: Re: [HACKERS] linked list rewrite)

2004-03-24 Thread Dustin Sallings
On Mar 24, 2004, at 13:22, David Garamond wrote: From what I read here and there, BitKeeper excels primarily in merging (good merging is apparently a very complex and hard problem) and GUI stuffs. There's not a lot of GUI in arch, but star-merge is fairly incredible. This is how tla (the

[HACKERS] PostgreSQL ES3.0 problems?

2004-03-24 Thread Joshua D. Drake
Hello, About a week ago we had a report of replicator not working correctly on ES 3.0 when running with more than one CPU. Replicator worked perfectly when utilizing only one CPU. The machine was a Quad Xeon with HyperThreading, SCSI RAID array and 4 Gig of RAM. During our testing we found issues

Re: [HACKERS] pg_advisor schema proof of concept

2004-03-24 Thread Christopher Kings-Lynne
(6) possible inclusion in postgresql? - among other contributions? what about contrib/advisor? - added to template1 on default installation? maybe not for a first release? or yes? it is easier to communicate about I think we're going to want a gborg project for developing/coordinating

Re: [HACKERS] pg_advisor schema proof of concept

2004-03-24 Thread Christopher Kings-Lynne
I was thinking along the kind of missing index Tom was arguing about for RI checks, that may be helped if an appropriate index is available. I'm not sure what could be done, even with the query, in the general case. How to guess what index would help make a better plan? It depends on the optimiser

Re: [HACKERS] [GENERAL] unicode error and problem

2004-03-24 Thread Markus Bertheau
, 24.03.2004, 11:33, Paolo Supino : Hi I received a unicode CSV file from someone (the file was created on a windows system) and I'm trying to import it into postgresql. When it gets to a line that isn't ascii it prints the following error and aborts: ERROR: copy: line 33, Invalid

Re: subversion vs cvs (Was: Re: [HACKERS] linked list rewrite)

2004-03-24 Thread Christopher Kings-Lynne
It does have some downsides that I have found, most notibly that the size of your sources you have in your working copy are essentially doubled. There is a copy in your .svn directory that allows the offline status, diff, and revert commands to work. What's needed is a good window

Re: subversion vs cvs (Was: Re: [HACKERS] linked list rewrite)

2004-03-24 Thread Magnus Naeslund(t)
Christopher Kings-Lynne wrote: What's needed is a good window client like WinCVS, however... Chris There is a number of those, our shop uses (and makes programs for) both windows and unix (and might soon use mac's aswell), so it's very important that there exists a good client for each.

Re: subversion vs cvs (Was: Re: [HACKERS] linked list rewrite)

2004-03-24 Thread Dustin Sallings
On Mar 24, 2004, at 18:22, Magnus Naeslund(t) wrote: The new buzz is distributed versioning systems these days, but i question if that is called for in the vast majority of projects out there. You can use distributed revision control systems as centralized systems, but not vice-versa. But

[HACKERS] Email addresses on developer bios site

2004-03-24 Thread Christopher Kings-Lynne
On this page: http://developer.postgresql.org/bios.php Is there any chance we could get our email addresses obfuscated to prevent spam? Chris ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: subversion vs cvs (Was: Re: [HACKERS] linked list rewrite)

2004-03-24 Thread Matthew T. O'Connor
On Wednesday 24 March 2004 06:03 pm, Dustin Sallings wrote: There's not a lot of GUI in arch, but star-merge is fairly incredible. This is how tla (the main arch implementation) itself is developed. Lots of branches in lots of archives by lots of people. I would guess that better

Re: subversion vs cvs (Was: Re: [HACKERS] linked list rewrite)

2004-03-24 Thread Tom Lane
Matthew T. O'Connor [EMAIL PROTECTED] writes: I would guess that better merging might be a real motivation for people. If a patch that takes a month to develop can still apply cleanly despite significant code drift in the interrem, I could see that as a real motivating factor. Not here. You

Re: subversion vs cvs (Was: Re: [HACKERS] linked list rewrite)

2004-03-24 Thread Dustin Sallings
On Mar 24, 2004, at 20:29, Tom Lane wrote: Not here. You want me to trust some bit of code (with absolutely zero understanding of the source text it's hacking on) to figure out how to resolve conflicting patches? That sounds like a recipe for big-time unhappiness. The idea is that it's the

[HACKERS] HEAD compile troubles

2004-03-24 Thread David Fetter
Kind people, I just tried to compile HEAD on fedora, and it broke as per http://rafb.net/paste/results/W1942548.html More info... uname -a Linux fetter.org 2.4.22-1.2166.nptl #1 Fri Jan 30 13:48:31 EST 2004 i686 i686 i386 GNU/Linux gcc -v Reading specs from

Re: [HACKERS] HEAD compile troubles

2004-03-24 Thread Tom Lane
David Fetter [EMAIL PROTECTED] writes: Kind people, I just tried to compile HEAD on fedora, and it broke as per http://rafb.net/paste/results/W1942548.html Looks to me like someone got confused about ifdef ENABLE_THREAD_SAFETY versus ifdef USE_SSL ... too tired to figure it out exactly though

Re: [PERFORM] [HACKERS] fsync method checking

2004-03-24 Thread Manfred Spraul
Tom Lane wrote: [EMAIL PROTECTED] writes: I could certainly do some testing if you want to see how DBT-2 does. Just tell me what to do. ;) Just do some runs that are identical except for the wal_sync_method setting. Note that this should not have any impact on SELECT performance, only

Re: [HACKERS] [GENERAL] unicode error and problem

2004-03-24 Thread Tatsuo Ishii
By the way, Unicode is just a number - glyph mapping, it doesn't say anything about the representation of that number in the byte stream. UTF-8 and UTF-16 are such representation specifications. The encoding name in PostgreSQL should be changed from UNICODE to UTF-8 because UNICODE really