[DOCS] The Tutorial(TM)

2004-01-07 Thread David Fetter
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

Re: [DOCS] The Tutorial(TM)

2004-01-07 Thread David Fetter
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

Re: [DOCS] The Tutorial(TM)

2004-01-08 Thread David Fetter
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 --

Re: [DOCS] The Tutorial(TM)

2004-01-08 Thread David Fetter
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.

Re: [DOCS] The Tutorial(TM)

2004-01-08 Thread David Fetter
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

Re: [DOCS] [HACKERS] Tutorial

2004-07-23 Thread David Fetter
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

Re: [DOCS] [HACKERS] Tutorial

2004-07-23 Thread David Fetter
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

Re: [DOCS] [HACKERS] Tutorial

2004-07-23 Thread David Fetter
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

Re: [DOCS] [HACKERS] Tutorial

2004-07-23 Thread David Fetter
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

Re: [DOCS] [HACKERS] Tutorial

2004-07-23 Thread David Fetter
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

Re: [DOCS] Suggestion on reorganizing functions

2004-08-09 Thread David Fetter
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

Re: [DOCS] Suggestion on reorganizing functions

2004-08-09 Thread David Fetter
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

[DOCS] Array function

2004-10-31 Thread David Fetter
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/

Re: [DOCS] Array function

2004-10-31 Thread David Fetter
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

Re: [DOCS] Array function

2004-11-01 Thread David Fetter
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 [

Re: [DOCS] Array function

2004-11-01 Thread 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

Re: [DOCS] Documentation of server configuration

2004-11-15 Thread David Fetter
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:

[DOCS] 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

Re: [DOCS] Missing doc on expression format for ALTER TABLE

2005-03-28 Thread David Fetter
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

[DOCS] Storage requirements for NUMERIC

2005-04-30 Thread David Fetter
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

[DOCS] Add cross references for CREATE FUNCTION to PLs

2005-05-19 Thread David Fetter
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

[DOCS] 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: [DOCS] [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 st

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

2005-07-29 Thread David Fetter
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

Re: [DOCS] [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 pat

[DOCS] 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

[DOCS] 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

[DOCS] COPY example for partial tables

2005-10-11 Thread David Fetter
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

Re: [DOCS] COPY example for partial tables

2005-10-11 Thread David Fetter
, 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

Re: [DOCS] COPY example for partial tables

2005-10-11 Thread David Fetter
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 > > >

Re: [DOCS] COPY example for partial tables

2005-10-13 Thread David Fetter
> + > > + > > 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

Re: [DOCS] [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 Fette

Re: [DOCS] [pgsql-www] 8.1 PDF Documentation.

2005-11-10 Thread David Fetter
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)-

Re: [DOCS] [pgsql-www] 8.1 PDF Documentation.

2005-11-14 Thread David Fetter
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

[DOCS] 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

Re: [DOCS] Get docs for contrib on the web somewhere

2006-03-08 Thread David Fetter
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! --

Re: [DOCS] Get docs for contrib on the web somewhere

2006-03-17 Thread David Fetter
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 > > &

Re: [DOCS] [GENERAL] COPY command documentation

2006-03-23 Thread David Fetter
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

Re: [DOCS] [GENERAL] COPY command documentation

2006-03-23 Thread David Fetter
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

Re: [HACKERS] [PATCHES] [DOCS] Values list-of-targetlists patch for comments (was Re:

2006-08-09 Thread David Fetter
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

Re: [DOCS] [HACKERS] New XML section for documentation

2006-08-25 Thread David Fetter
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

Re: [DOCS] [HACKERS] New XML section for documentation

2006-08-26 Thread David Fetter
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

Re: [DOCS] [HACKERS] New XML section for documentation

2006-08-26 Thread David Fetter
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?

Re: [DOCS] [HACKERS] New XML section for documentation

2006-08-26 Thread David Fetter
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: > > > &

Re: [DOCS] [HACKERS] New XML section for documentation

2006-08-26 Thread David Fetter
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

[DOCS] Predicate Locking

2006-09-01 Thread David Fetter
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

Re: [DOCS] [HACKERS] Replication documentation addition

2006-10-25 Thread David Fetter
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 --

Re: [DOCS] Documentation update for PQexecParams

2006-11-09 Thread David Fetter
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

Re: [DOCS] [HACKERS] pg_dump -t broken for mixed case table names in beta3?

2006-11-28 Thread David Fetter
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

Re: [DOCS] Switching to XML

2006-12-09 Thread David Fetter
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

Re: [DOCS] Authoring Tools WAS: Switching to XML

2006-12-14 Thread David Fetter
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

[DOCS] Fix misleading references to columns in GRANT/REVOKE summaries

2007-04-06 Thread David Fetter
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

[DOCS] OS/X startup scripts

2007-05-13 Thread David Fetter
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

[DOCS] Autovacuum and XID wraparound

2007-05-13 Thread David Fetter
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

Re: [PATCHES] [DOCS] OS/X startup scripts

2007-05-13 Thread David Fetter
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

[DOCS] On patching without write access to CVS

2007-05-13 Thread David Fetter
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:

Re: [PATCHES] [DOCS] OS/X startup scripts

2007-05-13 Thread David Fetter
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. > >> > >

Re: [DOCS] Autovacuum and XID wraparound

2007-05-13 Thread David Fetter
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

Re: [PATCHES] [DOCS] OS/X startup scripts

2007-05-14 Thread David Fetter
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. > > > >

Re: [PATCHES] [DOCS] OS/X startup scripts

2007-05-16 Thread David Fetter
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

Re: [PATCHES] [DOCS] OS/X startup scripts

2007-05-16 Thread David Fetter
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

Re: [DOCS] [pgsql-www] Users comments don't migrate to docs for new version?

2007-06-07 Thread David Fetter
;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]&

Re: [DOCS] rename of a view

2007-06-29 Thread David Fetter
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

Re: [DOCS] rename of a view

2007-06-29 Thread David Fetter
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

Re: [DOCS] rename of a view

2007-06-29 Thread David Fetter
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

Re: [DOCS] PostgreSQL vs. Postgres labeling inconsistency

2007-10-05 Thread David Fetter
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

Re: [DOCS] PostgreSQL vs. Postgres labeling inconsistency

2007-10-05 Thread David Fetter
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

Re: [DOCS] PostgreSQL vs. Postgres labeling inconsistency

2007-10-05 Thread David Fetter
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

[DOCS] Partition: use triggers instead of rules

2007-11-28 Thread David Fetter
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/

Re: [DOCS] Partition: use triggers instead of rules

2007-11-28 Thread David Fetter
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.

Re: [DOCS] Partition: use triggers instead of rules

2007-11-28 Thread David Fetter
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

Re: [DOCS] Partition: use triggers instead of rules

2007-11-28 Thread David Fetter
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

Re: [DOCS] Partition: use triggers instead of rules

2007-11-28 Thread David Fetter
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

Re: [DOCS] Partition: use triggers instead of rules

2007-11-28 Thread David Fetter
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. > &

Re: [PATCHES] [DOCS] Partition: use triggers instead of rules

2007-11-28 Thread David Fetter
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:

Re: [PATCHES] [DOCS] Partition: use triggers instead of rules

2007-11-28 Thread David Fetter
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

Re: [PATCHES] [DOCS] Partition: use triggers instead of rules

2007-11-29 Thread David Fetter
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

Re: [PATCHES] [DOCS] Partition: use triggers instead of rules

2007-11-30 Thread David Fetter
> 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

Re: [HACKERS] [DOCS] "distributed checkpoint"

2007-12-06 Thread David Fetter
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

[DOCS] FAQ on Embedding Postgres

2008-03-05 Thread David Fetter
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

Re: [DOCS] Documenting a DB schema

2008-03-05 Thread David Fetter
column a...'); > > (see http://dev.mysql.com/doc/refman/5.0/en/create-table.html) > > However, Postgres doesn't support the "comment" keyword. Actually, it does :) > Is there an alternative? Cheers, David. -- David Fetter <[EMAIL PROTECTED]> http:/

Re: [DOCS] FAQ on Embedding Postgres

2008-03-05 Thread David Fetter
On Wed, Mar 05, 2008 at 12:35:53PM -0500, Tom Lane wrote: > Bruce Momjian <[EMAIL PROTECTED]> writes: > > Richard Huxton wrote: > >> Bruce Momjian wrote: > > David Fetter wrote: > >>> If you really need to embed an > >>> SQL engine in a bina

Re: [DOCS] FAQ on Embedding Postgres

2008-03-05 Thread David Fetter
On Wed, Mar 05, 2008 at 12:56:01PM -0500, Tom Lane wrote: > David Fetter <[EMAIL PROTECTED]> writes: > > On Wed, Mar 05, 2008 at 12:35:53PM -0500, Tom Lane wrote: > >> If we need a FAQ entry on this at all, I'd stop after David's > >> first two sentenc

Re: [DOCS] FAQ on Embedding Postgres

2008-03-05 Thread David Fetter
dded SQL DBMSs rather than leave people with the feeling of, "It's all up to you from here. Go away." Cheers, David. -- David Fetter <[EMAIL PROTECTED]> http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: [EMAIL PROTE

[DOCS] Windows ODBC FAQ

2008-05-25 Thread David Fetter
;Go to Programs -> Administrative Tools -> Data Sources and Add the PostgreSQL Unicode driver." Thanks to Dan Dascalescu (pidginusr) in IRC for pointing this out :) Cheers, David. -- David Fetter <[EMAIL PROTECTED]> http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Ya

Re: [DOCS] TODO build rule

2008-08-17 Thread David Fetter
one to a makefile, btw. > > Oh, I forgot that README talked about making TODO.html. I have > updated the README to suggest using pgsql/src/tools/TODO2html. I thought this was going onto the wiki so Bruce doesn't have to be the sole maintainer :) Cheers, David. -- David Fe

Re: [DOCS] [GENERAL] Postgresql 8.3X supports Arrays of Composite Types?

2009-04-19 Thread David Fetter
Y KEY(name, cod, num) ); Cheers, David. -- David Fetter http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate -- Sent via pgsql-docs

Re: [DOCS] [GENERAL] Postgresql 8.3X supports Arrays of Composite Types?

2009-04-20 Thread David Fetter
're proposing, how do you find all the people who have a common prefix? Answer: Normalize. If you need that answer quickly, you're looking at down time and DDL changes. The questions you ask about the data are impossible to know in advance, so normalized data helps you deal with tha

[DOCS] Re: [COMMITTERS] pgsql: Proofreading adjustments for first two parts of documentation

2009-04-27 Thread David Fetter
had them, at least in some of their engines, for many years. Cheers, David. -- David Fetter http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com Remember to vote! Consider donating to Postgres: http://www.postgresql.o

Re: [DOCS] Re: [COMMITTERS] pgsql: Proofreading adjustments for first two parts of documentation

2009-04-27 Thread David Fetter
On Mon, Apr 27, 2009 at 09:50:13PM +0300, Peter Eisentraut wrote: > On Monday 27 April 2009 20:10:27 David Fetter wrote: > > While we're at it, can we see about moving foreign keys out of the > > "advanced" section? They've been standard for many years. He

Re: [DOCS] Re: [COMMITTERS] pgsql: Proofreading adjustments for first two parts of documentation

2009-04-27 Thread David Fetter
On Mon, Apr 27, 2009 at 10:56:28PM +0300, Peter Eisentraut wrote: > On Monday 27 April 2009 21:54:12 David Fetter wrote: > > On Mon, Apr 27, 2009 at 09:50:13PM +0300, Peter Eisentraut wrote: > > > On Monday 27 April 2009 20:10:27 David Fetter wrote: > > > > While

Re: [DOCS] [GENERAL] how to select temp table

2009-05-06 Thread David Fetter
//www.postgresql.org/docs/current/static/ddl-schemas.html > > Apparently the only mention of pg_temp is in the CREATE FUNCTION page. That's probably not a good omission. Any ideas as to where further mentions should go? Cheers, David. -- David Fetter http://fetter.org/ Phone: +1 41

Re: [DOCS] Postgres Sql7.3 Update

2009-09-03 Thread David Fetter
them. It > will take a long time to read as you're talking about 6 years of > development. It's a really, really good idea to build major version upgrades into your development, deployment and maintenance processes. Cheers, David. -- David Fetter http://fetter.org/ Phone: +1 415 2

[DOCS] Missing information on Expressional Indexes

2010-03-16 Thread David Fetter
'm thinking that something along the lines of, "Expressions are limited to those which are equivalent to an [link]IMMUTABLE[/link] function." Anybody have a better suggestion for wording? Cheers, David. -- David Fetter http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter

Re: [DOCS] INTEGER range ("-2147483648" is not accepted.)

2010-06-22 Thread David Fetter
nt out of range > postgres=# SELECT -9223372036854775808::bigint; > ERROR: bigint out of range > > I think those min values are all out by 1. Nope. Same problem. SELECT (-32768)::smallint; -32768 SELECT (-9223372036854775808)::bigint; -9223372036854775808 I agree that the appropriat

Re: [HACKERS] [DOCS] Sync rep doc corrections

2011-03-07 Thread David Fetter
ews, it helps me *enormously* to have only one list I need to check, so at least for me, it's an enormous help to have all patches at least CC'd, or better still, only posted, to -hackers. Cheers, David. -- David Fetter http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: d

Re: [HACKERS] [DOCS] Sync rep doc corrections

2011-03-07 Thread David Fetter
On Mon, Mar 07, 2011 at 11:34:48PM +0530, Thom Brown wrote: > On 7 March 2011 23:21, David Fetter wrote: > > On Mon, Mar 07, 2011 at 10:53:17PM +0530, Thom Brown wrote: > >> On 7 March 2011 22:31, Robert Haas wrote: > >> > On Mon, Mar 7, 2011 at 6:16 AM, Thom Br

Re: [HACKERS] [DOCS] Sync rep doc corrections

2011-03-07 Thread David Fetter
eparation of docs from code is one that's actively unhelpful. We don't have a separate "docs" team, and we rightly put the responsibility of documenting changes on the person or people patching them in. Cheers, David. -- David Fetter http://fetter.org/ Phone: +1 415 235 3778 AI

Re: [HACKERS] [DOCS] Sync rep doc corrections

2011-03-07 Thread David Fetter
On Mon, Mar 07, 2011 at 02:31:18PM -0500, Robert Haas wrote: > On Mon, Mar 7, 2011 at 2:07 PM, David Fetter wrote: > > Re: docs, I'd actually like to see that list gone, as the separation > > of docs from code is one that's actively unhelpful.  We don't have a &g

  1   2   >