Re: Detaching database

On Wed, Dec 28, 2005 at 01:00:27AM +0100, Petr wrote:
> I'm try to explain my problems. My customer have Postgre server with any
> older version of my DB (without any new or modified views, functions etc.)
> and when i create export (in pgAdmin3), then pg_dump makes a SQL script. Ok.
> It's nice, but when i'm trying to run this script on customer's machine,
> then i have many errors, because any views are not in his database, and
> script trying to drop it. When i'm set to don't make drop functions (in
> export), then i have other errors, with existing views (view allready
> exists).

So you get errors because it tries to drop views that don't exist.
That's OK, just keep going. Those errors don't break anything they just
warn you of something unexpected.

Alternativly you could create a new database from your SQL dump and
then copy the data you actually want to keep...

Have a nice day,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
> tool for doing 5% of the work and then sitting around waiting for someone
> else to do the other 95% so you can sue them.