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

more information on OSX pg_dump problem

From: Theodore Petrosky <tedpet5(at)yahoo(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: more information on OSX pg_dump problem
Date: 2002-11-24 22:33:55
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs
So, as I said I have a problem restoring data created
with pg_dump. Here is something interesting.

The pg_dump file contains a couple of tables. Some of
them are working. If I go to the line that psql is
telling me is failing, I find the commands to begin
recreating the table:
COPY "fcopenjobs"  FROM stdin;
If I copy and paste the lines (from the dump file)
into psql one by one, it will input fine. However, If
I cut and paste more that two lines, the input fails.
To me (and I have limited knowledge) it appears that
there is some delay that is making things get out of
sync. If  there were some way to 'slow down' the paste
it may work. 

There appears to be a problem here. Any help will be

BTW, I had the same problem with 7.3 beta 5. I
downgraded to 7.2.3 because I thought that was the 
problem. Now I know that I can go back to 7.3b5 and
have the same problem.


Do you Yahoo!?
Yahoo! Mail Plus  Powerful. Affordable. Sign up now.


pgsql-bugs by date

Next:From: Tom LaneDate: 2002-11-24 22:36:34
Subject: Re: more information on OSX pg_dump problem
Previous:From: Colin StearmanDate: 2002-11-24 20:11:58
Subject: Re: pg_dump/pg_restore

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