Skip site navigation (1) Skip section navigation (2)

bugs

From: Srinivasa R Chava <s(dot)chava(at)wcom(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: bugs
Date: 2002-02-14 15:19:18
Message-ID: 3C6BD576.F98178BF@wcom.com (view raw or flat)
Thread:
Lists: pgsql-bugs
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(dot)chava(at)wcom(dot)com>
 - Boss: Sean T Laduderdale <sean(dot)lauderdale(at)wcom(dot)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

Responses

  • Re: bugs at 2002-02-19 20:22:40 from Tom Lane

pgsql-bugs by date

Next:From: Ruud van den BrinkDate: 2002-02-15 11:45:41
Subject: Bug in Postrgresql 7.2 migrating from 7.1.3
Previous:From: pgsql-bugsDate: 2002-02-13 22:10:45
Subject: Bug #588: Postgresql will not build on AIX; cannot locate tcl library

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group