Обсуждение: Restore question
I've recently had to restore a couple of db's from backup and there were obsolete employee tables in the dbs. Now I can't drop or rename this or any other tables to properly load new ones. sqltest=# drop table employee sqltest-# I used pg_dump on the two dbs, and restored with the following: psql -f /home/steve/080502sltestdb.out sqltest Psql is also broken for the next command after one of these failed drops (when it's showing the - instead of =): sqltest-# select * from employee; ERROR: parser: parse error at or near "select" try again and: sqltest=# select * from employee; id | employee_id | name | addr1 | addr2 | addr3 | workphone | homephone | grade | title_position | salary | salarytype | exemptcode | gov_id | email | startdate | enddate | notes Does anyone recognize what's broken here or know what I might be able to do to fix it? Thanks for any assistance. Steve
On Mon, 5 Aug 2002, Steve Doerr wrote: > I've recently had to restore a couple of db's from backup and there were > obsolete employee tables in the dbs. > > Now I can't drop or rename this or any other tables to properly load new > ones. > > sqltest=# drop table employee > sqltest-# Errm, you need a semicolon at the end of that.