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 Lane||Date: 2002-11-24 22:36:34|
|Subject: Re: more information on OSX pg_dump problem |
|Previous:||From: Colin Stearman||Date: 2002-11-24 20:11:58|
|Subject: Re: pg_dump/pg_restore |