[DOCS] Problems with 8.3.12 docs?

2011-01-08 Thread Steevie
Hello there,
I recently downloaded from [1] the A4 pdf manual for postgresql 8.3. I
noticed that in Section VI (SQL commands reference) all the hyperlinks
to other commands in the "See Also" part of each command description
do not link to those other command, but rather bring you back to page
1, i.e., the very beginning of the pdf. I do not think this is the
intended behaviour.

In addition, in the documentation version 8.3.12 there is no "content"
(as in kpdf are called adobe's bookmarks) that can be used to browse
the pages and move to a particular section. These bookmarks however
appeared in 8.3.4 version, which also has the same problem with
hyperlinks.

I can guess there has been some problem with pdflatex, so recompiling
the source might solve the problem.

I only wonder whether I should file a bug somewhere or if this report suffices.

Cheers,
Stefano
[1] http://www.postgresql.org/docs/manuals/

-- 
Sent via pgsql-docs mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs


Re: [DOCS] [BUGS] BUG #5814: documentation bug

2011-01-08 Thread Robert Haas
On Fri, Jan 7, 2011 at 10:19 PM, Josh Kupershmidt  wrote:
> [moving to pgsql-docs]
>
> On Wed, Jan 5, 2011 at 8:04 AM, Antje Petersen  wrote:
>> According to the documentation
>> createuser --no-superuser and
>> createuser --no-createrole is the default.
>> This is not true. The default is to be asked
>> Shall the new role be a superuser? (y/n)
>> Shall the new role be allowed to create more new roles? (y/n)
>
> I agree that the incorrect claims about defaults for --superuser,
> --createrole, and --createdb should be gotten rid of, since there are
> no defaults for these options and createuser will force you to answer
> Y or N for these options if you didn't specify on the command line.
>
> Simple doc patch attached. I think the "Examples" section demonstrates
> that createuser will prompt for this information without having to
> belabor this point in the doc.

Committed to master and REL9_0_STABLE.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

-- 
Sent via pgsql-docs mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs


Re: [DOCS] Addition to TOAST documentation in 8.4 comprehensive manual

2011-01-08 Thread Robert Haas
On Wed, Dec 22, 2010 at 9:05 PM, Aleksey Tsalolikhin
 wrote:
> I'd like to add the following to my proposed documentation tidbit, please:
>
>   The more offical/strict way, that does not rely on the
> implementation artifact that TOAST numeric ID is embedded in the TOAST
> symbolic name, is:
>
> select oid::regclass from pg_class where
> reltoastrelid='pg_toast_12513885'::regclass;

I think this might be a good thing to mention somewhere, but can you
make a more specific proposal about where you think it should be put,
maybe in the form of a patch?

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

-- 
Sent via pgsql-docs mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs


Re: [DOCS] Addition to TOAST documentation in 8.4 comprehensive manual

2011-01-08 Thread Aleksey Tsalolikhin
On Sat, Jan 8, 2011 at 3:16 AM, Robert Haas  wrote:
> On Wed, Dec 22, 2010 at 9:05 PM, Aleksey Tsalolikhin
>  wrote:
>> I'd like to add the following to my proposed documentation tidbit, please:
>>

>
> I think this might be a good thing to mention somewhere, but can you
> make a more specific proposal about where you think it should be put,
> maybe in the form of a patch?

Thank you very much, Robert.  I propose it be appended to the 8.4
comprehensive manual, Chapter 53.2 TOAST.  (And the 9 manual, if it's
true for 9.  I haven't touched 9 yet but I'm assuming this hasn't
changed?)

Here is the patch for 9.0.2 DocBook SGML:

*** storage.sgml.orig   2011-01-08 10:38:23.0 -0500
--- storage.sgml2011-01-08 10:48:53.0 -0500
***
*** 404,409 
--- 404,421 
  comparison table, in which all the HTML pages were cut down to 7 kB to fit.
  

+ 
+ To find the parent table given a TOAST table which has a
+ name like pg_toast_12513885, run:
+ 
+
+ 
+ 
+ select oid::regclass from pg_class where
+ reltoastrelid='pg_toast_12513885'::regclass;
+ 
+ 
+
  

  


And here is the patch for the 8.4.6 documentation:

*** storage.sgml.orig   2011-01-08 10:56:04.0 -0500
--- storage.sgml2011-01-08 10:56:06.0 -0500
***
*** 374,379 
--- 374,393 
  comparison table, in which all the HTML pages were cut down to 7 kB to fit.
  

+
+ 
+ To find the parent table given a TOAST table which has a
+ name like pg_toast_12513885, run:
+ 
+
+ 
+ 
+ select oid::regclass from pg_class where
+ reltoastrelid='pg_toast_12513885'::regclass;
+ 
+ 
+
+
  

  


Yours truly,
Aleksey

-- 
Sent via pgsql-docs mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs