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

2005-02-09 Thread Andreas Pflug
Art Fore wrote: 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? Apparently you had some stuff in the database

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

2005-02-08 Thread 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 chang

[pgadmin-support] backup-restore does not work

2005-02-08 Thread Art Fore
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 refres