[DOCS] Primary Key index
In response to a user asking a question about indexes on primary keys (http://archives.postgresql.org/pgsql-performance/2010-08/msg00194.php) I attach a patch to add information to the Primary Keys section of the Constraints page. While the information already exists on the CREATE TABLE, I don't think a brief mention on the page specifically concerning primary keys could hurt. So here's a patch to add it. Worth adding? Thanks -- Thom Brown Registered Linux user: #516935 primary_key_index.patch Description: Binary data -- Sent via pgsql-docs mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs
Re: [DOCS] Primary Key index
Thom Brown wrote: > In response to a user asking a question about indexes on primary > keys > (http://archives.postgresql.org/pgsql-performance/2010-08/msg00194.php) > I attach a patch to add information to the Primary Keys section of > the Constraints page. While the information already exists on the > CREATE TABLE, I don't think a brief mention on the page specifically > concerning primary keys could hurt. > > So here's a patch to add it. Worth adding? I think so, but I think we should cover UNIQUE constraints, too. I was also thinking about possibly mentioning it in the index overview page, and adding an entry or two to the documentation index, but maybe that's overkill. -Kevin -- Sent via pgsql-docs mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs
Re: [DOCS] Primary Key index
On 18 August 2010 17:09, Kevin Grittner wrote: > Thom Brown wrote: > >> In response to a user asking a question about indexes on primary >> keys >> > (http://archives.postgresql.org/pgsql-performance/2010-08/msg00194.php) >> I attach a patch to add information to the Primary Keys section of >> the Constraints page. While the information already exists on the >> CREATE TABLE, I don't think a brief mention on the page specifically >> concerning primary keys could hurt. >> >> So here's a patch to add it. Worth adding? > > I think so, but I think we should cover UNIQUE constraints, too. I > was also thinking about possibly mentioning it in the index overview > page, and adding an entry or two to the documentation index, but > maybe that's overkill. > Well I guess the question is: "where will most people first look to find that piece of information out?" As long as the information isn't digressing from the topic it's mentioned in, I don't see the problem. :) -- Thom Brown Registered Linux user: #516935 -- Sent via pgsql-docs mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs
Re: [DOCS] PDF docs text overflowing
On 18 August 2010 17:19, Thom Brown wrote: > Please look at the attached images. These are taken from the 8.4.4 A4 > PDF document. As you can see some examples in the PDF version of the > documentation are illegible, with text overflowing onto other text, > and off the page. > > And the margins on the documentation appear to be excessive too. > I should mention that these renderings are with the latest version of Adobe Reader. -- Thom Brown Registered Linux user: #516935 -- Sent via pgsql-docs mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs
Re: [DOCS] Primary Key index
Thom Brown wrote: > Well I guess the question is: "where will most people first look > to find that piece of information out?" The OP mentioned looking in the Indexes section of the documentation for the answer. > As long as the information isn't digressing from the topic it's > mentioned in, I don't see the problem. :) The Introduction to the Indexes section mentions how to create and drop indexes, without any mention of indexes tied to these constraints. -Kevin -- Sent via pgsql-docs mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs
[DOCS] Missing Win32 archive_command example
I noticed that there is no Win32 example for archive_command in our 9.0 docs in the PITR setup docs: http://www.postgresql.org/docs/9.0/static/continuous-archiving.html#BACKUP-ARCHIVING-WAL and no examples at all in the archive_command config section. We only show Win32 recovery syntax examples for recovery.conf: http://www.postgresql.org/docs/9.0/static/archive-recovery-settings.html A Win32 example did exist in our 8.4 docs for the archive_command definition: http://www.postgresql.org/docs/8.4/static/runtime-config-wal.html#RUNTIME-CONFIG-WAL-ARCHIVING Seems there should be a Windows example right next to the Unix archive_command example we have now. -- Bruce Momjian http://momjian.us EnterpriseDB http://enterprisedb.com + It's impossible for everything to be true. + -- Sent via pgsql-docs mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs
Re: [DOCS] Primary Key index
On ons, 2010-08-18 at 16:52 +0100, Thom Brown wrote: > In response to a user asking a question about indexes on primary keys > (http://archives.postgresql.org/pgsql-performance/2010-08/msg00194.php) > I attach a patch to add information to the Primary Keys section of the > Constraints page. While the information already exists on the CREATE > TABLE, I don't think a brief mention on the page specifically > concerning primary keys could hurt. > > So here's a patch to add it. Worth adding? is probably not appropriate here, because you are not defining the term for the first time. -- Sent via pgsql-docs mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs
Re: [DOCS] Primary Key index
On 18 August 2010 21:53, Peter Eisentraut wrote: > On ons, 2010-08-18 at 16:52 +0100, Thom Brown wrote: >> In response to a user asking a question about indexes on primary keys >> (http://archives.postgresql.org/pgsql-performance/2010-08/msg00194.php) >> I attach a patch to add information to the Primary Keys section of the >> Constraints page. While the information already exists on the CREATE >> TABLE, I don't think a brief mention on the page specifically >> concerning primary keys could hurt. >> >> So here's a patch to add it. Worth adding? > > is probably not appropriate here, because you are not > defining the term for the first time. > That is true. -- Thom Brown Registered Linux user: #516935 -- Sent via pgsql-docs mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs
Re: [DOCS] PDF docs text overflowing
On 18 August 2010 17:24, Thom Brown wrote: > On 18 August 2010 17:19, Thom Brown wrote: >> Please look at the attached images. These are taken from the 8.4.4 A4 >> PDF document. As you can see some examples in the PDF version of the >> documentation are illegible, with text overflowing onto other text, >> and off the page. >> >> And the margins on the documentation appear to be excessive too. >> > > I should mention that these renderings are with the latest version of > Adobe Reader. > Before I couldn't find any mention of this in the list archive, but found it when looking for issues with building the PDF: http://archives.postgresql.org/pgsql-docs/2010-04/msg00031.php So apologies for dupe posting. -- Thom Brown Registered Linux user: #516935 -- Sent via pgsql-docs mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs
