Skip site navigation (1) Skip section navigation (2)

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

From: "Dan Langille" <dan(at)langille(dot)org>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-docs(at)postgresql(dot)org
Cc: pgsql-docs(at)postgresql(dot)org
Subject: Re: Do we need "Diagnostics" sections of SQL command reference pages?
Date: 2003-08-26 13:52:20
Message-ID: 3F4B2DD4.23482.19DE8A50@localhost (view raw, whole thread or download thread mbox)
Lists: pgsql-docs
On 26 Aug 2003 at 9:37, Tom Lane wrote:

> "Dan Langille" <dan(at)langille(dot)org> writes:
> > On 26 Aug 2003 at 9:14, Tom Lane wrote:
> >>
> > 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.

Agreed.  If the command description contains enough information, the 
DIAGNOSTICS section is no longer needed.

> > 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,
> but under Unix it should be sufficient no?

For me, yes.  I do like the idea of a DETAIL field.  The more info 
the better.  The HINT would be nice to have.
Dan Langille :

In response to

pgsql-docs by date

Next:From: Dan LangilleDate: 2003-08-26 18:21:00
Subject: Changing the sequence owner
Previous:From: Tom LaneDate: 2003-08-26 13:37:04
Subject: Re: Do we need "Diagnostics" sections of SQL command reference pages?

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group