From: | Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Cc: | "Bob Pawley" <rjpawley(at)shaw(dot)ca>, "Alan Hodgson" <ahodgson(at)simkin(dot)ca> |
Subject: | Re: Restore problem |
Date: | 2010-12-29 15:49:18 |
Message-ID: | 201012290749.19007.adrian.klaver@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Tuesday 28 December 2010 8:45:14 pm Bob Pawley wrote:
> -----Original Message-----
> From: Alan Hodgson
> Sent: Tuesday, December 28, 2010 8:12 PM
> To: pgsql-general(at)postgresql(dot)org
> Subject: Re: [GENERAL] Restore problem
>
> On December 28, 2010, Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> wrote:
> > On 12/28/2010 07:40 PM, Bob Pawley wrote:
> > >> Open the file in Wordpad and see if it looks better.
> > >>
> > >> I downloaded an sql editor and it looks the same in it as well.
> > >>
> > >> At least the editor will make it easier to fix the problem. However I
> > >> would like to know what happened so I can avoid it in the future.
>
> It's often a good idea to maintain function definitions outside the
> database,
> under version control, and apply them to the database from there.
>
> I would appreciate a more detailed explanation of this.
Version control is a good way of handling incremental updates to function
definitions when making changes to a live database. Also if the problem is one
of incompatible line endings than version control is not necessarily a
solution, you would just end up with multiple versions of the same problem:)
The point of a database dump is to capture the state of a database at a point
in time and recreate it, sort of a poor mans version control in itself.
>
> Bob
>
--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2010-12-29 16:08:11 | Re: Restore problem |
Previous Message | Adrian Klaver | 2010-12-29 15:36:48 | Re: Restore problem |