Re: [pgadmin-support] backup-restore does not work

[Art Fore]

Tried a refresh again and the table and views were gone. Then the 
restore worked. I do not understand why I do a refresh after dropping 
the table and views, they are still there, then a little later, do a 
refresh, they are gone. WHY?

How does one do an update to a table that is completely changed other 
than dopping it and restoring it? Seems like there should be an easier 
way that backup-restore.

Art
Art Fore wrote:
Using PGadminIII, I backup my database on linux machine (Postgresql 
7.4), and try to restore it on the windows machine (Postgresql 8.0 
beta5). Alway comes up with duplicate key on the first item.  I drop all 
views and the only table in the database and try again. Still same 
thing. I do a refresh, none of the views or table were dropped.

What is the secret of backup-restore is pgadmin?
Art
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
   (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]