From: | Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> |
---|---|
To: | Pascal Tufenkji <ptufenkji(at)usj(dot)edu(dot)lb>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: permission denied |
Date: | 2013-10-31 14:09:54 |
Message-ID: | 527264B2.3060205@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 10/31/2013 12:53 AM, Pascal Tufenkji wrote:
> Hello,
>
> 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.
>
> 3 views had been corrupted the past week.
>
> Until now, all the errors are on our SIT and UAT servers. I am afraid
> that soon we will be facing those same problems on our production database.
>
> We are using PostgreSQL 8.2.11 on Red Hat
I might as well be the first to say it, version 8.2 is no longer supported.
>
> What seems to be the problem ?
Hard to say.
>
> Can anyone help please ?
What is the exact error message returned?
How are the views being defined?
Are the tables under the views being changed?
>
> *Pascal TUFENKJI
> *Service de Technologie de l'Information
> Université Saint-Joseph - Rectorat
> Tel: +961 1 421 132
> Email: ptufenkji(at)usj(dot)edu(dot)lb <mailto:ptufenkji(at)usj(dot)edu(dot)lb>
>
--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2013-10-31 14:16:38 | Re: permission denied |
Previous Message | Raphael Bauduin | 2013-10-31 13:21:03 | Re: problem with partitioned table and indexed json field |