Removing pg_auth_members.grantor (was Grantor name gets lost when grantor role dropped)

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Removing pg_auth_members.grantor (was Grantor name gets lost when grantor role dropped)
Дата
Msg-id 20070504185727.GA20938@alvh.no-ip.org
обсуждение исходный текст
Ответы Re: Removing pg_auth_members.grantor (was Grantor name gets lost when grantor role dropped)  (Stephen Frost <sfrost@snowman.net>)
Список pgsql-hackers
Tom Lane wrote:
> Alvaro Herrera <alvherre@commandprompt.com> writes:

> >> Why is it that we record grantor at all?  One could argue that granting
> >> membership in a role is done on behalf of that role and there's no real
> >> need to remember exactly who did it.
> 
> > I think you should ask Stephen Frost about that -- added to CC.
> 
> > If the grantor bit is not important, then what we should do is just omit
> > emitting the GRANTED BY part in pg_dumpall, which fixes this report.
> 
> It's at least something we should reflect on before sweating hard to
> make it work...

I took a look, and concluded that the only bit of code that uses the
grantor at all is pg_dumpall.

Does this means we can remove it altogether?  In back branches, we would
take out the pg_dumpall code.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support


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

Предыдущее
От: Stefan Kaltenbrunner
Дата:
Сообщение: Re: [COMMITTERS] pgsql: Teach tuplesort.c about "top N" sorting, in which only the first
Следующее
От: jaba the mobzy
Дата:
Сообщение: Re: Bitmap Heap Scan anomaly