Re: dump-restore only one table

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Alexander Kuprijanov <sanya-spb(at)list(dot)ru>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: dump-restore only one table
Date: 2007-05-01 16:02:55
Message-ID: 17887.1178035375@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Alexander Kuprijanov <sanya-spb(at)list(dot)ru> writes:
> On Tuesday 01 May 2007 18:43:37 Tom Lane wrote:
>> Works for me. Perhaps your table name is mixed-case and you didn't
>> quote it correctly? Have you tried 'pg_restore -l' to verify what
>> is in the dump file?

> no, tablenames not mixed, all small-case letter

Hmph. I tried to reproduce your problem here (even to the extent of
using 8.2 pg_dump to dump from an 8.1 database) but it works fine as
far as I can tell. If you leave off the --table option to pg_restore
does it restore the data? Can you put together a complete test-case
to make it fail for someone else?

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Josh Berkus 2007-05-01 16:23:47 Re: Feature Request --- was: PostgreSQL Performance Tuning
Previous Message Erik Jones 2007-05-01 15:37:50 Re: IF function?