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: | 2009-04-28 20:19:07 |
Message-ID: | 49F764BB.40808@iol.ie |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
------------------------------------------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | Adam Rich | 2009-04-28 20:28:40 | Re: UPDATE... FROM - will ORDER BY not respected? |
Previous Message | Joshua D. Drake | 2009-04-28 20:09:46 | Re: Welcome to the pgsql-bugs list! |