Re: [COMMITTERS] pgsql: Fix two bugs in change_owner_recurse_to_sequences: - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject Re: [COMMITTERS] pgsql: Fix two bugs in change_owner_recurse_to_sequences:
Date
Msg-id 42450175.4070606@familyhealth.com.au
Whole thread Raw
Responses Re: [COMMITTERS] pgsql: Fix two bugs in change_owner_recurse_to_sequences: it was
List pgsql-hackers
> Fix two bugs in change_owner_recurse_to_sequences: it was grabbing an
> overly strong lock on pg_depend, and it wasn't closing the rel when done.
> The latter bug was masked by the ResourceOwner code, which is something
> that should be changed.

I assume that this behaviour makes change owner on a table change owner 
of serial sequences?

Should we perhaps also propagate grant insert on a table to grant 
select, update on dependent serial sequences?

Chris


pgsql-hackers by date:

Previous
From: "Marc G. Fournier"
Date:
Subject: 8.0.2beta1 ... look her over ...
Next
From: Tom Lane
Date:
Subject: Re: [COMMITTERS] pgsql: Fix two bugs in change_owner_recurse_to_sequences: it was