Re: [GENERAL] Problems with pg_restore

[Richard Huxton]

Kaloyan Iliev Iliev wrote:
Hi ,
I have the following problem.
DBVersion:  PostgreSQL 7.2.3 on i386-pc-bsdi4.0.1, compiled by GCC 2.7.2.1
I have a dump of a database on two parts.
Here are the dump commands:
pg_dump  -s -S postgres "db_name" |gzip > "db_name.shema.sql"
pg_dump -S postgres -a -Fc "db_name" > "db_name.data.dump"
So restore twice the schema with the following command:
psql -e "db_name" < "db_name.shema.sql"
psql -e "db_name" < "db_name.shema.sql"
I do it twice because some tables don't create from the first time.
[snip]
Now I try to delete it in PG8.0.0 but :
ALTER TABLE ONLY epay_requests_archive DROP COLUMN deleted RESTRICT;
ERROR:  cannot drop inherited column "deleted"
The problem is that I don't have another copy of this database so I must 
find a way to restore it.
If you've got two versions of PG, it's usually best to use the most 
recent pg_dump - each version is smarter than the last, but is 
backwards-compatible quite a way. Try dumping with the 8.0 version of 
pg_dump.

--
  Richard Huxton
  Archonet Ltd
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
              http://www.postgresql.org/docs/faqs/FAQ.html