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
recovery is failing
Archiver(db): Could not execute query. Code = 7. Explanation from
backend: 'ERROR: mysequence.setval: you don't have permissions
Why it is giving the error that the perssion is not there.
'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.
Srinivasa R Chava (Chava) <s(dot)chava(at)wcom(dot)com>
- Boss: Sean T Laduderdale <sean(dot)lauderdale(at)wcom(dot)com>
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
- Re: bugs at 2002-02-19 20:22:40 from Tom Lane
pgsql-bugs by date
|Next:||From: Ruud van den Brink||Date: 2002-02-15 11:45:41|
|Subject: Bug in Postrgresql 7.2 migrating from 7.1.3|
|Previous:||From: pgsql-bugs||Date: 2002-02-13 22:10:45|
|Subject: Bug #588: Postgresql will not build on AIX; cannot locate tcl library|