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 majordomo@postgresql.org)
>