Re: [DOCS] "FETCH returns data as if it were a SELECT result"

2005-08-02 Thread Roman Neuhauser
# [EMAIL PROTECTED] / 2005-08-02 13:09:58 -0400: > Roman Neuhauser <[EMAIL PROTECTED]> writes: > > "The variant of FETCH described here returns the data as if it were a > > SELECT result rather than placing it in host variables." > > > That doesn't

[DOCS] "FETCH returns data as if it were a SELECT result"

2005-08-02 Thread Roman Neuhauser
"The variant of FETCH described here returns the data as if it were a SELECT result rather than placing it in host variables." http://www.postgresql.org/docs/current/static/sql-fetch.html That doesn't seem to be the case. Try the following script: CREATE TABLE t1 (t1i INT, t1c CHAR(1)); CREATE T

Re: [DOCS] PostgreSQL 8.0.3 Documentation - Chapter 23. Monitoring Database Activity

2005-07-26 Thread Roman Neuhauser
# [EMAIL PROTECTED] / 2005-07-26 22:17:12 -0300: > --- Roman Neuhauser <[EMAIL PROTECTED]> escreveu: > > But maybe I'm not understanding the point you're trying to make. > > To make things a bit clearer: what is it that you find so disturbing > > or

Re: [DOCS] PostgreSQL 8.0.3 Documentation - Chapter 23. Monitoring Database Activity

2005-07-26 Thread Roman Neuhauser
# [EMAIL PROTECTED] / 2005-07-26 14:17:17 -0300: > What surprises me is not that the previous connection is closed and a > new connection is opened. > What surprises me is the fact that the previous process is killed and > a new process is forked just to connect to another database with the > same

Re: [DOCS] PostgreSQL 8.0.3 Documentation - Chapter 23. Monitoring Database Activity

2005-07-26 Thread Roman Neuhauser
# [EMAIL PROTECTED] / 2005-07-26 13:48:55 +: > --- Peter Eisentraut <[EMAIL PROTECTED]> escreveu: > > > Am Dienstag, 26. Juli 2005 12:06 schrieb Halley Pacheco de Oliveira: > > > The user, database, and connection source host items remain the same for > > > the life of the client connection, b

Re: [DOCS] faq 4.20: pl/pgsql temporary tables create/drop

2005-02-04 Thread Roman Neuhauser
# [email protected] / 2005-02-04 17:17:47 -0500: > Roman Neuhauser wrote: > > # [EMAIL PROTECTED] / 2005-02-04 12:30:00 -0500: > > > would be more appropriate in the proper documentation than in a FAQ. > > > > Every FAQ is an excuse for proper documentation.

Re: [DOCS] faq 4.20: pl/pgsql temporary tables create/drop

2005-02-04 Thread Roman Neuhauser
# [EMAIL PROTECTED] / 2005-02-04 12:30:00 -0500: > would be more appropriate in the proper documentation than in a FAQ. Every FAQ is an excuse for proper documentation. :) -- FreeBSD 4.10-STABLE 8:56PM up 13 hrs, 8 users, load averages: 0.00, 0.00, 0.00 ---(end of br

[DOCS] planner stats

2005-02-02 Thread Roman Neuhauser
Hello, trying to figure out the right statistics target for a large table, I found the reference manual lacking: the SET STATISTICS description under ALTER TABLE doesn't explain how to choose the right target (is there a formula?), I'm not insisting it should, but: it says "For more information