Re: Restore problem - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Restore problem
Date
Msg-id 4D1AB195.7030408@gmail.com
Whole thread Raw
In response to Re: Restore problem  ("Bob Pawley" <rjpawley@shaw.ca>)
Responses Re: Restore problem  (Alan Hodgson <ahodgson@simkin.ca>)
List pgsql-general
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.
>
> I am not sure. If the file is not to big and you wish you can send it to
> me off list and maybe I can figure out what is going on.
>
> The file is over 9 meg - way to large for me to e-mail.
>
> It seems that this has affected just the triggers - although that is
> quite massive I will just plug away at it until it's done
>
> Thanks
>
> Bob

The triggers or functions? The sample you showed was from a function. My
suspicion is that this is a line ending problem
(http://en.wikipedia.org/wiki/Newline) and is a matter of finding the
correct conversion utility.

--
Adrian Klaver
adrian.klaver@gmail.com

pgsql-general by date:

Previous
From: "Bob Pawley"
Date:
Subject: Re: Restore problem
Next
From: Alan Hodgson
Date:
Subject: Re: Restore problem