Skip site navigation (1) Skip section navigation (2)

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

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Russell Smith <mr-russ(at)pws(dot)com(dot)au>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Jeff Davis <pgsql(at)j-davis(dot)com>, pgsql-bugs(at)postgresql(dot)org, Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Removing pg_auth_members.grantor (was Grantor name gets lost when grantor role dropped)
Date: 2007-05-14 23:18:34
Message-ID: 20070514231834.GE8916@alvh.no-ip.org (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-hackers
Alvaro Herrera wrote:

> 2. decide that the standard is braindead and just omit dumping the
>    grantor when it's no longer available, but don't remove
>    pg_auth_members.grantor
> 
> Which do people feel should be implemented?  I can do whatever we
> decide; if no one has a strong opinion on the matter, my opinion is we
> do (2) which is the easiest.

Here is a patch implementing this idea, vaguely based on Russell's.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

Attachment: pgdumpall-grantor-dropped.patch
Description: text/x-diff (2.1 KB)

In response to

Responses

pgsql-hackers by date

Next:From: Andrew DunstanDate: 2007-05-15 00:21:00
Subject: Re: What is happening on buildfarm member baiji?
Previous:From: Richard HuxtonDate: 2007-05-14 21:26:58
Subject: Re: Concurrently updating an updatable view

pgsql-bugs by date

Next:From: Tom LaneDate: 2007-05-15 00:17:28
Subject: Re: postgresql locks up over the net
Previous:From: Peter T. BreuerDate: 2007-05-14 22:31:00
Subject: postgresql locks up over the net

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group