Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Welcome to the pgsql-bugs list!
- From: Raymond O'Donnell <rod(at)iol(dot)ie>
- To: jd(at)commandprompt(dot)com
- Cc: Christine Penner <christine(at)ingenioussoftware(dot)com>, Postgres-General <pgsql-general(at)postgresql(dot)org>
- Subject: Re: Welcome to the pgsql-bugs list!
- Date: Tue, 28 Apr 2009 21:19:07 +0100
- Message-id: <49F764BB.40808@iol.ie> <text/plain>
On 28/04/2009 21:09, Joshua D. Drake wrote: > On Tue, 2009-04-28 at 12:59 -0700, Christine Penner wrote: >> After looking closer at the log file I found something interesting: > >> This backup included the table creating aswell. How can it not have a >> column in the table. Am I wrong to assume that when I restore over an >> existing database it will delete things first? It looks like it doesn't. > > No it will not delete things first. I think that would be a serious > design flaw if it did so. If you want to see how the backup and restore works, do a backup with the PLAIN option and read through the resulting SQL file. The compress/tar options produce the same output only, well, compressed/tarred. :-) Ray. ------------------------------------------------------------------ Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland rod(at)iol(dot)ie Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals ------------------------------------------------------------------
- References:
- Re: Welcome to the pgsql-bugs list!
- From: Christine Penner
- Re: Welcome to the pgsql-bugs list!
- From: Joshua D. Drake
- Re: Welcome to the pgsql-bugs list!
- Prev by Date: Re: Welcome to the pgsql-bugs list!
- Next by Date: Re: UPDATE... FROM - will ORDER BY not respected?
- Previous by thread: Re: Welcome to the pgsql-bugs list!
- Next by thread: Best way to install postgres? RPM/Source Code Build
- Indexes: