[DOCS] PostgreSQL 8.2.3 Documentation - createuser - echoed command

In the createuser command page is written: To create the user joe as a superuser, and assign a password immediately: $ createuser -P -s -e joe Enter password for new role: xyzzy Enter it again: xyzzy CREATE ROLE joe PASSWORD 'xyzzy' SUPERUSER CREATEDB CREATEROLE INHERIT LOGIN; CREATE ROLE In the

[DOCS] PostgreSQL 8.0.3 Documentation - Chapter 30. The Information Schema

In 30.29. sql_implementation_info is written: The table sql_information_info ... I couldn't find the table "sql_information_info". I think it shoud be "sql_implementation_info" Regards, Halley __ Converse com seus amigos em tempo real com o Yahoo

[DOCS] PostgreSQL 8.0.3 Documentation - Appendix F. The CVS Repository

It is written: Anonymous CVS 1. You will need a local copy of CVS (Concurrent Version Control System), which you can get from http://www.cvshome.org/ (the official site with the latest version) But when you try to access this link you get the message: CVS development and the CVS information pa

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

--- Alvaro Herrera <[EMAIL PROTECTED]> escreveu: > > Hmm, seems a very similar thing can be had in Postgres by means of > pgpool. > You're right. Using a JDBC connection pool to cache database connections, reuse physical connections and minimize expensive operations in the creation and closing

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

The surprise is: Oracle - MTS - Multi-Threaded-Server - MTS allows many user processes to share very few server processes. Without MTS, each user process requires its own dedicated server process; a new server process is created for each client requesting a connection. A dedicated server proce

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

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 user. I was expecting that the new connection could use

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

aders about this fact. Maybe other users dont't expect this fact too. Just that. Regards, Halley --- Peter Eisentraut <[EMAIL PROTECTED]> escreveu: > Am Dienstag, 26. Juli 2005 12:06 schrieb Halley Pacheco de Oliveira: > > The user, database, and connection source host

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

In PostgreSQL 8.0.3 Documentation - Chapter 23. Monitoring Database Activity - 23.1. Standard Unix Tools is written: The user, database, and connection source host items remain the same for the life of the client connection, but the activity indicator changes. But look at that: psql -U sistema

[DOCS] PostgreSQL 8.0.3 Documentation - Chapter 21. Routine Database Maintenance Tasks

21.3. Log File Maintenance It is written: "Another production-grade approach to managing log output is to send it all to syslog and let syslog deal with file rotation. To do this, set the configuration parameter log_destination to syslog (to log to syslog only) in postgresql.conf. Then you can

[DOCS] PostgreSQL Documentation - New Appearance

The HTML documentation that is produced using "make postgres.html" in the source distribution has a different appearance than the documentation in http://www.postgresql.org/docs/8.0/static/index.html (Designed by tinysofa). Where do I get the stylesheet and anything else needed to produce a docum

[DOCS] buffer freelist

PostgreSQL 8.0.3 Documentation Chapter 16. Server Run-time Environment 16.4. Run-time Configuration debug_shared_buffers (integer) Number of seconds between buffer freelist reports. If set greater than zero, emit freelist statistics to the log every so many seconds. Zero (the default) disables

[DOCS] current_schemas()

I would like to know how to use current_schemas(), since SELECT current_schemas(); didn't work in PostgreSQL 7.4 and 8.0 psql. Halley PostgreSQL 8.0.3 Documentation Chapter 16. Server Run-time Environment 16.4. Run-time Configuration The current effective value of the search path can be examine

Re: [DOCS] PostgreSQL 7.4 and 8.0 - psql reference

found > \dt foo"BAR"baz ... -+---++-- public | fooBARbaz | table | postgres (1 row) Thanks, Halley --- Tom Lane <[EMAIL PROTECTED]> escreveu: > Halley Pacheco de Oliveira <[EMAIL PROTECTED]> writes: > > In Part II - PostgreSQL Client Application

[DOCS] Chapter 44. Native Language Support

In Chapter 44. Native Language Support, 44.1.2. Concepts (http://www.postgresql.org/docs/8.0/interactive/nls.html) is written: The extension of the message catalog file is to no surprise either .po or .mo. The base name is either the name of the program it accompanies, or the language the file is

[DOCS] PostgreSQL 7.4 and 8.0 - psql reference

In Part II - PostgreSQL Client Applications, psql -- PostgreSQL interactive terminal (psql-ref.sgml - http://www.postgresql.org/docs/8.0/interactive/app-psql.html) is written: For example, FOO"BAR"BAZ is interpreted as fooBARbaz, and "A weird"" name" becomes A weird" name. So using psql I tri

Re: [DOCS] process hangs when converting sgml documentation to PDF

I have a Red Hat Linux 9.0 installed just to convert SGML to RTF, once it hangs in Fedora Core 3. Halley __ Converse com seus amigos em tempo real com o Yahoo! Messenger http://br.download.yahoo.com/messenger/ ---(end of

[DOCS] Generate Windows MO files in Linux

I use PostgreSQL 8.0.1 in Windows, so I did a download of postgresql-8.0.1.tar.gz file using Linux, edited the pt_BR.po translation for psql using KBabel, generate the psql.mo file using "msgfmt --statistic -v -c -o psql.mo pt_BR.po" which returned "496 messages translateds", and moved the psql.

[DOCS] PostgreSQL 7.4 Documentation - 43.24. pg_proc

It is written: prolang oid pg_langauge.oid Implementation language or call interface of this function But it should be 'pg_language.oid' and not 'pg_langauge.oid' Halley ___ Yahoo! Mail agora com 100MB, anti

[DOCS] PostgreSQL 7.4 Documentation - The Information Schema

In 32.12. data_type_privileges is written: Table 32-10. domain_constraints Columns But it should be: Table 32-10. data_type_privileges Columns Ok? Halley __ Participe da pesquisa global sobre o Yahoo! Mail: http://br.survey

[DOCS] PostgreSQL 7.4 Documentation - PL/pgSQL

In PL/pgSQL - SQL Procedural Language, 37.6.2. SELECT INTO, is written: Here is an example that handles the case where no rows have been returned: DECLARE users_rec RECORD; full_name varchar; BEGIN SELECT INTO users_rec * FROM users WHERE user_id=3; IF users_rec.homepage IS NULL

Re: [DOCS] to_ascii function

t, Jun 05, 2004 at 10:39:15AM -0300, Halley > Pacheco de Oliveira wrote: > > This query didn't work as I was expecting. Any > reasons > > for that ? > > > > SELECT TO_ASCII('ÁÉÍÓÚáéíóú??°') > > > > result -> 'AEIOUaeioua ' &g

[DOCS] to_ascii function

This query didn't work as I was expecting. Any reasons for that ? SELECT TO_ASCII('ÁÉÍÓÚáéíóúªº°') result -> 'AEIOUaeioua ' I used psql, java and phpPgAdmin without success. (PostgreSQL 7.4.2 encoding latin1) Regards, Halley ___

[DOCS] PostgreSQL 7.4.1 Documentation

In file runtime.sgml is written: See also http://www.sunworld.com/swol-09-1997/swol-09-insidesolaris.html";> for information on shared memory under Solaris. But I found this page in: http://sunsite.uakom.sk/sunworldonline/swol-09-1997/swol-09-insidesolaris.html and not in http://www.sunworld.

[DOCS] PostgreSQL 7.4 Documentation - perform.sgml

In file perform.sgml is written: The amount of information stored in pg_statistic, in particular the maximum number of entries in the most_common_vals and histogram_bounds arrays for each column, can be set on a ... But most_common_vals and histogram_bounds are columns from the view pg_stats and

[DOCS] jade X openjade

In my Athon 1.7 512 MB RAM computer with Debian it takes 2m6s to generate de PostgreSQL 7.4.1 HTML documentation using JADE and 4m7s using OPENJADE (almost 2X). So why use OPENJADE ? Halley __ Yahoo! Mail - O melhor e-mail do Br

[DOCS] psql documentation

Reference Manual - psql entry: In app-psql.html is witten: Note: To simplify typing, commands that consists of several words do not have to be quoted. Thus it is fine to type \help alter table So, I tried: template1=# \help 'alter table' No help available for ''alter table''. Try \h with no arg

[DOCS] PostgreSQL 7.4 Documentation - create/drop_operator.sgml

In file create_operator.sgml is written: Line 133: lefttype Line 136: The type of the left-hand argument of the operator, if any. In file drop_operator.sgml is written: Line 51: lefttype Line 54: The data type of the operator's left operand; The same applies to righttype. I think both should

[DOCS] PostgreSQL 7.4 Documentation - create_trigger.sgml

In file create_trigger.sgml line 25 is written: funcname and in line 36 is written: class="parameter">func and in line 146 is written: func I think it should be func or funcname in all these lines. In line 40 is written: ... either before before the Halley

Re: [DOCS] DocBook V4.2, on the way to XML

*** This is the definition of DocBook itself. We currently use version 4.2; you cannot use later or earlier versions. Note that there is also an XML version of DocBook -- do not use that. *** Regards, Halley --- Peter Eisentraut <[EMAIL PROTECTED]> escreveu: > Halley Pacheco

Re: [DOCS] DocBook V4.2, on the way to XML

Dear Peter, Please tell me from where I can download this upgraded documentation so I can try by myself. Thanks, Halley > Peter Eisentraut <[EMAIL PROTECTED]> writes: > > I've upgraded our documentation to DocBook V4.2 > SGML. ___

[DOCS] PostgreSQL 7.4 Documentation - create_sequence.sgml

In the create_sequence.sgml is written: The optional clause INCREMENT BY increment specified, which value is added to the current sequence value to create a new value. I think it is wrong and could be: The optional clause INCREMENT BY increment specifies the value to be added to the current sequ