Re: Tab completion for view triggers in psql

Поиск
Список
Период
Сортировка
От David Fetter
Тема Re: Tab completion for view triggers in psql
Дата
Msg-id 20101121180754.GC7424@fetter.org
обсуждение исходный текст
Ответ на Re: Tab completion for view triggers in psql  (David Fetter <david@fetter.org>)
Ответы Re: Tab completion for view triggers in psql  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
On Fri, Oct 29, 2010 at 08:33:00AM -0700, David Fetter wrote:
> On Tue, Oct 26, 2010 at 11:55:07AM +0900, Itagaki Takahiro wrote:
> > On Tue, Oct 26, 2010 at 11:34 AM, David Fetter <david@fetter.org> wrote:
> > >> Do we need to 'add' it?
> > > Possibly.  My understanding is that it couldn't really replace it.
> > 
> > Ah, I see.  I was wrong.  We can have modification privileges for
> > views even if they have no INSTEAD OF triggers.
> 
> Right.
> 
> > So, I think your original patch is the best solution.  We could use
> > has_table_privilege() additionally, but we need to consider any
> > other places if we use it.  For example, DROP privileges, etc.
> 
> That seems like a matter for a separate patch.  Looking this over, I
> found I'd created a query that can never get used, so please find
> enclosed the next version of the patch :)

Could someone please commit this? :)

Cheers,
David.
-- 
David Fetter <david@fetter.org> http://fetter.org/
Phone: +1 415 235 3778  AIM: dfetter666  Yahoo!: dfetter
Skype: davidfetter      XMPP: david.fetter@gmail.com
iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate


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

Предыдущее
От: David Fetter
Дата:
Сообщение: Re: ALTER OBJECT any_name SET SCHEMA name
Следующее
От: Andrew Dunstan
Дата:
Сообщение: Re: patch: Add JSON datatype to PostgreSQL (GSoC, WIP)