Skip site navigation (1) Skip section navigation (2)

Re: Restore problem

From: Alan Hodgson <ahodgson(at)simkin(dot)ca>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Restore problem
Date: 2010-12-29 04:12:30
Message-ID: 201012282012.30694@hal.medialogik.com (view raw or flat)
Thread:
Lists: pgsql-general
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.

Also, try a unix2dos utility on the text of the functions before giving up 
and hand editing them.

-- 
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.

In response to

Responses

pgsql-general by date

Next:From: BricklenDate: 2010-12-29 04:28:23
Subject: Re: B-tree index with sorting question
Previous:From: Adrian KlaverDate: 2010-12-29 03:57:09
Subject: Re: Restore problem

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group