Re: Fw: [JDBC] Regarding vacuumdb

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