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) <s.chava@wcom.com>
- Boss: Sean T Laduderdale <sean.lauderdale@wcom.com>
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