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
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
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
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)
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
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
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:/
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?
> >
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
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)-
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/
-
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
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
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
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
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]
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
, 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
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
+---
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
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
21 matches
Mail list logo