The following bug has been logged online:
Bug reference: 3691
Logged by: Maryz
Email address: [EMAIL PROTECTED]
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
Maybe it's not a bug. Maybe I do something wrong?
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly