Re: Restore problem - Mailing list pgsql-general

From Bob Pawley
Subject Re: Restore problem
Date
Msg-id B85CFA9910AA480BB08E059D327B8F6D@BobPC
Whole thread Raw
In response to Re: Restore problem  (Alban Hertroys <dalroi@solfertje.student.utwente.nl>)
List pgsql-general

-----Original Message-----
From: Alban Hertroys
Sent: Wednesday, December 29, 2010 4:03 AM
To: Bob Pawley
Cc: Adrian Klaver ; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Restore problem

On 29 Dec 2010, at 4:40, Bob Pawley wrote:
> 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


(Gosh, those lines were hard to find!)

How did you create those functions? With notepad, or from within pgadmin? If
you look at the function bodies as they are in the database, are their
line-endings correct?
It's possible that the error occurred as early as that.

Alban Hertroys

The code example I sent has been dumped and restored numerous times and yes
it was created in PGAdmin.

This dump was from version 8.3 if that means anything.

Bob

--
If you can't see the forest for the trees,
cut the trees and you'll see there is no forest.


!DSPAM:1208,4d1b2395802657602216958!


pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Restore problem
Next
From: "Bob Pawley"
Date:
Subject: Re: Restore problem