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@iol.ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------