Re: pg_class changes for group ownership - Mailing list pgsql-hackers

From Tom Lane
Subject Re: pg_class changes for group ownership
Date
Msg-id 11483.1104343162@sss.pgh.pa.us
Whole thread Raw
In response to pg_class changes for group ownership  (Stephen Frost <sfrost@snowman.net>)
Responses Re: pg_class changes for group ownership
List pgsql-hackers
Stephen Frost <sfrost@snowman.net> writes:
>   Due to the fact that group system id's and user system id's can
>   overlap, pg_class will need to change in order to accomedate group
>   ownership.  The things I've thought of so far, in order of preference:

I thought that the agreed-on direction for this was to merge users and
groups into a single kind of entity, or at least make sure that they
share a common unique identifier space.  Then AclId is still sufficient
as an ownership indicator, and you don't need any of these kluges.
IIRC something of this sort is needed for improved compliance with the
SQL spec anyway --- see past discussions about "roles".
        regards, tom lane


pgsql-hackers by date:

Previous
From: Rémi Zara
Date:
Subject: Re: buildfarm NetBSD/m68k tsearch regression failure
Next
From: Stephen Frost
Date:
Subject: Re: pg_class changes for group ownership