Re: Restore problem - Mailing list pgsql-general

From Bob Pawley
Subject Re: Restore problem
Date
Msg-id 8D0D9E812AA94C96B04DDEE4B796243C@BobPC
Whole thread Raw
In response to Re: Restore problem  (Alan Hodgson <ahodgson@simkin.ca>)
Responses Re: Restore problem
Re: Restore problem
List pgsql-general

-----Original Message-----
From: Alan Hodgson
Sent: Tuesday, December 28, 2010 8:12 PM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Restore problem

On December 28, 2010, Adrian Klaver <adrian.klaver@gmail.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.

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


pgsql-general by date:

Previous
From: Bricklen
Date:
Subject: Re: B-tree index with sorting question
Next
From: Scott Marlowe
Date:
Subject: Re: Restore problem