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
ype abstime: "1070430858"
>
> I agree its more stable :-). That's on HEAD.
>
> Gavin
I like "more stable." "Clearer" 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
> which has the advantage that it works without weird concatenation
> pushups when the numeric value 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
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: /pro
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 p
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 a patch exemplifying typical use of the ARE
Class-Shorthand Escapes®. I believe it will help intrepid regex
users. :)
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 510 893 6100cell: +1 415 235 3778
Index: func.sgml
stgreSQL's quoting system would qualify for an early place on the
'gotchas' page (cf. http://sql-info.de/mysql/gotchas.html) if
PostgreSQL had one.
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 510 893 6100cell: +1 415 235 3778
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 DECLARE block.
>
> Seems to me this is a bug that should be fixed, not docume
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
--
Da
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
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
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
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
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
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.
A
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
On Wed, Apr 28, 2004 at 08:28:58AM +0200, Peter Eisentraut wrote:
> David Fetter wrote:
> > Kind people,
> >
> > Please find attached a diff to the SGML docs that attempts to go
> > over the new dollar quoting feature.
>
> I think we should just use $$ in ea
On Wed, Apr 28, 2004 at 12:30:06PM -0400, Bruce Momjian wrote:
> Peter Eisentraut wrote:
> > David Fetter wrote:
> > > Kind people,
> > >
> > > Please find attached a diff to the SGML docs that attempts to go over
> > > the new dollar quoting feature.
&
n
> bodies so often that we should suggest folks just use $$ all the
> time.
IME, the answer 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
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
Folks,
This patch clarifies the 'predicate locking' section in the docs.
Thanks to Harrison Fisk of MySQL AB for helping.
Cheers,
D
--
David Fetter <[EMAIL PROTECTED]> http://fetter.org/
phone: +1 415 235 3778AIM: dfetter666
Skype: davidfet
added a little bit of
documentation.
Cheers,
D
--
David Fetter <[EMAIL PROTECTED]> http://fetter.org/
phone: +1 415 235 3778AIM: dfetter666
Skype: davidfetter
Remember to vote!
---(end of broadcast)--
through Usenet, please send an appropriate
>subscribe-nomail command to [EMAIL PROTECTED] so that your
>message can get through to the mailing list cleanly
--
David Fetter <[EMAIL PROTECTED]> http://fetter.org/
phone: +1 415 235 3778AIM: dfetter666
Folks,
Dennis Björklund and I discovered a little problem with how CVS TIP
reports overflows on cast. Please find enclosed a patch which fixes
it.
Cheers,
D
--
David Fetter <[EMAIL PROTECTED]> http://fetter.org/
phone: +1 415 235 3778AIM: dfetter666
On Thu, Sep 28, 2006 at 05:11:43PM -0400, Tom Lane wrote:
> David Fetter <[EMAIL PROTECTED]> writes:
> > ! DETAIL: A field with precision 4, scale 4 must have an absolute value
> > less than 1.
> > [ becomes ]
> > ! DETAIL: A field with precision 4, scale 4 must
On Thu, Sep 28, 2006 at 11:16:56PM +0200, Martijn van Oosterhout wrote:
> On Thu, Sep 28, 2006 at 05:11:43PM -0400, Tom Lane wrote:
> > David Fetter <[EMAIL PROTECTED]> writes:
> > > ! DETAIL: A field with precision 4, scale 4 must have an absolute value
> >
On Thu, Sep 28, 2006 at 11:16:56PM +0200, Martijn van Oosterhout wrote:
> On Thu, Sep 28, 2006 at 05:11:43PM -0400, Tom Lane wrote:
> > David Fetter <[EMAIL PROTECTED]> writes:
> > > ! DETAIL: A field with precision 4, scale 4 must have an absolute value
> >
o it like this:
>
> $ pg_dump -s -t '"DbTranLogRecord"' dtr
>
> A bit ugly but the conflict between shell and SQL quoting rules
> sometimes forces us into compromises :-(
>
> Perhaps it's worth having an example for this in the pg_dump man page?
Please find
ike of enums, I have a few issues with the patch
> as it is:
>
> 1. What's the point of having comparison operators for enums? For most
> use cases, there's no natural ordering of enum values.
A natural ordering is precisely the use case for enums. Otherwise,
you just us
3,7 +1243,7 @@
> to catch the error, for example:
>
>
> -BEGIN;
> +BEGIN
> SELECT * INTO STRICT myrec FROM emp WHERE empname = myname;
> EXCEPTION
> WHEN NO_DATA_FOUND THEN
>
> ---(end of broadcast)---
On Tue, Dec 26, 2006 at 01:10:03PM +0100, Joachim Wieland wrote:
> On December 26, 5:19 am David Fetter <[EMAIL PROTECTED]> wrote:
> > It doesn't need the semicolon. PL/PgSQL's BEGIN is different from
> > SQL's. :)
>
> Exactly. Note that my patch _
least in spirit.
> > > How about
> > >
> > > ... terminated by signal 10: Bus error
> >
> > I like that.
>
> OK, but you guys added back that colon you didn't like. :-)
Placement is crucial. Compare
terminated by signal 10: Bus error <-- proposed ver
egate
>SELECT join(',', col) FROM tbl
> currently can be written as
>SELECT array_to_string(ARRAY(SELECT col FROM tbl), ',')
The array_accum() aggregate in the docs works OK for this purpose.
Cheers,
D
--
David Fetter <[EMAIL PROTECTED]>
different? */
-1, /* no typmod */
0 /* dims not specified */
);
> that would foreclose responding to Peter's concern that SETOF is the
> wrong thing. If you look at the Perl and Tcl APIs for regexes, they
> return just the strings, not the numeri
ality to a function in form of a
> parameter.
That's what things like Perl's split do :)
Cheers,
D
--
David Fetter <[EMAIL PROTECTED]> http://fetter.org/
phone: +1 415 235 3778AIM: dfetter666
Skype: davidfetter
Remember to vote!
On Thu, Feb 15, 2007 at 07:35:46PM -0500, Tom Lane wrote:
> David Fetter <[EMAIL PROTECTED]> writes:
> > I've obviously misunderstood the scope of the TODO because it appears
> > that an INSERT into pg_type at creation time for compound types that
> > looks some
() function, it seems to me that it returns
> too much information at once. What is the use case for getting all
> of prematch, fullmatch, matches, and postmatch in one call?
If not in one call, how would you get it? Perl, for example, makes
these available to any regex match in the form o
On Fri, Feb 16, 2007 at 05:54:47PM +0100, Peter Eisentraut wrote:
> Am Freitag, 16. Februar 2007 17:11 schrieb David Fetter:
> > > As for the regexp_matches() function, it seems to me that it
> > > returns too much information at once. What is the use case for
> >
On Fri, Feb 16, 2007 at 01:03:32PM -0500, Andrew Dunstan wrote:
> David Fetter wrote:
> >>
> >>The question is, what is the use case? If there is one in Perl, can
> >>this proposed function API support it?
> >>
> >
> >Perl makes t
ce. What is the use case for
> > > getting all of prematch, fullmatch, matches, and postmatch in one
> > > call?
> >
> > It was requested by David Fetter:
> > http://archives.postgresql.org/pgsql-hackers/2007-02/msg00056.php
> >
> > It was not horribly diffi
ld you please re-send?
Cheers,
David.
--
David Fetter <[EMAIL PROTECTED]> http://fetter.org/
phone: +1 415 235 3778AIM: dfetter666
Skype: davidfetter
Remember to vote!
Consider donating to PostgreSQL: http://www.postgresql.org/about/donate
-
actually stepping up and doing it, not in the feature itself.
Cheers,
D
--
David Fetter <[EMAIL PROTECTED]> http://fetter.org/
phone: +1 415 235 3778AIM: dfetter666
Skype: davidfetter
Remember to vote!
Consider donating to PostgreSQL: http://www.post
On Fri, Mar 30, 2007 at 05:08:42PM -0400, Tom Lane wrote:
> David Fetter <[EMAIL PROTECTED]> writes:
> > After several rounds of patches, it appears that it might be easier to
> > create a new typtype entry, which I'll tentatively call 'a' because it
> >
ing, and partly because the closest
thing I've heard to an objection is pretty nebulous. :)
It's a lot simpler to have them always, and it fits in with the larger
picture of making arrays fully composable with other operations like
DOMAIN, ENUM and TYPE.
Cheers,
D
--
David Fetter <
On Tue, Apr 03, 2007 at 02:30:07AM -0400, Tom Lane wrote:
> David Fetter <[EMAIL PROTECTED]> writes:
> > On Mon, Apr 02, 2007 at 10:01:44PM -0400, Alvaro Herrera wrote:
> >> So, hum, what happened to the idea of creating the array types
> >> only on demand?
>
l GRANT/REVOKE, which
we don't have yet.
Cheers,
D
--
David Fetter <[EMAIL PROTECTED]> http://fetter.org/
phone: +1 415 235 3778AIM: dfetter666
Skype: davidfetter
Remember to vote!
Consider donating to PostgreSQL: http://www.postgresql.org/a
s? It's not
> going to be anything but a toy unless you can get the per-entry
> overhead down to something sane. Perhaps the MinimalTuple
> representation would work.
Sounds neat, too :)
Cheers,
D
--
David Fetter <[EMAIL PROTECTED]> http://fetter.org/
phone: +1 4
[12,13],null,null,null));
> ERROR: ROW() column has type integer[] instead of type anyarray
>
> but I don't feel comfortable about this at all. Maybe
> CheckAttributeType should be made to recurse into composite columns.
That'd be great :)
Cheers,
D
--
David Fe
the full recursive-WITH feature before taking the
> compatibility hit.
Is there some way to poll people for uses of WITH and SET in places
they shouldn't be?
Cheers,
D
--
David Fetter <[EMAIL PROTECTED]> http://fetter.org/
phone: +1 415 235 3778AIM: dfetter666
On Mon, Apr 09, 2007 at 09:08:31PM -0400, Tom Lane wrote:
> David Fetter <[EMAIL PROTECTED]> writes:
> > On Mon, Apr 09, 2007 at 06:43:08PM -0400, Tom Lane wrote:
> >> So this does not really add any new functionality, it's just variant
> >> syntax for someth
nclined to say we should prevent direct operations on array
> types, and they should live or die by their parent types.
>
> Thoughts?
+1 on binding the array types tightly to the parent types.
Cheers,
D
--
David Fetter <[EMAIL PROTECTED]> http://fetter.org/
phone: +1 415
or
> \cnowait. I'm not sure if going for cryptic short commands is better
> or worse here.
+1 for \c1, \c2, etc.
What's the reasoning behind \c&? Does it "send things into the
background" the way & does in the shell?
Cheers,
David.
--
David Fetter <[EMAIL PROT
nsider using Git, which includes a CVS interface,
starting after 8.3 gets out the door?
Cheers,
David.
--
David Fetter <[EMAIL PROTECTED]> http://fetter.org/
phone: +1 415 235 3778AIM: dfetter666
Skype: davidfetter
Remember to vote!
Consider donati
Folks,
Per Neil Conway, here's some doc patches re: the autovacuum daemon's
behavior. Should this be back-patched to 8.2x?
Cheers,
D
--
David Fetter <[EMAIL PROTECTED]> http://fetter.org/
phone: +1 415 235 3778AIM: dfetter666
Skype: david
On Sun, May 13, 2007 at 07:04:44PM -0400, Andrew Dunstan wrote:
>
>
> Tom Lane wrote:
> >David Fetter <[EMAIL PROTECTED]> writes:
> >
> >>I haven't included the customary diffs. This points me to some of
> >>the many deficiencies of CVS, nam
Folks,
Thanks to Andrew Dunstan for pointing me toward cvsutils. As not
everybody knows about them, here's a small patch which lets people
know at least in theory where they are.
Cheers,
D
--
David Fetter <[EMAIL PROTECTED]> http://fetter.org/
phone: +1 415 235 3778AIM:
On Sun, May 13, 2007 at 09:51:53PM -0400, Tom Lane wrote:
> David Fetter <[EMAIL PROTECTED]> writes:
> > On Sun, May 13, 2007 at 07:04:44PM -0400, Andrew Dunstan wrote:
> >> Tom Lane wrote:
> >>> Strange, it works fine for everyone else.
> >>
> >
On Sun, May 13, 2007 at 10:06:40PM -0400, Tom Lane wrote:
> David Fetter <[EMAIL PROTECTED]> writes:
> > Per Neil Conway, here's some doc patches re: the autovacuum
> > daemon's behavior. Should this be back-patched to 8.2x?
>
> This fact is already docum
On Mon, May 14, 2007 at 03:31:40PM +1200, Mark Kirkwood wrote:
> David Fetter wrote:
> >cvs diff works just great until you want to add or remove a file
> >without write permissions to the CVS repository, i.e. when you've
> >checked out as anonymous.
> >
>
>
he lines starting with '?' that diff
produces.
Lacking sophistication, I've been known to do:
cvs diff [list of files here] |grep -v '^?' > the_file.diff
Cheers,
D
--
David Fetter <[EMAIL PROTECTED]> http://fetter.org/
phone: +1 415 235 3778AIM: dfetter
On Wed, May 16, 2007 at 03:53:22PM +0100, Gregory Stark wrote:
> "David Fetter" <[EMAIL PROTECTED]> writes:
>
> > On Wed, May 16, 2007 at 09:12:23AM +0100, Heikki Linnakangas wrote:
> >> Jim C. Nasby wrote:
> >> >BTW, is there some trick to gett
ire away.
>
> (I'm still not sure you found all the relevant places in the
> documentation, however.)
Here's a new patch + file. This one allows ALTER [SEQUENCE | VIEW] to
work only on the respective database objects, but permits the old
ALTER TABLE syntax.
Cheers,
David.
On Sun, Jul 01, 2007 at 09:03:45PM -0700, Neil Conway wrote:
> On Sun, 2007-01-07 at 12:55 -0700, David Fetter wrote:
> > Here's a new patch + file. This one allows ALTER [SEQUENCE | VIEW] to
> > work only on the respective database objects, but permits the old
> > AL
a sets, you should be aware 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!
In
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 pat
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
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.
> &
it's *very* late 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
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
005-20-09 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 *
On Tue, Sep 20, 2005 at 05:55:52PM -0400, Tom Lane wrote:
> David Fetter <[EMAIL PROTECTED]> writes:
> > I am hoping to make a case for inclusion in 8.1.
>
> We are months past feature freeze. Don't waste your breath.
OK, I won't.
Cheers,
D
--
David Fetter [EMA
lease.
>
> I documented in TODO what doesn't log properly in 8.1. I don't see
> 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 foll
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:
>
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
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 [
le have to patch
> their copies.
This would be good :)
> > postgres=# set 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]
e:
> > > Patch applied. Thanks. Sorry for the delay in applying.
> > >
> > > -------
> > >
> > >
> > > David Fetter wrote:
> > >
> > >>On Tue, Mar 08, 2005 at 12:27:21PM +0800, Christopher King
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 [EMAIL PROTECTED] http://fetter.org/
phone: +1 510 893 6100 mobile: +1 415 235 3778
Remember to vote!
---(end of broad
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 f
; +man page for more details.
> +
> +
> +
>
> The syntax of the CREATE FUNCTION command requires
> the function body to be written as a string constant. It is usually
>
>
> ---(end of broadcast)--
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
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
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 Fette
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 chang
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:
mmitted your patches to current and 8.1 stable.
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
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
T(x, y) := r;
Better still, the pg way:
[ROW](x, y) := 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 d
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
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$ chan
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
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 ins
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 $PostgreSQ
1 - 100 of 234 matches
Mail list logo
