Re: [DOCS] somewhat wrong archive_command example

2011-09-21 Thread Euler Taveira de Oliveira
On 21-09-2011 20:02, Greg Smith wrote: Attached version fixes the late night brain fade errors. I think the right thing to do next is to package this up into a doc update that corrects the errors in that section too; just clean the whole thing up while I'm poking at it. I'll submit that over to t

Re: [DOCS] somewhat wrong archive_command example

2011-09-21 Thread Greg Smith
On 09/21/2011 09:58 AM, Peter Eisentraut wrote: I can see a few problems with your script, as far as making it into a generally reusable example: - Uses bash. Portable scripts shouldn't do this. - Overwrites PATH variable for unrelated purpose. - Path ($PATH) should be quoted everywhere. (By

Re: [DOCS] Documentation 9.1 - can't be searched

2011-09-21 Thread Magnus Hagander
On Wed, Sep 21, 2011 at 13:52, Stefan Wolf wrote: > www.postgresql.org/docs/9.1/static/index.html > > > > „Your search for XX returned no hits“ Fixed, thanks for reporting it! --  Magnus Hagander  Me: http://www.hagander.net/  Work: http://www.redpill-linpro.com/ -- Sent via pgsql-docs m

Re: [DOCS] coalesce

2011-09-21 Thread Alvaro Herrera
Excerpts from Henry Drexler's message of mié sep 21 12:50:18 -0300 2011: > thanks, > > so I take it I am not getting those more complex examples (that are > apparently beyond my use case), I will take a look at them again. Maybe the fix is just to add a simpler example, without altering the word

Re: [DOCS] coalesce

2011-09-21 Thread Henry Drexler
thanks, so I take it I am not getting those more complex examples (that are apparently beyond my use case), I will take a look at them again. Thank you for the feedback. On Wed, Sep 21, 2011 at 10:33 AM, Kevin Grittner < kevin.gritt...@wicourts.gov> wrote: > Henry Drexler wrote: > > > "If the

Re: [DOCS] coalesce

2011-09-21 Thread Kevin Grittner
Henry Drexler wrote: > "If the results of the first argument are null, it will return the > second." Unless the second is also null, in which case it will return the third. Unless the third is also null... The trick is to come up with language which recognizes that there can be any number o

Re: [DOCS] somewhat wrong archive_command example

2011-09-21 Thread Peter Eisentraut
On tis, 2011-09-20 at 22:45 -0400, Greg Smith wrote: > Attached is a working local_backup_script.sh that does the same basic > thing as the "Standalone Hot Backups" example. It includes lots of > error checking, useful messages when it doesn't work like this: > > Archive directory does not exis

[DOCS] Documentation 9.1 - can't be searched

2011-09-21 Thread Stefan Wolf
www.postgresql.org/docs/9.1/static/index.html "Your search for XX returned no hits" Regards Stefan Wolf

[DOCS] coalesce

2011-09-21 Thread Henry Drexler
http://www.postgresql.org/docs/9.1/static/functions-conditional.html states: "The COALESCE function returns the first of its arguments that is not null. Null is returned only if all arguments are null." I was having a terrible time understanding this, and looking at the two examples were just as