Hai, I'm using postgresql 7.2 There is a bug in pg_restore. It is not restoring the sequences properly. and it is failing with views created by pgadmin tool.
It is restoring , but giving the following error with sequences and recovery is failing Archiver(db): Could not execute query. Code = 7. Explanation from backend: 'ERROR: mysequence.setval: you don't have permissions to set sequence mysequence Why it is giving the error that the perssion is not there. Actually, I 'm restoring from pgsql super user account. same thing is happening with views created by pgadmin tool. If I drop those views and tables created by pgadmin tool, it is restoring . Or else it is failing half way. Thanks chava -- Srinivasa R Chava (Chava) <[EMAIL PROTECTED]> - Boss: Sean T Laduderdale <[EMAIL PROTECTED]> vnet4603575 Application Developer Corporate Intra/Internet Systems WORLDCOM - http://www.worldcom.com/ - NASDAQ:WCOM 500 Clinton Center Drive (Corporate Headquarters) Clinton, Mississippi (MS) USA 39056 (601)460-3122 / vnet4603122 / (800)844-1009 / FAX(601)460-8257 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
