Re: can select contents of view but not view itself, despite indirect membership

Поиск
Список
Период
Сортировка
От Kevin Field
Тема Re: can select contents of view but not view itself, despite indirect membership
Дата
Msg-id a3804278-3c25-4401-97ba-1525a7fe4b71@d8g2000yqf.googlegroups.com
обсуждение исходный текст
Ответ на can select contents of view but not view itself, despite indirect membership  (Kevin Field <kevinjamesfield@gmail.com>)
Список pgsql-general
> My guess is that it has something to do with the join to the table
> 'mandate'.  If your view definition includes a CASE WHEN... that would

My new guess is something to do with permissions being cached
somewhere, because this morning when I tried it (SET followed by
SELECT from page_startup) from pgAdminIII, it worked.  I had shut down
pgAdminIII before leaving last night.  Gah!

Oh well, at least it's working now.  I guess I should remember to
always try restarting everything...

Kev


В списке pgsql-general по дате отправления:

Предыдущее
От: zhong ming wu
Дата:
Сообщение: Feature request for this mail list
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Feature request for this mail list