Was reading the docs and stumbled across what I believe is a mistake.
There is a mistake in Table 9-25
the result of to_char(148.5,'999D999') should be ' 148.500',
the docs list it as ' 148,500'
http://www.postgresql.org/docs/8.4/interactive/functions-formatting.html
and
http://developer.postgre
query.sgml ?
TIA :)
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 510 893 6100cell: +1 415 235 3778
Power over a man's subsistence is power over his will.
Alexander Hamilton
---(e
On Wed, Jan 07, 2004 at 09:13:47PM -0500, Bruce Momjian wrote:
> David Fetter wrote:
> > Kind people,
> >
> > I was looking over the Tutorial section, and noticed that Foreign
> > Keys is in the "Advanced" section. I believe this is a mistake,
> > and w
gives the (IME
always wrong) impression that they're optional.
Chris Browne, could you give me a pointer to your patch so we don't
step on each other's feet?
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 510 893 6100cell: +1 415 235 3778
--
On Thu, Jan 08, 2004 at 06:07:13PM +0100, Peter Eisentraut wrote:
> David Fetter wrote:
> > Expanding on that, putting FK's in "Advanced Features" gives the
> > (IME always wrong) impression that they're optional.
>
> They *are* optional.
I disagree.
Christopher Browne <[EMAIL PROTECTED]> wrote:
> Oops! [EMAIL PROTECTED] (David Fetter) was seen spray-painting on a wall:
>> On Thu, Jan 08, 2004 at 06:07:13PM +0100, Peter Eisentraut wrote:
>>> David Fetter wrote:
>>> > Expanding on that, putting FK's in
What *is* broken is table inheritance, and the docs need to reflect
this.
If the parent table has a foreign key to another table foo, CASCADEing
DELETEs on foo leave ghost entries in the tables with inheritance.
Please find enclosed a repro, which demonstrates the problem on CVS
tip and 7.4.3.
Jus
On Fri, Jul 23, 2004 at 03:31:47PM -0400, Tom Lane wrote:
> David Fetter <[EMAIL PROTECTED]> writes:
> > What *is* broken is table inheritance, and the docs need to reflect
> > this.
>
> The combination of inheritance with certain other features is broken,
> yes, and
torial?
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 5: Have you checked our extensive FAQ?
http://www.postgresql.or
On Fri, Jul 23, 2004 at 04:30:40PM -0400, Tom Lane wrote:
> David Fetter <[EMAIL PROTECTED]> writes:
> > I don't consider the concept broken. The implementation is, in
> > fact, broken, and putting that broken piece in the tutorial is,
> > imnsho, a bad mistake.
&g
On Fri, Jul 23, 2004 at 04:58:55PM -0400, Tom Lane wrote:
> David Fetter <[EMAIL PROTECTED]> writes:
> > On Fri, Jul 23, 2004 at 04:30:40PM -0400, Tom Lane wrote:
> >> If we're going to remove from the tutorial every feature for
> >> which any aspect is deemed
Bruce Momjian wrote:
I have completed the 7.5 release notes. You can view them in HTML on
the developer web page. I have marked a few items with question marks
that need to be addressed. I am looking for improvements, even minor
ones. Either send in a patch or committers can modify the file
dir
Perl and PHP programmers (such as myself) are accustomed to using
defined()/isset() and so when wanting to test null value they might look
to the Functions chapter (9) instead of the SQL Syntax chapter (4). It
took me some time before I found out about ISNULL, IS NULL, NOTNULL, IS
NOT NULL. In
Tom Lane wrote:
Perhaps we can change section 9.1 from "Logical Operators" to "Logical
Functions and Operators"? NULLVALUE() and NONNULLVALUE() can be
documented there, along with IS, IS NULL, and IS NOT NULL (which also
don't seem to have been covered yet in Chapter 9).
I don't think we should
function index would be quite unreliable ("It's not in the
> function index, so it's not supported."). Feel free to add general
> index entries for all functions, though.
Where?
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 510 893 6100 mob
On Mon, Aug 09, 2004 at 05:34:56PM -0400, Tom Lane wrote:
> David Fetter <[EMAIL PROTECTED]> writes:
> > On Mon, Aug 09, 2004 at 11:20:33PM +0200, Peter Eisentraut wrote:
> >> A function index would be quite unreliable ("It's not in the
> >> function ind
Folks,
Here's a little addition to the array functions & operators section of
the manual. It adds a function array() to the list.
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/
On Sun, Oct 31, 2004 at 10:40:47PM -0500, Tom Lane wrote:
> David Fetter <[EMAIL PROTECTED]> writes:
> > Here's a little addition to the array functions & operators section of
> > the manual. It adds a function array() to the list.
>
> The ARRAY() constr
On Mon, Nov 01, 2004 at 08:47:05PM +0100, Peter Eisentraut wrote:
> David Fetter wrote:
> > Please find attached a different diff :)
>
> If you want to write a note, use the element.
Thanks for the tip :)
Fixed, attaching a diff against CVS HEAD.
Cheers,
D
--
David Fetter [
On Mon, Nov 01, 2004 at 01:59:13PM -0600, Jim C. Nasby wrote:
> On Sun, Oct 31, 2004 at 04:36:14PM -0800, David Fetter wrote:
> > Folks,
> >
> > Here's a little addition to the array functions & operators
> > section of the manual. It adds a function arr
ks in some
obvious place.
I am volunteering to do said list & linking :)
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 5:
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
zone via a USING clause:
ALTER TABLE foo
ALTER COLUMN foo_timestamp TYPE timestamp with time zone
USING
timestamp with time zone 'epoch' + foo_timestamp * interval '1 second';
"
That is at least something, although I agree that more examples of the
exact kind of
Folks,
Please find a patch per IRC chat yesterday that clarifies how much
space a NUMERIC takes.
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/datatype.sgml
Folks,
Please find enclosed a patch which adds cross-references to the CREATE
FUNCTION syntax in the PL/* docs.
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
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 st
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
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 (should work for 7.3 and up) that
illustrates a workaround for using COPY on parts of tables using
temporary tables. It's helped me, and it seems popular via a very
brief and un-scientific poll.
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fette
, Oct 11, 2005 at 04:02:17PM -0700, David Fetter wrote:
> > Folks,
> >
> > Please find enclosed a patch (should work for 7.3 and up) that
> > illustrates a workaround for using COPY on parts of tables using
> > temporary tables. It's helped me, and it seems
On Tue, Oct 11, 2005 at 06:33:42PM -0500, Jim C. Nasby wrote:
> On Tue, Oct 11, 2005 at 04:22:40PM -0700, David Fetter wrote:
> > On Tue, Oct 11, 2005 at 06:12:53PM -0500, Jim C. Nasby wrote:
> > > Why the vacuum? Seems a bit sever to do a vacuum of an entire
> > >
> +
> > +
>
> The capitalization of "a_list_countries" is inconsistent -- both
> references should all be in lowercase, IMO.
Good catch :)
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 510 893 6100 mobile: +1 415 235 3778
Remember to vot
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
ducing these PDFs something that could be
distributed? What tools actually work for this?
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)-
e these tuits, and they're round, and they're a precious
resource usually spent on writing and testing C code rather than on
improving (and helping transition adoption of) the SGML toolchain.
Maybe we can get some kind soul(s) to donate some tuits and/or pay
somebody a wage for awhile to
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
where and link to them.
http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/ has at least
the raw files. I'd be delighted to put up something more, tho :)
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 415 235 3778
Remember to vote!
--
On Fri, Mar 17, 2006 at 12:22:44PM -0600, Jim C. Nasby wrote:
> On Wed, Mar 08, 2006 at 02:05:44PM -0800, David Fetter wrote:
> > On Wed, Mar 08, 2006 at 01:50:47PM -0600, Jim C. Nasby wrote:
> > > It would be nice if there was an easy place to see the documentation
> > &
roll forward.
...and it's unlikely that they will, now or later, without somebody
whose whole job is to monitor those comments and make patches.
I'd like to make a Modest Proposalâ¢: Let's take down the interactive
documents and, in their place, put up a request that doc patches b
into the docs proper.
>
> In the past these ideas were rejected as either off-topic or that it
> would turn this list into a high traffic list... if peoples opinions
> have changed, it could be arranged.
I'm voicing a rejection for 'em again on the same grounds. Until we
ndard have anything to say about assigning identifiers
both to the entire VALUES() statement and to its columns when the
VALUES() statement is by itself?
Cheers,
D
--
David Fetter <[EMAIL PROTECTED]> http://fetter.org/
phone: +1 415 235 3778AIM: dfett
ta) (my favorite)
Part 10: SQL/OLB (Object Language Binding)
Part 11: SQL/Schemata
Part 13: SQL/JRT (Java Routines and Types)
Cheers,
D
--
David Fetter <[EMAIL PROTECTED]> http://fetter.org/
phone: +1 415 235 3778AIM: dfetter666
On Fri, Aug 25, 2006 at 08:37:19PM -0400, Bruce Momjian wrote:
> David Fetter wrote:
> > On Fri, Aug 25, 2006 at 07:46:57PM -0400, Bruce Momjian wrote:
> > > Here is an new XML section for our SGML documentation. It
> > > explains the various XML capabilities, if we sup
On Sat, Aug 26, 2006 at 12:48:32PM -0400, Bruce Momjian wrote:
> David Fetter wrote:
> > On Fri, Aug 25, 2006 at 08:37:19PM -0400, Bruce Momjian wrote:
> > > > Speaking of other parts of the SQL:2003 standard, how about one
> > > > section each that mentions them?
On Sat, Aug 26, 2006 at 01:16:06PM -0400, Bruce Momjian wrote:
> David Fetter wrote:
> > On Sat, Aug 26, 2006 at 12:48:32PM -0400, Bruce Momjian wrote:
> > > David Fetter wrote:
> > > > On Fri, Aug 25, 2006 at 08:37:19PM -0400, Bruce Momjian wrote:
> >
> &
On Sat, Aug 26, 2006 at 08:38:43PM +0200, Peter Eisentraut wrote:
> David Fetter wrote:
> > We claim SQL standard compliance,
>
> No, we don't. And SQL conformance doesn't require you to implement
> all parts anyway.
Right. It'd be nice to be able to tell wha
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
e escapades with openjade, I heartily
agree with this decision. Meanwhile, can someone provide me with either
postgres.rtf or postgres.fot from the 8.1 series?
David Blewett
The software versions I'm using are as follows:
openjade:I: "openjade" version "1.3.2"
openj
to get
something working well, I'll let you know.
David
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.3 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iD8DBQFFJsTtZmlc6wNjtLYRAo3HAJ0QOokK1Llqj+vmmIQN+/5oMbZ4YwCdFNLt
+w16ga7eIDg9Gljng3KuiuM=
=YiqV
-END PGP SIGNAT
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi All:
Just noticed that the release notes section for 8.1.5 has this heading
in it: "E.1.1. Migration to version 8.1.4".
David
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.3 (MingW32)
Comment: Using GnuPG with Mozi
s replication for a
> 'Shared Disk Fail Over'. It's not replication, because there's no replica.
As you point out, there is no replica of the data, but there is some
protection against machine failure, which puts it firmly in the
"Fail-over" part above.
Cheers,
D
--
ore I do this I am wondering if this is the right
> forum for
> having the changes vetted before submitting the patch.
>
> Please advise.
Send it to both lists, and thanks for doing this :)
Cheers,
D
--
David Fetter <[EMAIL PROTECTED]> http://fetter.org/
phone: +1 415 235 3778
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
ake on creating a Lulu account for the
fundraising group. We would then move the volumes I did for 8.1 to their
account, and raise the price so that any profit went to them. The
ability to order the 8.2 manual from bookstores could increase the
visibility of the project as a whole.
David Blewet
was a long time ago. I will try
> again this week-end.
I gave it a try post-patches, and it's still a disaster 3284 pages of
un-rendered XML.
> > There is a long standing support within the community to move to XML
> > including:
> >
> > Josh Berkus
> > Josh
've added one for XSL-FO
> output, which you can invoke by "make postgres-{A4|US}.fo". (You will
> probably want yet a different paper format for your book.)
Excuse my ignorance, but I thought XSLT stylesheets can only be used
on XML files?
David Blewett
-BEGIN PGP SIGNAT
h is not possible with DSSSL. In order to do
this, I would have to run the conversion *every time* I wanted to
work on a new release of the manual to bookstores.
David Blewett
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.5 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.
re-do their work for each
release. Do we really want to continue considering this addition to
the project as well as their work to be "second-class citizens" wrt
the rest of the distribution?
David Blewett
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.5 (MingW32)
Comment: Using GnuPG wit
can change line boundaries, and
> then diff will never be able to extract any signal from that noise.
Could post-processing with tidy clean this up? I'm pretty sure that
tidy's output is deterministic, at least if the editor hasn't mangled
tags...
Cheers,
D
--
D
bmitted the patch to gentoo's bugzilla:
http://bugs.gentoo.org/show_bug.cgi?id=158605
David Blewett
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.5 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iD8DBQFFieRjZmlc6wNjtLYRCH2GAJ4rfMXrcPAceJoL5rTPjmpY9EAndACcCfes
oxBVK
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA256
David Blewett wrote:
> Tom Lane wrote:
>> However, I have no idea what it'll take to get this patch propagated
>> into the copies people actually use, so your fix sounds good for the
>> short term.
>
>>
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
determined by the X num at "RI_ConstraintTrigger_X" column in
pg_trigger table.
Regards,
David Pufer
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
Michael Glaesemann wrote:
>
> On Apr 21, 2007, at 4:39 , David Pufer wrote:
>
>> In my opinion it would be nice to mention in SQL reference commands that
>> constraint triggers created by CREATE CONSTRAINT TRIGGER are fired in
>> creation order unlike regular trigger
Tom Lane wrote:
> Michael Glaesemann <[EMAIL PROTECTED]> writes:
>
>> On Apr 21, 2007, at 4:39 , David Pufer wrote:
>>
>>> In my opinion it would be nice to mention in SQL reference commands that
>>> constraint triggers created by CREATE CONSTRAI
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
;list, or join us
on IRC.
Submissions containing URLs or other keywords commonly found in spam
comments may be silently discarded. Please contact the mailto:[EMAIL PROTECTED]">webmaster if you think this
is happening to you in error.
Cheers,
David.
--
David Fetter <[EMAIL PROTECTED]&
Earlier today I was tempted to start storing usesysid's as foreign keys
in one of my tables by doing:
SELECT usesysid FROM pg_user WHERE pg_user.usename= user;
My proposed FAQ entry is based on this mailing list post which convinced
me not to:
http://archives.postgresql.org/pgsql-novice/2005-0
-info.html
It just seemed natural to think there must be some kind of integer key
associated with the user. Maybe this doesn't qualify as frequent.
Magnus Hagander wrote:
On Thu, Jun 28, 2007 at 09:06:20PM -0400, Bruce Momjian wrote:
David Gardner wrote:
Earlier today I was tempted to
Where would you
> have expected to find it?
I'd expect to find it in an ALTER VIEW document.
Cheers,
D
--
David Fetter <[EMAIL PROTECTED]> http://fetter.org/
phone: +1 415 235 3778AIM: dfetter666
Skype: davidfetter
Remember
On Fri, Jun 29, 2007 at 11:32:19AM -0700, David Fetter wrote:
> On Thu, Jun 28, 2007 at 10:16:51AM -0400, Tom Lane wrote:
> > Susanne Ebrecht <[EMAIL PROTECTED]> writes:
> > > that works, but there is no hint at the documentation, that you
> > > can rename a vie
E TO ... ? I
suppose we could document that they're actually done by ALTER TABLE,
but that just seems like a huge POLA violation, along with assuming
way too much knowledge of how sequences and views are implemented.
Cheers,
D
--
David Fetter <[EMAIL PROTECTED]> http://fetter.org/
phone
Could this get added to: http://www.postgresql.org/docs/books/ ?
Guillaume Lelarge wrote:
> Andrej Ricnik-Bay a écrit :
>
>> On 8/5/07, RPK <[EMAIL PROTECTED]> wrote:
>>
>>> Is PGSQL doc available as a book?
>>>
>> There was a thread about this not long ago ... not sure
>> whether o
inology that does not require much context to understand.
>
> So I think what is being proposed is wrong and needs to be reverted.
That, or (my preference) make the change larger. I think it's
significant that the vast majority of compatible software has some
variant of Postgre
On Fri, Oct 05, 2007 at 12:17:40PM -0700, Joshua D. Drake wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> David Fetter wrote:
> > On Fri, Oct 05, 2007 at 11:43:45AM -0700, Joshua D. Drake wrote:
> >> -BEGIN PGP SIGNED MESSAGE-
> >> Has
On Fri, Oct 05, 2007 at 11:43:45AM -0700, Joshua D. Drake wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> David Fetter wrote:
> > On Fri, Oct 05, 2007 at 07:22:01PM +0200, Peter Eisentraut wrote:
> >> Some of you may have noticed that there was a move pro
Folks,
Best practices for partitioning so far have shown that TRIGGERs are
better than RULEs for most cases. Please find attached a patch which
reflects this.
Thanks to Robert Treat for help putting this together :)
Cheers,
David.
--
David Fetter <[EMAIL PROTECTED]> http://fetter.org/
On Wed, Nov 28, 2007 at 03:53:04PM -0500, Tom Lane wrote:
> David Fetter <[EMAIL PROTECTED]> writes:
> > Best practices for partitioning so far have shown that TRIGGERs
> > are better than RULEs for most cases. Please find attached a
> > patch which reflects this.
On Wed, Nov 28, 2007 at 12:39:04PM -0800, Joshua D. Drake wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> On Wed, 28 Nov 2007 12:26:15 -0800
> David Fetter <[EMAIL PROTECTED]> wrote:
>
> > Folks,
> >
> > Best practices for partitioning so f
On Wed, Nov 28, 2007 at 12:41:20PM -0800, David Fetter wrote:
> On Wed, Nov 28, 2007 at 12:39:04PM -0800, Joshua D. Drake wrote:
> > -BEGIN PGP SIGNED MESSAGE-
> > Hash: SHA1
> >
> > On Wed, 28 Nov 2007 12:26:15 -0800
> > David Fetter <[EMAIL
On Wed, Nov 28, 2007 at 05:17:38PM -0500, Tom Lane wrote:
> David Fetter <[EMAIL PROTECTED]> writes:
> > On Wed, Nov 28, 2007 at 03:53:04PM -0500, Tom Lane wrote:
> >> Entirely removing the example of how to do it with rules doesn't
> >> seem like a good
On Wed, Nov 28, 2007 at 10:06:01PM -0300, Alvaro Herrera wrote:
> David Fetter wrote:
>
> > Greg Sabino Mullane managed to contrive an example where RULEs
> > might conceivably be the least-bad way to do this, that being a
> > machine where no PLs may be installed.
>
&
f one use case where using RULEs rather than
TRIGGERs is a good idea?
Cheers,
David.
--
David Fetter <[EMAIL PROTECTED]> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: [EMAIL PROTECTED]
Remember to vote!
Consider donating to Postgres:
On Thu, Nov 29, 2007 at 12:55:53AM -0500, Tom Lane wrote:
> David Fetter <[EMAIL PROTECTED]> writes:
> > On Wed, Nov 28, 2007 at 09:58:26PM -0500, Jonah H. Harris wrote:
> >> On Nov 28, 2007 3:53 PM, Tom Lane <[EMAIL PROTECTED]> wrote:
> >>> Entirely remov
are talking about partitioning. It is supposed to be narrow-minded.
>
> Sure, but look at all the confusion we have had just on this list about
> it. We had better state why triggers should be used in place of rules
> _for_ _partitioning_ or that confusion will continue.
Please find enc
> the COPY operation will not be so straightforward.
Folks,
Does my latest patch attached address this well enough?
Cheers,
David.
--
David Fetter <[EMAIL PROTECTED]> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: [EMAIL PROT
t;
> balanced
> gradual
> extended (I see you mention time-extended but wouldn't time be implicit
> based on the actual docs and thus we only need extended?)
How about "smoothed?"
Cheers,
David.
--
David Fetter <[EMAIL PROTECTED]> http://fet
esses on a server. If you really need to embed an
SQL engine in a binary, consider the excellent
http://www.sqlite.org/";>SQLite for the purpose.
Comments? Criticisms? Rotten tomatoes?
Cheers,
David.
--
David Fetter <[EMAIL PROTECTED]> http://fetter.org/
Phone: +1 415 235 3778
1 - 100 of 225 matches
Mail list logo
