Re: table permissions

I am using v7.1.2
I guess, this might be a table locking problem, but I don't have any transactions currently running.

A couple of days ago I did a restore of 'set' table from a dump file, and it didn't go too well - I
had a couple of problems. I don't know if it's relevant, but smth's telling me that it is.

Oleg

Aasmund Midttun Godal wrote:

> I used to have this problem in earlier  versions of postgres, after I upgraded they disappeared.
>
> Regards,
>
> Aasmund.
> On Mon, 29 Oct 2001 16:23:28 -0700, Oleg Lebedev <olebedev@waterford.org> wrote:
> > Hi everybody,
> > I have a table called 'set' and I am trying to edit or insert an entry
> > there. I made sure that I have ALL permissions to modify that table, but
> > still I get the same error:
> > ERROR: activity: Permission denied.
> >
> > I don't know where 'activity' part came from, but there is a reference
> > to activity table in set table.
> > I know this is a very vague descritption of the symptoms, but I don't
> > know where to look to find out more info. I'll happily provide any
> > further details.
> > thanks,
> >
> > Oleg
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 2: you can get off all lists at once with the unregister command
> >     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>
> Aasmund Midttun Godal
>
> aasmund@godal.com - http://www.godal.com/
> +47 40 45 20 46