From: | "Bob Pawley" <rjpawley(at)shaw(dot)ca> |
---|---|
To: | "Alan Hodgson" <ahodgson(at)simkin(dot)ca>, <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Restore problem |
Date: | 2010-12-29 04:45:14 |
Message-ID: | 8D0D9E812AA94C96B04DDEE4B796243C@BobPC |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
-----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.
Bob
Also, try a unix2dos utility on the text of the functions before giving up
and hand editing them.
I'll look at that - I'm also looking at something called Vim
http://www.vim.org/download.php
Bob
--
A hybrid Escalade is missing the point much in the same way that having a
diet soda with your extra large pepperoni pizza is missing the point.
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Marlowe | 2010-12-29 06:00:19 | Re: Restore problem |
Previous Message | Bricklen | 2010-12-29 04:28:23 | Re: B-tree index with sorting question |