Re: [HACKERS] [PATCHES] [COMMITTERS] pgsql: Change FETCH/MOVE to use int8.

2006-09-02 Thread Tom Lane
Bruce Momjian <[EMAIL PROTECTED]> writes: > Tom Lane wrote: >> There is *no* credible use case for this (hint: MOVE FORWARD/BACKWARD >> ALL does not need this to work for >2G tables). > Already done because of bad coding. You want the TODO item removed too? As I said, I see no use case for it.

Re: [PATCHES] better support of out parameters in plperl

2006-09-02 Thread Tom Lane
Bruce Momjian <[EMAIL PROTECTED]> writes: > Uh, were are we in fixing/reviewing this? It's dead for 8.2 --- Andrew's complaints are pretty serious at both the conceptual and implementation levels, and there's been no sign of discussion about how to fix them. regards, tom l

Re: [HACKERS] [PATCHES] DOC: catalog.sgml

2006-09-02 Thread Tom Lane
"Jim C. Nasby" <[EMAIL PROTECTED]> writes: > On Fri, Sep 01, 2006 at 12:36:11PM -0400, Alvaro Herrera wrote: >> Whether a table is "bootstrap" or not doesn't seem useful to me. > Something that might be handy would be a method to determine if an > object is a system object or not (perhaps what the

Re: [PATCHES] plpgsql, return can contains any expression

2006-09-02 Thread Bruce Momjian
While this patch has new regression tests, it doesn't have new expected output for it. Please update the patch to supply that. Thanks. --- Pavel Stehule wrote: > Hello > > This patch allows using any row expression in re

Re: [PATCHES] Patch for - Change FETCH/MOVE to use int8

2006-09-02 Thread Bruce Momjian
bruce wrote: > > Patch applied. Thanks. > > I had to convert a lot of whitespace to tabs. It wasn't just the > whitespace, but whitespace that was 8 spaces. I assume you are reading > our code using an 8-space tab. Please see the developer's FAQ and try > to use tabs in future patches. Thank

Re: [HACKERS] [PATCHES] [COMMITTERS] pgsql: Change FETCH/MOVE

2006-09-02 Thread Bruce Momjian
Tom Lane wrote: > Bruce Momjian <[EMAIL PROTECTED]> writes: > >> This patch has broken half the buildfarm, and I've still not seen a > >> rationale why we need to make such a change at all. > > > Fixed with attached patch. The use case for this was not FETCH, but > > MOVE for > 2gig tables. > >

Re: [PATCHES] [COMMITTERS] pgsql: Change FETCH/MOVE to use int8.

2006-09-02 Thread Tom Lane
Bruce Momjian <[EMAIL PROTECTED]> writes: >> This patch has broken half the buildfarm, and I've still not seen a >> rationale why we need to make such a change at all. > Fixed with attached patch. The use case for this was not FETCH, but > MOVE for > 2gig tables. There is *no* credible use case

Re: [PATCHES] better support of out parameters in plperl

2006-09-02 Thread Andrew Dunstan
Like I said, at the last moment. Bruce Momjian wrote: Oh, let me add that this was first discussed on July 28: http://archives.postgresql.org/pgsql-hackers/2006-07/msg01421.php and a patch posted on July 30: http://archives.postgresql.org/pgsql-hackers/2006-07/msg01559.php

Re: [PATCHES] [DOCS] Predicate Locking

2006-09-02 Thread Bruce Momjian
Peter Eisentraut wrote: > David Fetter wrote: > > This patch clarifies the 'predicate locking' section in the docs. > > What it does it raise the question what "next-key locking is". > > I don't think any of this matters for us. We should just remove the > part that claims that no other system

Re: [PATCHES] SSL enhancement patch ver.2

2006-09-02 Thread Bruce Momjian
This has been saved for the 8.3 release: http://momjian.postgresql.org/cgi-bin/pgpatches_hold --- Victor B. Wagner wrote: > This patch adds following functionality to PostgreSQL > > 1. If PostgreSQL is compiled wit

Re: [PATCHES] better support of out parameters in plperl

2006-09-02 Thread Bruce Momjian
Oh, let me add that this was first discussed on July 28: http://archives.postgresql.org/pgsql-hackers/2006-07/msg01421.php and a patch posted on July 30: http://archives.postgresql.org/pgsql-hackers/2006-07/msg01559.php --

Re: [PATCHES] better support of out parameters in plperl

2006-09-02 Thread Bruce Momjian
OK. This has been saved for the 8.3 release: http://momjian.postgresql.org/cgi-bin/pgpatches_hold --- Andrew Dunstan wrote: > > I think it has to wait to 8.3. It's a complete mess that was submitted > unheralded

Re: [PATCHES] better support of out parameters in plperl

2006-09-02 Thread Andrew Dunstan
I think it has to wait to 8.3. It's a complete mess that was submitted unheralded at the last moment. Pavel needs to get into the habit of submitting ideas first, not just patches. And there must be proper documentation and working regression tests. cheers andrew Bruce Momjian wrote: Uh,

Re: [PATCHES] [COMMITTERS] pgsql: Change FETCH/MOVE to use int8.

2006-09-02 Thread Bruce Momjian
Tom Lane wrote: > [EMAIL PROTECTED] (Bruce Momjian) writes: > > Log Message: > > --- > > Change FETCH/MOVE to use int8. > > This patch has broken half the buildfarm, and I've still not seen a > rationale why we need to make such a change at all. Fixed with attached patch. The use case fo

Re: [HACKERS] [PATCHES] extension for sql update

2006-09-02 Thread Bruce Momjian
bruce wrote: > I have merged your patch into current CVS and applied it; attached. > There was quite a bit of code drift. One drift area was the new > RETURNING clause; that was easy to fix. A more complex case is the > code no longer has values as ResTargets --- it is a simple a_expr list, > s

Re: [PATCHES] Backend SSL configuration enhancement

2006-09-02 Thread Bruce Momjian
This has been saved for the 8.3 release: http://momjian.postgresql.org/cgi-bin/pgpatches_hold --- Victor B. Wagner wrote: > On 2006.08.30 at 10:14:02 -0400, Tom Lane wrote: > > > "Victor B. Wagner" <[EMAIL PROTECTE

Re: [HACKERS] [PATCHES] DOC: catalog.sgml

2006-09-02 Thread Jim C. Nasby
On Fri, Sep 01, 2006 at 12:36:11PM -0400, Alvaro Herrera wrote: > Tom Lane wrote: > > Zdenek Kotala <[EMAIL PROTECTED]> writes: > > > I little bit enhanced overview catalog tables. I added two new columns. > > > First one is OID of catalog table and second one contains attributes > > > which dete

Re: [HACKERS] [PATCHES] Use of backslash in tsearch2

2006-09-02 Thread Bruce Momjian
Thanks. Yes, it is need for two reasons. In 8.2 you can set standard_conforming_strings to on, meaning \' is really treated as \ and ', and because some encodings now can't support \' for security reasons, though I don't think tsearch2 supports those multibyte encodings. Anyway, applied to 8.2

Re: [PATCHES] [HACKERS] proposal - plpgsql: execute using

2006-09-02 Thread Bruce Momjian
So the patch is being withdrawn by the author? OK. --- Pavel Stehule wrote: > Hello, > > This task can be better solved. There are some problems with strings, but > bigger problem is impossibility to pass nonscalar variab

Re: [PATCHES] Concurrent connections in psql patch

2006-09-02 Thread Bruce Momjian
Is this something people are interested in? I am thinking no based on the lack of requests and the size of the patch. --- Gregory Stark wrote: > > Andrew Dunstan <[EMAIL PROTECTED]> writes: > > > stark wrote: > > > > > So

Re: [PATCHES] [Fwd: dblink patch - Asynchronous queries and parallel

2006-09-02 Thread Joe Conway
Joe Conway wrote: Sorry for the delay. I've done some rework to the original code sent by Kai, mainly to reduce duplication with the existing synchronous case, and to better fit with the existing docs, regression script, etc. I also changed the return type of dblink_get_connections() to text[],

Re: [HACKERS] [PATCHES] extension for sql update

2006-09-02 Thread Bruce Momjian
Susanne Ebrecht wrote: > >> Is it too hard to rip it back out once the full row support > >> arrives? That seems speculation at best anyway. > >> > > That's what I was thinking. Glad someone else replied. ;-) > > > If you're looking for votes, +1.

Re: [PATCHES] Patch for - Change FETCH/MOVE to use int8

2006-09-02 Thread Bruce Momjian
Patch applied. Thanks. I had to convert a lot of whitespace to tabs. It wasn't just the whitespace, but whitespace that was 8 spaces. I assume you are reading our code using an 8-space tab. Please see the developer's FAQ and try to use tabs in future patches. Thanks. ---

Re: [PATCHES] [HACKERS] Custom variable class segmentation

2006-09-02 Thread Bruce Momjian
Where are we on the GUC comment/reload to defaults patch? Do we have multiple people objecting to its application? Previously only Tom objected, and Andrew partially. --- Bruce Momjian wrote: > Tom Lane wrote: > > Michael

Re: [PATCHES] better support of out parameters in plperl

2006-09-02 Thread Bruce Momjian
Uh, were are we in fixing/reviewing this? --- Andrew Dunstan wrote: > > > I wrote: > > Pavel Stehule wrote: > >> Hello, > >> > >> I send two small patches. First does conversion from perl to > >> postgresql array in OUT p

Re: [PATCHES] pgstattuple extension for indexes

2006-09-02 Thread Bruce Momjian
Patch applied. Thanks. I updated the README documentation for the new functions, attached. I could not update the Japanese version of the README. --- Satoshi Nagayasu wrote: > Bruce, > > Attached patch has been cleaned

Re: [HACKERS] [PATCHES] Resurrecting per-page cleaner for

2006-09-02 Thread Tom Lane
Bruce Momjian <[EMAIL PROTECTED]> writes: > Tom, should I apply this patch now? Are you still considering other > options for this? Please wait. This issue is very far down the to-list in terms of size or significance ... but I'll get to it. regards, tom lane --

Re: [PATCHES] New variable server_version_num

2006-09-02 Thread Bruce Momjian
Patch applied. Thanks. --- Greg Sabino Mullane wrote: -- Start of PGP signed section. > Today on IRC David Fetter and some others were discussing version > numbers and we realized that although libpq now provides the versi

Re: [HACKERS] [PATCHES] Resurrecting per-page cleaner for

2006-09-02 Thread Bruce Momjian
Tom, should I apply this patch now? Are you still considering other options for this? --- Bruce Momjian wrote: > > Tom, I ran your tests with fsync off (as you did), and saw numbers > bouncing between 400-700 tps without m

Re: [PATCHES] plpython improvements

2006-09-02 Thread Bruce Momjian
Sven Suursoho wrote: > Hi, > > > Quoting Bruce Momjian <[EMAIL PROTECTED]>: > > > Great. Please supply documentation and it will be applied. Thanks. > > Here it comes, including src+doc patches. > Updated sources according to Michael Fuhr's comments and fixed one FIXME. > > Please check docu