On Tuesday 28 December 2010 8:45:14 pm Bob Pawley wrote: > -----Original Message----- > From: Alan Hodgson > Sent: Tuesday, December 28, 2010 8:12 PM > To: pgsql-general@xxxxxxxxxxxxxx > Subject: Re: Restore problem > > On December 28, 2010, Adrian Klaver <adrian.klaver@xxxxxxxxx> 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. Version control is a good way of handling incremental updates to function definitions when making changes to a live database. Also if the problem is one of incompatible line endings than version control is not necessarily a solution, you would just end up with multiple versions of the same problem:) The point of a database dump is to capture the state of a database at a point in time and recreate it, sort of a poor mans version control in itself. > > Bob > -- Adrian Klaver adrian.klaver@xxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
