Arindam <[EMAIL PROTECTED]> writes:
> In all the above cases, this is the error I get:
> pg_restore: [archiver (db)] could not execute query: ERROR: cannot
> drop schema public because other objects depend on it
> HINT: Use DROP ... CASCADE to drop the dependent objects too.
> Command was: DRO
I am writing a script to carry out updates from Postgres 7.2.1 to
8.1.5. The strategy is as follows:
1. Take the dump of the 7.2.1 database using pg_dump (of 8.1.5)
2. Stop the database
3. Uninstall the database
4. Install the database and start the database
5. Restore the dump taken in step 1 us
