Peter Childs <blue.dragon@blueyonder.co.uk> writes:
> Further examination.... I orignally used by 7.4 backup (taken
> every 12 hours and well tested that they work under 7.4 anyway) rather
> than redumping using pg_dump 8.0. I have now dumped using pg_dump version
> 8.0 same problem. I dumped just the schema. upon load into 8.0 a couple of
> lines saying
> ERROR: relation "test_id_seq" does not exist
> STATEMENT: REVOKE ALL ON TABLE shopping_id_seq TO PUBLIC;
> ERROR: relation "test_id_seq" does not exist
> STATEMENT: GRANT ALL ON TABLE test_id_seq TO PUBLIC;
Could you send me that dump off-list?
regards, tom lane