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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
-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
.
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
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
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
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
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
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
---(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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
.
---
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
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
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
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
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
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
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
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
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
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
.
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
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
) := 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
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
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
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
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
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
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
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
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
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
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
,
(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
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
, 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
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
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
, 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
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
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
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
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
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
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
) 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
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
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 - 100 of 216 matches
Mail list logo
