From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | "Pascal Tufenkji" <ptufenkji(at)usj(dot)edu(dot)lb> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: permission denied |
Date: | 2013-10-31 14:16:38 |
Message-ID: | 22573.1383228998@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
"Pascal Tufenkji" <ptufenkji(at)usj(dot)edu(dot)lb> writes:
> I am facing a weird permission problem with the views in our database.
> While the system is up and running, suddenly a certain view gets corrupted.
> When we try to query it, it returns permission denied. Although the
> permission has not been changed and if I check them using \z the system
> displays that all the permissions are still on. The only solution is to drop
> the view and create it back again.
That's pretty odd, but ...
> We are using PostgreSQL 8.2.11 on Red Hat
... you're not going to get a lot of interest in supporting a release series
that's been EOL for nearly two years, especially when you're a dozen minor
releases behind even in that series (the last 8.2 release was 8.2.23).
You are *way* overdue for an update.
If you can still reproduce this problem in a currently-supported release,
we'll definitely take an interest.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2013-10-31 14:23:44 | Re: problem with partitioned table and indexed json field |
Previous Message | Adrian Klaver | 2013-10-31 14:09:54 | Re: permission denied |