Re: [BUGS] Documentation bug regarding collations

2012-01-28 Thread Tom Lane
Thomas Kellerer writes: > in the description of the ORDER BY clause > (http://www.postgresql.org/docs/current/static/sql-select.html#SQL-ORDERBY) > it says: > "Character-string data is sorted according to the locale-specific collation > order that was established when the database was created."

Re: [BUGS] Documentation bug: reference to checkpoint activity in bgwriter

2012-01-19 Thread Peter Geoghegan
On 20 January 2012 02:53, Robert Haas wrote: > OK, done. Thanks -- Peter Geoghegan       http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training and Services -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.po

Re: [BUGS] Documentation bug: reference to checkpoint activity in bgwriter

2012-01-19 Thread Robert Haas
On Mon, Jan 9, 2012 at 2:37 PM, Peter Geoghegan wrote: > On 9 January 2012 18:47, Robert Haas wrote: >> On Sat, Dec 31, 2011 at 8:54 PM, Peter Geoghegan >> wrote: >>> ISTM that the following reference, at config.sgml line 1345, ought to >>> be adjusted due to the introduction of the new checkpo

Re: [BUGS] Documentation bug: reference to checkpoint activity in bgwriter

2012-01-09 Thread Peter Geoghegan
On 9 January 2012 18:47, Robert Haas wrote: > On Sat, Dec 31, 2011 at 8:54 PM, Peter Geoghegan > wrote: >> ISTM that the following reference, at config.sgml line 1345, ought to >> be adjusted due to the introduction of the new checkpointer process: >> >>  Setting this to zero disables >>        

Re: [BUGS] Documentation bug: reference to checkpoint activity in bgwriter

2012-01-09 Thread Robert Haas
On Sat, Dec 31, 2011 at 8:54 PM, Peter Geoghegan wrote: > ISTM that the following reference, at config.sgml line 1345, ought to > be adjusted due to the introduction of the new checkpointer process: > >  Setting this to zero disables >         background writing (except for checkpoint activity).

Re: [BUGS] documentation bug - behave of NEW a OLD in plpgsql's triggers

2011-05-05 Thread Josh Kupershmidt
[Moving to -docs] On Mon, May 2, 2011 at 12:00 PM, Pavel Stehule wrote: > Hello > > one czech user reported a bug in documentation - > http://www.postgresql.org/docs/8.4/static/plpgsql-trigger.html > > NEW > >    Data type RECORD; variable holding the new database row for > INSERT/UPDATE operatio

Re: [BUGS] Documentation bug: Chapter 35.4, paragraph 4

2011-03-10 Thread Bruce Momjian
Robert Haas wrote: > On Tue, Nov 23, 2010 at 1:08 PM, Jonathan Pool wrote: > > Chapter 35.4, paragraph 4, of the PostgreSQL 9.0.1 Documentation says: > > > > Any collection of commands in the SQL language can be packaged together and > > defined as a function. Besides SELECT queries, the commands

Re: [BUGS] Documentation bug: Chapter 35.4, paragraph 4

2011-03-10 Thread Jonathan Pool
> I just made the wording more generic Thanks much. ˉ -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs

Re: [BUGS] Documentation bug: Chapter 35.4, paragraph 4

2010-11-28 Thread Robert Haas
On Tue, Nov 23, 2010 at 1:08 PM, Jonathan Pool wrote: > Chapter 35.4, paragraph 4, of the PostgreSQL 9.0.1 Documentation says: > > Any collection of commands in the SQL language can be packaged together and > defined as a function. Besides SELECT queries, the commands can include data > modifica

Re: [BUGS] Documentation

2007-09-25 Thread Milen A. Radev
karol dzięgielewski написа: > Hi, > Where can I find documentation in pdf format? > Regards Karol Dzięgielewski That's not a bug. http://www.postgresql.org/docs/manuals/ -- Milen A. Radev ---(end of broadcast)--- TIP 4: Have you searched our l

Re: [BUGS] Documentation

2007-09-25 Thread Magnus Hagander
karol dzięgielewski wrote: > Hi, > Where can I find documentation in pdf format? http://www.postgresql.org/docs/manuals/ //Magnus ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [BUGS] documentation

2006-11-02 Thread Tom Lane
Maxim Britov <[EMAIL PROTECTED]> writes: > maxim=# SELECT version() > maxim-# SELECT version(); > ERROR: syntax error at or near "SELECT" at character 18 > СТРОКА 2: SELECT version(); > ^ What you typed there was a two-line query equivalent to SELECT version() SELECT versi

Re: [BUGS] documentation

2006-11-02 Thread Maxim Britov
On Wed, 1 Nov 2006 15:57:22 +0200 Maxim Britov wrote: > I read it > http://www.postgresql.org/docs/8.1/interactive/tutorial-accessdb.html > > I can't use examples: Sorry, my I know my mistake now. :) -- Maxim Britov GnuPG KeyID 0x4580A6D66F3DB1FB xmpp:[EMAIL PROTECTED] icq 198171258 Finger

Re: [BUGS] Documentation regarding %ROWTYPE in PL/PgSQL

2002-06-15 Thread Bruce Momjian
Patch applied. Thanks. --- Andrew McMillan wrote: > On Wed, 2002-05-29 at 01:41, Tom Lane wrote: > > > > > Is it a good idea to provide an example (such as the above), or should I > > > just try and describe the behavi

Re: [BUGS] Documentation regarding %ROWTYPE in PL/PgSQL

2002-06-13 Thread Bruce Momjian
Your patch has been added to the PostgreSQL unapplied patches list at: http://candle.pha.pa.us/cgi-bin/pgpatches I will try to apply it within the next 48 hours. --- Andrew McMillan wrote: > On Wed, 2002-05-29 at

Re: [BUGS] Documentation regarding %ROWTYPE in PL/PgSQL

2002-05-30 Thread Andrew McMillan
On Wed, 2002-05-29 at 01:41, Tom Lane wrote: > > > Is it a good idea to provide an example (such as the above), or should I > > just try and describe the behaviour? > > Examples are generally good things ... OK, the attached documentation patch provides some simple examples of use of tablename

Re: [BUGS] Documentation regarding %ROWTYPE in PL/PgSQL

2002-05-28 Thread Tom Lane
Andrew McMillan <[EMAIL PROTECTED]> writes: > ... I can't supply either %ROWTYPE or %TYPE within the parameter > definition without an error either. Looks like I was mistaken: table.field%type works, but table%type does not: test72=# create table foo (f1 int, f2 text); CREATE test72=# create fun

Re: [BUGS] Documentation regarding %ROWTYPE in PL/PgSQL

2002-05-28 Thread Andrew McMillan
On Tue, 2002-05-28 at 04:59, Tom Lane wrote: > Andrew McMillan <[EMAIL PROTECTED]> writes: > > Reading between a few lines I got the impression that the manual > > suggested something like: > > CREATE or REPLACE myfunc( tablename%ROWTYPE ) RETURNS ... > > When I finally got my function working, I

Re: [BUGS] Documentation regarding %ROWTYPE in PL/PgSQL

2002-05-27 Thread Tom Lane
Andrew McMillan <[EMAIL PROTECTED]> writes: > Reading between a few lines I got the impression that the manual > suggested something like: > CREATE or REPLACE myfunc( tablename%ROWTYPE ) RETURNS ... > When I finally got my function working, I found I had: > CREATE or REPLACE myfunc( tablename ) RE

Re: [BUGS] Documentation

2002-05-03 Thread Tom Lane
[EMAIL PROTECTED] writes: > Section 3.3, tutorial-fk.html > You have written 'references weather' instead of 'references cities'. This seems to be fixed already. > Line 9 refers to 'advanced' instead of 'syscat' in syscat.py Good catch, thanks for the report! regards,

Re: [BUGS] Documentation nits

2001-11-17 Thread Peter Eisentraut
Rich Morin writes: > It is a ToC entry, looking like > >"12.1.7. The #random# test ... 76" > > where the '#'s actually show up as squares. Those are supposed to be double quotes. It's possible that the Microsoftish "smart quotes" snuck in here. We'll be alert next time around. -- Peter

Re: [BUGS] Documentation nits

2001-11-16 Thread Rich Morin
The peculiar codes (\223, \224) appear to be "character codes", but not ones that seem very standardized. The "PostScript Language Reference Manual" (2nd Ed.) gives the following information: "E.6 StandardEncoding Encoding Vector", p. 598 "E.9 Expert Encoding Vector", p. 602

Re: [BUGS] Documentation nits

2001-11-16 Thread Rich Morin
At 5:13 PM +0100 11/15/01, Peter Eisentraut wrote: >Rich Morin writes: > >> PostreSQL 7.1 Administrator's Guide >> >> On page iii (2nd line), something is printing as a square (?). > >Could you give some context? I don't have the specific document at hand. It is a ToC entry, looking like

Re: [BUGS] Documentation nits

2001-11-15 Thread Peter Eisentraut
Rich Morin writes: > PostreSQL 7.1 Administrator's Guide > >On page iii (2nd line), something is printing as a square (?). Could you give some context? I don't have the specific document at hand. > PostreSQL 7.1 Developer's Guide > >The Arabic page numbers do not match the actual page

Re: [BUGS] Documentation nits

2001-11-14 Thread Bruce Momjian
>On page xv (antepenultimate line), "Gnu Project" should be "GNU >Project". Fixed. Thanks. >On page 78, the "Release date" is listed as "2001-??-??". This is a tough one. We generate the docs before we know the date of final release. Does anyone have a suggestion on how to fix th

Re: [BUGS] Documentation Bug related to Inheritance

2001-07-23 Thread Felipe Alvarez Harnecker
Tom Lane writes: > >> Well, beside the referential constraint issue ( that can be solved by > >> hand ), the most frustrating is that queries like > >> DELETE FROM table* where key = some_value > >> Fails ( parser error ). ( UPDATE either ) > > Not as of 7.1. > > re

Re: [BUGS] Documentation Bug related to Inheritance

2001-07-20 Thread Tom Lane
>> Well, beside the referential constraint issue ( that can be solved by >> hand ), the most frustrating is that queries like >> DELETE FROM table* where key = some_value >> Fails ( parser error ). ( UPDATE either ) Not as of 7.1. regards, tom lane -

Re: [BUGS] Documentation Bug related to Inheritance

2001-07-20 Thread Bruce Momjian
> > Hi, i've posted various problems regarding inheritance in postgres, > Never see a reply :( > > Well, beside the referential constraint issue ( that can be solved by > hand ), the most frustrating is that queries like > > DELETE FROM table* where key = some_value > > Fails ( parser error )

Re: [BUGS] Documentation bug for pg_ctl (-s option not documented)

2001-05-03 Thread Bruce Momjian
This is fixed in 7.1.1. > Hello: > > In version 7.1 the man page for pg_ctl does not document -s option. > > Thanks, > -- > Arcady Genkin > > ---(end of broadcast)--- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/u

Re: [BUGS] Documentation Error -- JDBC

2000-10-15 Thread Bruce Momjian
Thanks. Docs updated. > The programmers guide states that in order to load the JDBC > driver, you use the class name "postgresql.Driver" > > http://www.postgresql.org/users-lounge/docs/7.0/programmer/jdbc6424.htm > > This is only true if you compile the driver to use the 1.1 > JDK; if you comp

Re: [BUGS] Documentation bug

2000-09-27 Thread Bruce Momjian
Thanks. Fixed. > Marius Kintel ([EMAIL PROTECTED]) reports a bug with a severity of 4 > The lower the number the more severe it is. > > Short Description > Documentation bug > > Long Description > in file "user/app-psql.htm" > > \copy table [ with oids ] { from | to } filename | stdin | stdou