Re: BUG #3691: bug in pg_restore

Maryz wrote:
> The following bug has been logged online:
>
> Bug reference:      3691
> Logged by:          Maryz
> Email address:      mairambija@gmail.com
> PostgreSQL version: 8.0-8.3b
> Operating system:   WinXP
> Description:        bug in pg_restore
> Details:
>
> In Postgres 8.0-8.2 and now 8.3b backup data in other schemas (not public
> schema) with pg_dump. Later with pg_restore I can't restore it.
> For example dump:
> pg_dump.exe --format=custom -b -i --disable-triggers -h localhost -p 5432 -U
> postgres -a postgres -f dmp\other.itm_blygis.out -t other.itm_blygis
>
> Restore:
> pg_restore.exe -h localhost -p 5432 -U postgres -a postgres --format=c -a -i
> --disable-triggers  -t other.itm_blygis -v dmp\other.itm_blygis.out

What's the error you get?

--
  Heikki Linnakangas
  EnterpriseDB   http://www.enterprisedb.com