Shanmugasundaram Doraisamy wrote:
> ----- Original Message -----
> From: Peter Eisentraut <peter_e@gmx.net>
> To: Shanmugasundaram <shan@ceedees.com>
> Cc: <pgsql-general@postgresql.org>
> Sent: Wednesday, August 29, 2001 5:11 PM
> Subject: Re: [JDBC] Regarding vacuumdb
>
> > Shanmugasundaram writes:
> >
> > > I am getting the following error while doing vacuumdb,
> > >
> > > ERROR: mdopen: couldn't open test1: No such file or directory
> > > vacuumdb: database vacuum failed on db1.
> > >
> > > Here 'db1' is the database and 'test1' is a table. When, displaying the
> > > structure of the
> > > table 'test1', it comes correctly. But I can't drop the table. What
> > > could be wrong?
> >
> > You probably rolled back a DROP TABLE operation, so the underlying table
> > file on disk is gone but the catalog structures have been preserved.
> > You could probably try
> >
> > touch $PGDATA/base/db1/test1
> >
> > and then drop the table.
> >
> > Consider upgrading to the latest stable release (7.1.3) when you get a
> > chance to eliminate this class of problems.
> >
> > --
> > Peter Eisentraut peter_e@gmx.net http://funkturm.homeip.net/~peter
> >
I tried with the command you gave. But, if I try to delete the table 'test1'
it comes with the following error:
ERROR: mdopen: couldn't open test1: Permission denied
How to solve it?Any help.
shan
