Re: [DOCS] plperl and triggers

2006-09-11 Thread Michael Fuhr
on doesn't describe the semantics but the "Triggers" chapter does. If you've found a discrepancy between documentation and behavior then please post a self-contained test case. -- Michael Fuhr ---(end of broadcast)--- TIP 9

Re: [DOCS] Minor changed needed to doc on untrusted pl/perl example

2005-10-21 Thread Michael Fuhr
system, anyway). Not that I disagree with adding an explicit close, but the example should still "work" without it. -- Michael Fuhr ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [DOCS] Commented, loadable databases as examples?

2005-10-11 Thread Michael Fuhr
uld be a good way to make the documentation a bit more > concrete. Are you looking for something other than the Tutorial and the examples in the source code under src/tutorial? -- Michael Fuhr ---(end of broadcast)--- TIP 5: don't forget to

[DOCS] Multicolumn index doc out of date?

2005-09-12 Thread Michael Fuhr
nations. (In a query involving a and c the planner could choose to use the index for a, while treating c like an ordinary unindexed column.) http://developer.postgresql.org/docs/postgres/indexes-multicolumn.html -- Michael Fuhr ---(end of broadcast)

Re: [DOCS] Beta Docs

2005-07-21 Thread Michael Fuhr
On Thu, Jul 21, 2005 at 03:32:28PM -0500, Thomas F. O'Connell wrote: > > There used to be a link to a built development version of the docs on > the old developer site. Anyone know where that has gone? >From http://www.postgresql.org/ the link is under Developers -> Testin

Re: [DOCS] Possible copy error in explain example

2005-04-11 Thread Michael Fuhr
enk1'; you will find out that tenk1 has 233 disk pages and 1 rows. So the cost is estimated at 233 page reads, defined as costing 1.0 apiece, plus 1 * cpu_tuple_cost which is currently 0.01 (try SHOW cpu_tuple_cost). Doesn't that work out to (233 * 1.0) + (1 * 0.01

[DOCS] Mention PL/Python newline handling?

2005-03-30 Thread Michael Fuhr
rs/2005-03/msg00342.php I can submit a documentation patch before 8.0.2 wraps if necessary. Any preferences on where a change should go? Maybe at the end of "38.1. PL/Python Functions"? http://www.postgresql.org/docs/8.0/static/plpython.html -- Michael Fuhr http:/

Re: [DOCS] Bibliography updates for new editions?

2005-02-15 Thread Michael Fuhr
On Tue, Feb 15, 2005 at 10:11:58AM -0700, Michael Fuhr wrote: > On Tue, Feb 15, 2005 at 10:57:34AM +0100, Peter Eisentraut wrote: > > Am Dienstag, 15. Februar 2005 03:20 schrieb Michael Fuhr: > > > Should entries in the Bibliography be updated to reflect new editions? > >

Re: [DOCS] Bibliography updates for new editions?

2005-02-15 Thread Michael Fuhr
On Tue, Feb 15, 2005 at 10:57:34AM +0100, Peter Eisentraut wrote: > Am Dienstag, 15. Februar 2005 03:20 schrieb Michael Fuhr: > > Should entries in the Bibliography be updated to reflect new editions? > > Sure. Please submit a patch. Will do. Just wanted to make sure I woul

[DOCS] Bibliography updates for new editions?

2005-02-14 Thread Michael Fuhr
or another bookseller? If the project would rather not favor a particular retailer, then maybe it would be reasonable to link to the publishers' own web pages where such exist. -- Michael Fuhr http://www.fuhr.org/~mfuhr/ ---(end of broadcast)-

Re: [DOCS] How the planner uses statistics

2005-02-12 Thread Michael Fuhr
On Sat, Feb 12, 2005 at 03:22:10PM -0800, Josh Berkus wrote: > > Terrific. I'd be happy to post this at www.powerpostgresql.org, if you > want; Shouldn't that be www.powerpostgresql.com? -- Michael Fuhr http://www.fuhr.org/~mfuhr/ -

Re: [DOCS] Typo in performance-tips.html

2005-02-02 Thread Michael Fuhr
On Wed, Feb 02, 2005 at 11:15:10PM -0700, Michael Fuhr wrote: > > Here's a brief article about how the "y" in "ye" is a misspelling > of the "thorn" (รพ) character: > > http://www.bartleby.com/68/15/6615.html Here's another article men

Re: [DOCS] Typo in performance-tips.html

2005-02-02 Thread Michael Fuhr
elandic language still uses the thorn character, if I'm not mistaken. -- Michael Fuhr http://www.fuhr.org/~mfuhr/ ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

[DOCS] FAQ 4.11.* numbering is off

2005-01-31 Thread Michael Fuhr
ion with other users? 4.11.4) Why aren't my sequence numbers reused on transaction abort? -- Michael Fuhr http://www.fuhr.org/~mfuhr/ ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [DOCS] SET documentation could mention ALTER USER, etc.

2005-01-28 Thread Michael Fuhr
On Fri, Jan 28, 2005 at 07:20:29PM -0500, Tom Lane wrote: > Michael Fuhr <[EMAIL PROTECTED]> writes: > > Suggestion for the SET documentation: mention that settings can be > > made permanent by editing postgresql.conf and reloading the postmater, > > or by using A

[DOCS] SET documentation could mention ALTER USER, etc.

2005-01-28 Thread Michael Fuhr
s the value used by the current session." -- Michael Fuhr http://www.fuhr.org/~mfuhr/ ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [DOCS] allballs

2005-01-24 Thread Michael Fuhr
r clock (communications, military, etc.). Here's an example: http://www2.jpl.nasa.gov/basics/bsf2-3.html I don't know that "allballs" is specified in any standard, so I suspect that somebody who used the term added it to PostgreSQL (or whatever it was called at the time) for conv

[DOCS] FAQ 4.15 misleading about uniqueness of OIDs

2005-01-23 Thread Michael Fuhr
, the following sections: http://www.postgresql.org/docs/8.0/static/datatype-oid.html http://www.postgresql.org/docs/8.0/static/ddl-system-columns.html -- Michael Fuhr http://www.fuhr.org/~mfuhr/ ---(end of broadcast)--- TIP 8: explain analyze is your friend

[DOCS] FAQ doesn't mention ALTER COLUMN TYPE

2005-01-16 Thread Michael Fuhr
Question 4.4 in the FAQ, "How do you remove a column from a table, or change its data type?" doesn't mention 8.0's ability to alter a column's type with ALTER TABLE tab ALTER COLUMN col TYPE new_type. Since 8.0 is coming up the FAQ should probably mention thi

[DOCS] Adding a Column: default values now allowed

2005-01-09 Thread Michael Fuhr
+--- item 1 | 123 item 2 | 123 item 3 | 123 (3 rows) -- Michael Fuhr http://www.fuhr.org/~mfuhr/ ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL P

Re: [DOCS] multimedia data storage issue

2004-11-08 Thread Michael Fuhr
is may not be the specific information you seek, but it does show that users can extend PostgreSQL to fit their needs. -- Michael Fuhr http://www.fuhr.org/~mfuhr/ ---(end of broadcast)--- TIP 8: explain analyze is your friend