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