Re: [DOCS] Do we need "Diagnostics" sections of SQL command reference pages?

[Chris M]

"Tom Lane" <[EMAIL PROTECTED]> Write news:[EMAIL PROTECTED]
> "Dan Langille" <[EMAIL PROTECTED]> writes:
> > On 26 Aug 2003 at 9:14, Tom Lane wrote:
> >> http://developer.postgresql.org/docs/postgres/sql-createdatabase.html
>
> > The value I see in those message is it gives the reader more
> > information about what can go wrong.  The above example shows that
> > you cannot use "create database" within a transaction.
>
> Sure, but that should have been stated in the command description.
>
> > Also, the information under "ERROR: Could not initialize database
> > directory." is pretty good.
>
> I chose this example deliberately, because it's one of very few pages
> where there's actually nontrivial content in the Diagnostics section.
> "could not initialize database directory" seems to me the only one
> of these messages that requires more info (the "could not create
> database directory" message now includes the kernel error code, so
> it's sufficiently improved IMHO).  What I'm inclined to do about it
> is add a DETAIL field showing the exact "cp" command that failed, and
> perhaps a HINT suggesting that people look in the postmaster's stderr
> log to see cp's complaint.  Not sure how to translate that to Windows,

Windows port may use "copy", "xcopy" to copy files.  In Windows, "copy"
is not so powerful as "xcopy". But I don't think using OS specific shell
commands
a good idea. If environment variable PATH is not set correctly, using these
commands
may cause a fail.

> but under Unix it should be sufficient no?
>
> regards, tom lane
>
> ---(end of broadcast)---
> TIP 9: the planner will ignore your desire to choose an index scan if your
>   joining column's datatypes do not match
>



---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?

   http://www.postgresql.org/docs/faqs/FAQ.html

Re: [DOCS] Changing the sequence owner

[Chris M]

I think it is a good idea.
Providing an example is better.

""Dan Langille"" <[EMAIL PROTECTED]>
news:[EMAIL PROTECTED]
> Should we make some reference to ALTER TABLE on the the sequence
> page?  A sequence owner is changed via:
>
>   alter table forums_auth_id_seq owner to phorum;
>
> That's not intuitive unless you know the innards.  We need to point
> the users there.
>
> There are references to sequences within the ALTER TABLE
> documentation ("This form changes the owner of the table, index,
> sequence or view to the specified user.") but you have to know about
> it in the first place.
> -- 
> Dan Langille : http://www.langille.org/
>
>
> ---(end of broadcast)---
> TIP 6: Have you searched our list archives?
>
>http://archives.postgresql.org
>



---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster