Re: [DOCS] Pattern with backslash commands in psql terminal

2006-05-23 Thread Tom Lane
Rolf Unger <[EMAIL PROTECTED]> writes: > The internal docs say that I can specify an optional pattern after the > \df or the \df+. And I think I read somewhere that the pattern is meant > to be a regular expression. No, it's more a shell-style pattern. Use "*" and "?". "." separates schema and o

[DOCS] Pattern with backslash commands in psql terminal

2006-05-23 Thread Rolf Unger
Hi Folks, actually I am not sure if this is the right mailing list, although I am quite sure that this is a documenation issue: I want to list the functions that are defined in a database and tried to use the internal \df command of the psql terminal (I use emacs so I don't need pgAdmin). Of cour

Re: [DOCS] Mention of minor upgrades

2006-05-23 Thread Bruce Momjian
Tom Lane wrote: > Bruce Momjian writes: > > In discussion with Jim Nasby, I have updated the FAQ to strongly > > encourage minor upgrading: > > > 3.6) Why do I need to do a dump and restore > > to upgrade between major PostgreSQL releases? > > The item heading seems misleading about what

Re: [DOCS] Mention of minor upgrades

2006-05-23 Thread Tom Lane
Bruce Momjian writes: > In discussion with Jim Nasby, I have updated the FAQ to strongly > encourage minor upgrading: > 3.6) Why do I need to do a dump and restore > to upgrade between major PostgreSQL releases? The item heading seems misleading about what the contents are. I think you n

[DOCS] Mention of minor upgrades

2006-05-23 Thread Bruce Momjian
In discussion with Jim Nasby, I have updated the FAQ to strongly encourage minor upgrading: 3.6) Why do I need to do a dump and restore to upgrade between major PostgreSQL releases? The PostgreSQL team makes only bug fixes in minor releases, so, for example, upgrading from 7.4.8 t

Re: [DOCS] Proposed doc-patch: Identifying the Current WAL file

2006-05-23 Thread Simon Riggs
On Sun, 2006-04-16 at 15:22 +0100, Simon Riggs wrote: > On Sat, 2006-04-15 at 16:20 -0400, Bruce Momjian wrote: > > Simon Riggs wrote: > > > On Sat, 2006-04-15 at 12:24 -0400, Bruce Momjian wrote: > > > > And if we can't provide one, should we supply an SQL function > > > > to return the current WA