[PATCHES] Small documentation patch

2003-12-02 Thread David Fetter
Kind people, This patch shows how to change UNIX timestamps into PostgreSQL timestamps, and clarifies how PERFORM works in PL/PgSQL. :) Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 510 893 6100cell: +1 415 235 3778 Index: func.sgml

Re: [PATCHES] Small documentation patch

2003-12-03 Thread David Fetter
is good, too :) :) Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 510 893 6100cell: +1 415 235 3778 ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [PATCHES] Small documentation patch

2003-12-03 Thread David Fetter
is coming from a variable. Great! I am not attached to any particular way of doing this, just as long as some clue about converting UNIX timestamps into PostgreSQL timestamps gets in there :) Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 510 893 6100cell: +1 415 235 3778

[PATCHES] Unix timestamp - timestamp, per Tom Lane :)

2003-12-04 Thread David Fetter
Folks, 'nother one. Thanks very much, Tom! :) Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 510 893 6100cell: +1 415 235 3778 ? func_unixtimestamp.patch Index: func.sgml === RCS file: /projects

Re: [PATCHES] Unix timestamp - timestamp, per Tom Lane :)

2003-12-04 Thread David Fetter
On Thu, Dec 04, 2003 at 10:21:46PM +0100, Peter Eisentraut wrote: David Fetter writes: Folks, 'nother one. Thanks very much, Tom! :) Cheers, D Can you adjust the patch so that it contains only the relevant parts and creates valid DocBook? OK. How do I test this? After make

[PATCHES] YA Doc patch

2003-12-04 Thread David Fetter
Kind people, I hope this one actually does what Tom said. It appears to work :) Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 510 893 6100cell: +1 415 235 3778 Index: func.sgml === RCS file

[PATCHES] Doc patch--clarifying $1 in PL/PgSQL

2003-12-22 Thread David Fetter
Kind people, Please find enclosed this patch from Alex J. Avriette :) Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 510 893 6100cell: +1 415 235 3778 --- plpgsql.sgml.orig Mon Dec 22 16:27:50 2003 +++ plpgsql.sgmlMon Dec 22 16:38:48 2003 @@ -572,7 +572,7

Re: [PATCHES] Doc patch--clarifying $1 in PL/PgSQL

2003-12-22 Thread David Fetter
On Mon, Dec 22, 2003 at 05:50:12PM -0500, Tom Lane wrote: David Fetter [EMAIL PROTECTED] writes: + Note that it is not possible to assign function arguments during + a literalDECLARE/ block. Seems to me this is a bug that should be fixed, not documented. I got the impression

[PATCHES] Patch for psql startup clarity

2004-01-30 Thread David Fetter
Kind people, Here's a minor patch for psql and related files that turns instances of \? for help on internal slash commands into \? for help on internal slash (i.e. psql) commands I think this makes it clearer exactly what \? does and how it's different from \h Cheers, D -- David Fetter

Re: [PATCHES] Patch for psql startup clarity

2004-01-30 Thread David Fetter
On Fri, Jan 30, 2004 at 11:53:19PM +0100, Markus Bertheau wrote: В Птн, 30.01.2004, в 23:45, David Fetter пишет: \? for help on internal slash (i.e. psql) commands I think it should be \? for help with psql commands That was my 1st thought, but wanted to make a minimal change. Yours

Re: [PATCHES] Patch for psql startup clarity

2004-02-01 Thread David Fetter
In article [EMAIL PROTECTED] you wrote: On Fri, Jan 30, 2004 at 11:53:19PM +0100, Markus Bertheau wrote: ?? ??, 30.01.2004, ?? 23:45, David Fetter ??: \? for help on internal slash (i.e. psql) commands I think it should be \? for help with psql commands That was my 1st

Re: [PATCHES] Patch for psql startup clarity

2004-02-01 Thread David Fetter
On Sun, Feb 01, 2004 at 08:09:44PM +0100, Peter Eisentraut wrote: Markus Bertheau wrote: В Птн, 30.01.2004, в 23:45, David Fetter пишет: \? for help on internal slash (i.e. psql) commands I think it should be \? for help with psql commands firstly because the adjective internal

Re: [PATCHES] Patch for psql startup clarity

2004-02-02 Thread David Fetter
On Mon, Feb 02, 2004 at 03:12:41PM +0100, Peter Eisentraut wrote: David Fetter wrote: \? for help with psql commands If you wanted to pick one of the two patches, which one would it be? If not, what should the patch look like? There seems to be a consensus on the form left standing

[PATCHES] Dollar Quoting doc patch--resend.

2004-05-05 Thread David Fetter
Neil, Here it is :) Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 510 893 6100 mobile: +1 415 235 3778 Remember to vote! Index: doc/src/sgml/plperl.sgml === RCS file: /projects/cvsroot/pgsql-server/doc

Re: [PATCHES] Dollar Quoting doc patch--resend.

2004-05-05 Thread David Fetter
On Wed, May 05, 2004 at 10:42:56AM -0400, Bruce Momjian wrote: Neil Conway wrote: On 5-May-04, at 2:26 AM, David Fetter wrote: Here it is :) Looks good for the most part. A few minor quibbles / suggestions: - Where an example uses double-quotes in a function body, we ought

Re: [PATCHES] YA dollar quoting patch

2004-05-16 Thread David Fetter
On Sat, May 15, 2004 at 05:45:00PM -0400, Neil Conway wrote: On Fri, 2004-05-14 at 13:14, David Fetter wrote: Pursuant to suggestions. I've attached the version of this patch I intend to apply as soon as CVS is back up. Thanks for the patch, David. And thank you for all the help

[PATCHES] Dollar quoting docs, round 1

2004-04-27 Thread David Fetter
Kind people, Please find attached a diff to the SGML docs that attempts to go over the new dollar quoting feature. In eager anticipation of comments feedback, I remain, Your Humble Servant, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 510 893 6100 mobile: +1 415 235 3778

Re: [PATCHES] Dollar Quoting doc patch--resend.

2004-05-05 Thread David Fetter
to that question is yes. Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 510 893 6100 mobile: +1 415 235 3778 Remember to vote! ---(end of broadcast)--- TIP 6: Have you searched our list archives? http

[PATCHES] Docs for PL/Perl

2004-07-19 Thread David Fetter
Kind people, Please find enclosed a patch that matches the PL/Perl documentation (fairly closely, I hope) to the current PL/Perl implementation. Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 510 893 6100 mobile: +1 415 235 3778 Remember to vote! Index: doc/src/sgml

[PATCHES] Create Domain example

2004-08-06 Thread David Fetter
Kind people, This patch adds an example to the CREATE DOMAIN docs. Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 510 893 6100 mobile: +1 415 235 3778 Remember to vote! Index: create_domain.sgml === RCS

[PATCHES] Tutorial patch

2004-08-06 Thread David Fetter
Folks, This adds a caveat to the inheritance part of the tutorial. Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 510 893 6100 mobile: +1 415 235 3778 Remember to vote! Index: advanced.sgml === RCS file

[PATCHES] Intro patch

2004-08-06 Thread David Fetter
Folks, This patch adds SQL2003 to the set of standards with which PostgreSQL is attempting to comply. Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 510 893 6100 mobile: +1 415 235 3778 Remember to vote! Index: intro.sgml

[PATCHES] PL/Perl document patch

2004-08-13 Thread David Fetter
Kind people, The enclose patch clarifies and makes a more useful example for the Global Values in PL/Perl section of the documents. Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 510 893 6100 mobile: +1 415 235 3778 Remember to vote! ? plperl.diff Index: plperl.sgml

[PATCHES] Clarification of the PL/Perl documents

2004-09-29 Thread David Fetter
Folks, This patch clarifies the usage of references in PL/Perl :) Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 510 893 6100 mobile: +1 415 235 3778 Remember to vote! ? plperl.diff Index: doc/src/sgml/plperl.sgml

[PATCHES] Example of function returning SETOF RECORD

2004-10-21 Thread David Fetter
Folks, Here's a patch that adds an example of using SETOF RECORD with the needed grammar. Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 510 893 6100 mobile: +1 415 235 3778 Remember to vote! ? setof_record.diff Index: doc/src/sgml/xfunc.sgml

Re: [PATCHES] Example of function returning SETOF RECORD

2004-10-21 Thread David Fetter
On Thu, Oct 21, 2004 at 09:26:39PM -0700, David Fetter wrote: Folks, Here's a patch that adds an example of using SETOF RECORD with the needed grammar. Oops. Please ignore previous patch. Here's the right one. Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 510

Re: [PATCHES] Docs - Plpgsql trigger example auditing changes into

2004-12-03 Thread David Fetter
automating the creation, etc. of the auditing infrastructure :) Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 510 893 6100 mobile: +1 415 235 3778 Remember to vote! ---(end of broadcast)--- TIP 8: explain analyze

[PATCHES] PL/Perl document patch

2004-12-10 Thread David Fetter
Folks, Please find enclosed a patch to the pl/perl documents that clafies the scope of global data and gives an example of storing a code reference. Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 510 893 6100 mobile: +1 415 235 3778 Remember to vote! Index: doc/src

[PATCHES] Example of ALTER COLUMN TYPE with USING

2005-01-12 Thread David Fetter
Folks, This patch adds an example of ALTER COLUMN TYPE with a USING clause. Thanks to Tom Lane both for writing the feature and making sure I got it documented right :) Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 510 893 6100 mobile: +1 415 235 3778 Remember

[PATCHES] Returning multiple cursors from PL/PgSQL

2005-01-12 Thread David Fetter
Folks, Please find attached an example that allows people to return multiple named refcursors from a function. Big kudos to Kris Jurka for figuring this out and pasting to rafb :) Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 510 893 6100 mobile: +1 415 235 3778

Re: [PATCHES] Returning multiple cursors from PL/PgSQL

2005-01-13 Thread David Fetter
On Wed, Jan 12, 2005 at 09:33:30PM -0800, David Fetter wrote: Folks, Please find attached an example that allows people to return multiple named refcursors from a function. Big kudos to Kris Jurka for figuring this out and pasting to rafb :) Oops. Joe Conway pointed out that this patch

Re: [PATCHES] Returning multiple cursors from PL/PgSQL

2005-01-13 Thread David Fetter
On Thu, Jan 13, 2005 at 01:44:58PM -0500, Tom Lane wrote: David Fetter [EMAIL PROTECTED] writes: Please find attached an example that allows people to return multiple named refcursors from a function. Big kudos to Kris Jurka for figuring this out and pasting to rafb :) Oops. Joe

[PATCHES] PL/Perl doc patch

2005-01-16 Thread David Fetter
Folks, Please find enclosed a patch to the pl/perl documents that correctly tells what arguments go to pl/perl triggers. Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 510 893 6100 mobile: +1 415 235 3778 Remember to vote! Index: doc/src/sgml/plperl.sgml

Bag-over-head patch (was Re: [PATCHES] PL/Perl doc patch)

2005-01-17 Thread David Fetter
to the previous patch. Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 510 893 6100 mobile: +1 415 235 3778 Remember to vote! Index: doc/src/sgml/plperl.sgml === RCS file: /projects/cvsroot/pgsql/doc/src/sgml

[PATCHES] Clarify use of NOW() in pl/pgsql docs

2005-01-27 Thread David Fetter
Folks, This one from Ben Calvert. It uses the (imho clearer) NOW() rather than 'NOW' in a PL/PgSQL function example. Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 510 893 6100 mobile: +1 415 235 3778 Remember to vote! Index: doc/src/sgml/plpgsql.sgml

[PATCHES] Change to -f in examples with input files

2005-02-20 Thread David Fetter
Folks, Please find enclosed a patch, per Dennis Björklund, that uses -f for input files rather than . This makes error messages, c. more expressive. Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 510 893 6100 mobile: +1 415 235 3778 Remember to vote! Index: doc/src

Re: [PATCHES] Change to -f in examples with input files

2005-02-21 Thread David Fetter
On Mon, Feb 21, 2005 at 02:18:31PM -0500, Bruce Momjian wrote: David Fetter wrote: Please find enclosed a patch, per Dennis BjC3B6rklund, that uses -f for input files rather than . This makes error messages, c. more expressive. Uh, how is it more expressive? The only difference I

Re: [PATCHES] [BUGS] typos in the docu

2005-03-02 Thread David Fetter
-w kernel.shmmax=134217728 $ systcl -w kernel.shmall=2097152 systcl is wrong sysctl notStefan Patch attached. Thanks, Stefan :) Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 510 893 6100 mobile: +1 415 235 3778 Remember to vote! ? sysctl.diff Index: doc/src

Re: [PATCHES] [HACKERS] Best practices: MERGE

2005-03-08 Thread David Fetter
. Pursuant to an IRC discussion to which Dennis Bjorklund and Christopher Kings-Lynne made most of the contributions, please find enclosed an example patch demonstrating an UPSERT-like capability. Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 510 893 6100 mobile: +1 415 235

[PATCHES] Clean up SGML for openjade

2005-03-13 Thread David Fetter
Folks, Please find enclosed a patch that fixes the SGML so openjade doesn't complain :) Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 510 893 6100 mobile: +1 415 235 3778 Remember to vote! ? GNUmakefile ? clean_sgml.diff ? config.log ? config.status ? upsert.diff

[PATCHES] [EMAIL PROTECTED]: Clean up SGML for openjade]

2005-03-13 Thread David Fetter
Please find enclosed a patch that fixes the SGML so openjade doesn't complain :) Oops. Here's one without the extra dross. Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 510 893 6100 mobile: +1 415 235 3778 Remember to vote! Index: doc/src/sgml/charset.sgml

[PATCHES] Approximate count(*)

2005-03-24 Thread David Fetter
Folks, Please find enclosed a patch that shows how to get a quick approximation of count(*) on a table. Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 510 893 6100 mobile: +1 415 235 3778 Remember to vote! Index: doc/src/sgml/func.sgml

Re: [PATCHES] [DOCS] Approximate count(*)

2005-03-24 Thread David Fetter
On Thu, Mar 24, 2005 at 12:34:51PM -0500, Tom Lane wrote: David Fetter [EMAIL PROTECTED] writes: Please find enclosed a patch that shows how to get a quick approximation of count(*) on a table. I'm not sure we should be encouraging people to look at reltuples... for one thing, it's

Re: [PATCHES] Problem with Create Domain example

2005-04-30 Thread David Fetter
is maintainable :) Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 510 893 6100 mobile: +1 415 235 3778 Remember to vote! ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate

Re: [PATCHES] regexp_replace

2005-06-06 Thread David Fetter
---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 510 893 6100 mobile: +1 415 235 3778 Remember to vote

Re: [PATCHES] plperl better array support

2005-06-20 Thread David Fetter
NULL support to postgresql arrays than to handle undefs in perl arrays automagically? Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 510 893 6100 mobile: +1 415 235 3778 Remember to vote! ---(end of broadcast)--- TIP 8

[PATCHES] Doc patch: New PL/Perl Features

2005-07-12 Thread David Fetter
Folks, Please find enclosed document patches for PL/Perl features recently introduced in CVS TIP. These include: return_next returning PostgreSQL arrays spi_query/spi_fetchrow use strict Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 510 893 6100 mobile: +1 415 235

Re: [PATCHES] Doc patch: New PL/Perl Features

2005-07-12 Thread David Fetter
On Tue, Jul 12, 2005 at 12:21:29PM -0700, David Fetter wrote: Folks, Please find enclosed document patches for PL/Perl features recently introduced in CVS TIP. These include: return_next returning PostgreSQL arrays spi_query/spi_fetchrow use strict Cheers, D Oops. Persuant

Re: [PATCHES] [HACKERS] PL/Perl list value return causes segfault

2005-07-29 Thread David Fetter
that these will all go into memory. That's no longer true. Please find enclosed a new patch :) Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 510 893 6100 mobile: +1 415 235 3778 Remember to vote! Index: doc/src/sgml/plperl.sgml

Re: [PATCHES] [HACKERS] PL/Perl list value return causes segfault

2005-07-30 Thread David Fetter
On Sat, Jul 30, 2005 at 09:47:58AM -0400, Andrew Dunstan wrote: David Fetter wrote: You have rolled 2 problems into one - spi_query+spi_fetchrow does not address the issue of returning large data sets. Suggest instead: [suggestion] Revised patch attached. Thanks for catching

Re: [PATCHES] [HACKERS] Improved \df(+) in psql + backward-compatibility

2005-08-29 Thread David Fetter
On Mon, Aug 29, 2005 at 11:13:29AM -0400, Tom Lane wrote: David Fetter [EMAIL PROTECTED] writes: I've noticed that \df doesn't do quite what it might when a function is created with named input parameters. Please find enclosed a patch against CVS TIP that does this better. Meanwhile

Re: [PATCHES] [HACKERS] Improved \df(+) in psql + backward-compatibility

2005-08-29 Thread David Fetter
On Mon, Aug 29, 2005 at 08:12:37AM -0400, Robert Treat wrote: On Monday 29 August 2005 00:33, Tom Lane wrote: David Fetter [EMAIL PROTECTED] writes: On a slightly related note, I've noticed that psql isn't backward compatible. We have never expected psql's \d commands to work against

[PATCHES] Improved \df(+) in psql + backward-compatibility

2005-08-28 Thread David Fetter
to be introducing things, but I consider this a bug, and would like to send in more fixes. What do you all think? Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 510 893 6100 mobile: +1 415 235 3778 Remember to vote! Index: src/bin/psql/describe.c

[PATCHES] Caveat for Domains

2005-09-09 Thread David Fetter
Folks, I think this needs to be made explicit in the documentation. Better, of course, would be some kind of change to the PL infrastructure that Just Handles It, but until then Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 510 893 6100 mobile: +1 415 235 3778

[PATCHES] Clarifying Autovacuum docs in the release notes

2005-09-11 Thread David Fetter
Folks, Please find attached a patch which tells about what the spiffy, integrated autovacuum now does :) Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 510 893 6100 mobile: +1 415 235 3778 Remember to vote! ? autovacuum.diff ? d0m41n_fux0r3d.diff Index: doc/src/sgml

[PATCHES] Multiple -t options for pg_dump

2005-09-20 Thread David Fetter
Folks, Please find enclosed a patch against CVS TIP that allows people to specify more than one table via pg_dump -t. Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 510 893 6100 mobile: +1 415 235 3778 Remember to vote! Index: doc/src/sgml/ref/pg_dump.sgml

Re: [PATCHES] Multiple -t options for pg_dump

2005-09-20 Thread David Fetter
at 08:51 -0700, David Fetter wrote: /* obsolete as of 7.3: */ static Oidg_last_builtin_oid; /* value of the last builtin oid */ ! static char **selectTableNames = NULL;/* name(s) of specified table(s) to dump */ ! int tab_max = 0, tab_idx = 0; ! static

Re: [PATCHES] [HACKERS] statement logging / extended query protocol

2005-09-26 Thread David Fetter
how logging output has to be backward compatible. Dunno about this particular case, but not having backward-compatible logging output has already broken pqa. Proposal on logging to -hackers follows... Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 510 893 6100

Re: [PATCHES] [HACKERS] statement logging / extended query protocol

2005-09-27 Thread David Fetter
On Mon, Sep 26, 2005 at 11:50:01PM +0200, [EMAIL PROTECTED] wrote: David Fetter [EMAIL PROTECTED] wrote on 26.09.2005, 18:31:16: On Sun, Sep 25, 2005 at 11:41:11PM -0400, Bruce Momjian wrote: Tom Lane wrote: Bruce Momjian writes: OK. At this stage it should all just wait for 8.2

Re: [PATCHES] SQL/XML publishing function experimental patch II

2005-09-29 Thread David Fetter
On Wed, Sep 28, 2005 at 04:30:54PM +0200, Pavel Stehule wrote: Hello base type changed to text, better registration xmlagg function Interesting. The SGML docs appear to be machine-generated stubs. Could you point to a reference for them so they can be filled in? Cheers, D -- David Fetter

Re: [PATCHES] SQL/XML publishing function experimental patch II

2005-10-02 Thread David Fetter
On Wed, Sep 28, 2005 at 04:30:54PM +0200, Pavel Stehule wrote: Hello base type changed to text, better registration xmlagg function Regards Pavel Stehule Now with some slightly improved documentation, works vs. CVS tip as of this writing. Cheers, D -- David Fetter [EMAIL PROTECTED] http

Re: [PATCHES] [HACKERS] External Sort timing debug statements

2005-10-03 Thread David Fetter
debug_sort=true; I'm a bit inclined to call it trace_sort instead, and to document it under Developer Options. Comments? +1 Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 510 893 6100 mobile: +1 415 235 3778 Remember to vote! ---(end

Re: [PATCHES] [HACKERS] Best practices: MERGE

2005-10-04 Thread David Fetter
. --- David Fetter wrote: On Tue, Mar 08, 2005 at 12:27:21PM +0800, Christopher Kings-Lynne wrote: Luckily, PG 8 is available for this. Do you have a short example? No, and I think it should be in the manual as an example. You will need to enter a loop

Re: [PATCHES] [HACKERS] Patching dblink.c to avoid warning about open transaction

2005-10-06 Thread David Fetter
connection and function-local 'conn' structures in favor of using rconn consistently. This cleans up a lot of error-prone code that tried to track what type of connection was being used. I don't know if people want this for 8.1 or 8.2. 8.1, IMHO. It's a bug fix. :) Cheers, D -- David Fetter

Re: [PATCHES] [HACKERS] Patching dblink.c to avoid warning about open transaction

2005-10-06 Thread David Fetter
On Thu, Oct 06, 2005 at 11:31:46PM -0400, Tom Lane wrote: David Fetter [EMAIL PROTECTED] writes: On Thu, Oct 06, 2005 at 10:38:54PM -0400, Bruce Momjian wrote: I don't know if people want this for 8.1 or 8.2. 8.1, IMHO. It's a bug fix. :) Not unless Joe Conway signs off

Re: [PATCHES] suggested warning about perl nested named subroutines

2005-10-11 Thread David Fetter
the function body to be written as a string constant. It is usually ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq -- David Fetter [EMAIL PROTECTED] http://fetter.org

Re: [PATCHES] suggested warning about perl nested named subroutines

2005-10-11 Thread David Fetter
On Tue, Oct 11, 2005 at 09:58:22PM -0400, Neil Conway wrote: On Tue, 2005-11-10 at 18:36 -0700, David Fetter wrote: Examples of each and how they'd break would be good. Is that needed? Seems like overkill to me. IMHO, yes, and no, respectively. If there's an example, there's fewer

Re: [PATCHES] suggested warning about perl nested named subroutines

2005-10-11 Thread David Fetter
On Tue, Oct 11, 2005 at 10:01:02PM -0400, Andrew Dunstan wrote: David Fetter wrote: On Tue, Oct 11, 2005 at 09:58:22PM -0400, Neil Conway wrote: On Tue, 2005-11-10 at 18:36 -0700, David Fetter wrote: Examples of each and how they'd break would be good. Is that needed? Seems like

Re: [PATCHES] Caveat for Domains

2005-10-19 Thread David Fetter
On Thu, Sep 22, 2005 at 07:57:35PM -0400, Bruce Momjian wrote: Patch applied. Thanks. Could you please put fixing domains for functions on the TODO list? Cheers, D --- David Fetter wrote: Folks, I think

[PATCHES] Error in trigger example

2005-10-20 Thread David Fetter
Folks, Please find enclosed a patch that fixes the trigger example in plpgsql (emp_stamp). Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 510 893 6100 mobile: +1 415 235 3778 Remember to vote! Index: doc/src/sgml/plpgsql.sgml

Re: [PATCHES] Error in trigger example

2005-10-20 Thread David Fetter
On Thu, Oct 20, 2005 at 08:03:13PM -0400, Tom Lane wrote: David Fetter [EMAIL PROTECTED] writes: Please find enclosed a patch that fixes the trigger example in plpgsql (emp_stamp). Uh ... that example is not broken. If we were going to change it, I'd favor current_timestamp over either

[PATCHES] Patch to allow contrib/pgbench files to have blank lines

2005-11-22 Thread David Fetter
Folks, Having blank lines in -f scripts was causing silent failures. This fixes it, for some value of fixes. If it's OK, please apply to 8.1 CURRENT and CVS TIP :) Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 415 235 3778 Remember to vote! Index: contrib/pgbench

Re: [PATCHES] Patch to allow contrib/pgbench files to have blank lines

2005-12-09 Thread David Fetter
. Please apply the following patch that removes an unneeded (and broken) counter increment. Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 415 235 3778 Remember to vote! Index: contrib/pgbench/pgbench.c === RCS

[PATCHES] psql patch: new host/port without leaving session

2005-12-13 Thread David Fetter
use psql as an administrative tool. Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 415 235 3778 Remember to vote! Index: doc/src/sgml/ref/psql-ref.sgml === RCS file: /projects/cvsroot/pgsql/doc/src/sgml/ref

Re: [PATCHES] PLpgSQL: list of scalars as row for assign stmt, fore

2005-12-22 Thread David Fetter
) := r; Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 415 235 3778 Remember to vote! ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining

[PATCHES] Example for UPDATE FROM with correllation

2006-01-12 Thread David Fetter
Folks, Please find enclosed a doc patch that adds an example of a correllated UPDATE. Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 415 235 3778 Remember to vote! Index: doc/src/sgml/ref/update.sgml

[PATCHES] Uninstall scripts for contrib

2006-01-15 Thread David Fetter
to discuss what an uninstall script (if any) would look like for those. Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 415 235 3778 Remember to vote! Index: contrib/btree_gist/Makefile === RCS file: /oracle/CVSup

Re: [PATCHES] Uninstall scripts for contrib

2006-01-15 Thread David Fetter
On Mon, Jan 16, 2006 at 12:13:11AM -0500, Neil Conway wrote: On Sun, 2006-01-15 at 20:08 -0800, David Fetter wrote: ifdef USE_PGXS The change to $PostgreSQL$ is bogus (perhaps due to the way you setup cvsup?), as are all the other $PostgreSQL$ changes in the patch. Also, the patch

Re: [PATCHES] Uninstall scripts for contrib

2006-01-19 Thread David Fetter
On Thu, Jan 19, 2006 at 02:22:17PM +0100, Peter Eisentraut wrote: Am Montag, 16. Januar 2006 06:55 schrieb David Fetter: Oops. My FM R'ing skills need some work. This patch includes the files. This patch is rather useless because all the uninstall.sql files install on top of each other

Re: [PATCHES] Uninstall scripts for contrib

2006-01-19 Thread David Fetter
On Thu, Jan 19, 2006 at 07:08:28PM +0100, Peter Eisentraut wrote: David Fetter wrote: It's paper bag time for me. How about a new patch which gives each contrib project its own directory and places them there? This would presumably imply that the installation scripts would be renamed

Re: [PATCHES] Uninstall scripts for contrib

2006-01-24 Thread David Fetter
On Sun, Jan 15, 2006 at 09:55:39PM -0800, David Fetter wrote: On Mon, Jan 16, 2006 at 12:13:11AM -0500, Neil Conway wrote: On Sun, 2006-01-15 at 20:08 -0800, David Fetter wrote: ifdef USE_PGXS The change to $PostgreSQL$ is bogus (perhaps due to the way you setup cvsup

Re: [PATCHES] [BUGS] BUG #2221: Bad delimiters allowed in COPY ... TO

2006-01-29 Thread David Fetter
On Sun, Jan 29, 2006 at 09:50:08PM +, David Fetter wrote: The following bug has been logged online: Bug reference: 2221 Logged by: David Fetter Email address: [EMAIL PROTECTED] PostgreSQL version: all Operating system: all Description:Bad delimiters

Re: [PATCHES] [BUGS] BUG #2221: Bad delimiters allowed in COPY ... TO

2006-01-29 Thread David Fetter
On Sun, Jan 29, 2006 at 04:41:43PM -0800, David Fetter wrote: On Sun, Jan 29, 2006 at 09:50:08PM +, David Fetter wrote: The following bug has been logged online: Bug reference: 2221 Logged by: David Fetter Email address: [EMAIL PROTECTED] PostgreSQL version

Re: [PATCHES] [BUGS] BUG #2221: Bad delimiters allowed in COPY ...

2006-01-29 Thread David Fetter
On Sun, Jan 29, 2006 at 10:20:47PM -0500, Neil Conway wrote: On Sun, 2006-01-29 at 17:03 -0800, David Fetter wrote: Another followup, this time with the comment done right. + /* Disallow the forbidden_delimiter strings */ + if (strcspn(cstate-delim, BADCHARS) != 1

Re: [PATCHES] [BUGS] BUG #2221: Bad delimiters allowed in COPY ...

2006-01-30 Thread David Fetter
On Mon, Jan 30, 2006 at 08:21:34AM -0500, Andrew Dunstan wrote: David Fetter wrote: +/* Disallow BADCHARS characters */ +if (strcspn(cstate-delim, BADCHARS) != 1) +ereport(ERROR, +(errcode(ERRCODE_FEATURE_NOT_SUPPORTED

Re: [PATCHES] [BUGS] BUG #2221: Bad delimiters allowed in COPY ...

2006-01-31 Thread David Fetter
, (errcode(ERRCODE_FEATURE_NOT_SUPPORTED), errmsg(COPY delimiter must not appear in the NULL specification))); I suppose that a different error code might be The Right Thing™ here. Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 415 235 3778

Re: [PATCHES] [BUGS] BUG #2221: Bad delimiters allowed in COPY ...

2006-01-31 Thread David Fetter
On Tue, Jan 31, 2006 at 09:50:26PM -0600, Andrew Dunstan wrote: David Fetter said: On Tue, Jan 31, 2006 at 08:03:41PM -0500, Bruce Momjian wrote: Uh, couldn't the delimiter be a backslash in CVS mode? I don't think so. Folks? Using backslash as a delimiter in CSV would be odd, to say

Re: [PATCHES] [BUGS] BUG #2221: Bad delimiters allowed in COPY ...

2006-01-31 Thread David Fetter
, which can cause *all* kinds of fun if not disallowed. Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 415 235 3778 Remember to vote! ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [PATCHES] Uninstall scripts for contrib

2006-02-12 Thread David Fetter
On Sat, Feb 11, 2006 at 11:37:49PM -0500, Bruce Momjian wrote: David Fetter wrote: On Sun, Jan 15, 2006 at 09:55:39PM -0800, David Fetter wrote: On Mon, Jan 16, 2006 at 12:13:11AM -0500, Neil Conway wrote: On Sun, 2006-01-15 at 20:08 -0800, David Fetter wrote: ifdef

Re: [PATCHES] Uninstall scripts for contrib

2006-02-21 Thread David Fetter
On Sat, Feb 18, 2006 at 07:08:15PM +0100, Peter Eisentraut wrote: David Fetter wrote: This one should do it. This patch fails to apply all over the place. It applied just fine against the CVSup version. This one should apply against CVS TIP. Cheers, D -- David Fetter [EMAIL PROTECTED

Re: [PATCHES] drop if exists remainder

2006-03-04 Thread David Fetter
, though. +1 :) Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 415 235 3778 Remember to vote! ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan

Re: [PATCHES] variance aggregates per SQL:2003

2006-03-07 Thread David Fetter
to extend stddev, etc. to intervals) -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 415 235 3778 Remember to vote! ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [PATCHES] variance aggregates per SQL:2003

2006-03-07 Thread David Fetter
On Tue, Mar 07, 2006 at 07:56:06PM -0500, Neil Conway wrote: On Tue, 2006-03-07 at 16:36 -0800, David Fetter wrote: The rationale is kinda mathematical. A measure of deviation from central tendency (i.e. variance or stddev) is something where you probably don't want to normalize

[PATCHES] Add switches for DELIMITER and NULL in pg_dump COPY

2006-03-08 Thread David Fetter
if there's a use case. Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 415 235 3778 Remember to vote! Index: doc/src/sgml/ref/pg_dump.sgml === RCS file: /projects/cvsroot/pgsql/doc/src/sgml/ref/pg_dump.sgml,v

Re: [PATCHES] [HACKERS] Add switches for DELIMITER and NULL in pg_dump COPY

2006-03-08 Thread David Fetter
On Wed, Mar 08, 2006 at 11:03:00AM -0500, Tom Lane wrote: David Fetter [EMAIL PROTECTED] writes: From the earlier discussion, it appears that there is a variety of opinions on what the COPY delimiter should be in pg_dump. This patch allows people to set it and the NULL string. Did

Re: [PATCHES] Add switches for DELIMITER and NULL in pg_dump COPY

2006-03-08 Thread David Fetter
On Wed, Mar 08, 2006 at 11:10:04AM -0500, Neil Conway wrote: On Wed, 2006-03-08 at 07:47 -0800, David Fetter wrote: From the earlier discussion, it appears that there is a variety of opinions on what the COPY delimiter should be in pg_dump. This patch allows people to set it and the NULL

Re: [PATCHES] [HACKERS] Add switches for DELIMITER and NULL in pg_dump COPY

2006-03-08 Thread David Fetter
On Wed, Mar 08, 2006 at 11:26:00AM -0500, Tom Lane wrote: David Fetter [EMAIL PROTECTED] writes: On Wed, Mar 08, 2006 at 11:03:00AM -0500, Tom Lane wrote: Did anyone provide a convincing use case for this? I've had one so far, and it was enough to cause me to make a special patched

Re: [PATCHES] allow select from void function in void sql function

2006-03-16 Thread David Fetter
) the equivalent of CALL, which we don't have yet. This would let you have what amounts to a stored procedure, i.e. something that takes an action but doesn't return rows. :) Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 415 235 3778AIM: dfetter666

Re: [HACKERS] [PATCHES] drop if exists remainder

2006-06-08 Thread David Fetter
people didn't speak up when this was first raised. :-) I did :) Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 415 235 3778AIM: dfetter666 Skype: davidfetter Remember to vote! ---(end of broadcast

[PATCHES] Have psql display names and OUT/INOUT in \df output

2006-07-15 Thread David Fetter
Folks, This patch makes psql's \df display functions with the names of parameters and OUT/INOUT if appropriate. Should there be a regression test for this? A doc patch? Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 415 235 3778AIM: dfetter666

  1   2   3   >