"Pascal Tufenkji" <ptufenkji@xxxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
