On Tuesday 28 December 2010 5:58:51 pm Bob Pawley wrote: > -----Original Message----- > From: Adrian Klaver > Sent: Tuesday, December 28, 2010 4:21 PM > To: pgsql-general@xxxxxxxxxxxxxx > Cc: Bob Pawley > Subject: Re: Restore problem > > On Tuesday 28 December 2010 3:06:40 pm Bob Pawley wrote: > > Hi > > > > I have restored a database using psql to windows version 8.4. > > > > During the restore the trigger code became jumbled. > > > > I now have a great number of lines that have moved so that they are now > > included in lines the have been commented out â not to mention that the > > code is hard to read. > > This is in the plain text dump file right? > > > Is there some way of correcting this â or re restoring the database, so > > that I donât have to go through the whole code line by line? > > With out seeing an example that is going to be difficult :) > > > Bob > > -- > Adrian Klaver > adrian.klaver@xxxxxxxxx > > This is the plain text dump file through pg_admin dump. But the plain text > dump fie through psql restored in the same way. I am not following. psql cannot create a dump file. It can however be used to restore a plain text dump file created by pg_restore. I think you are going to need show the steps you took. > > I don't have a copy of what it was but here is something quite similar to > the style I had before the dump.- > The restore process does not destroy the input file, it should still be available. -- 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
