From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
---|---|
To: | Alexi Gen <sqlcatz(at)hotmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: pg_tablespace.spcacl |
Date: | 2007-02-17 14:26:34 |
Message-ID: | 20070217142634.GL9724@alvh.no-ip.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Alexi Gen wrote:
> Hello,
>
> pg_tablespace contains information about all the tablespaces available on
> the system.
> The [spcacl] column for a particular record - contains a string value of
> the names of users that have permissions on the tablespace.
> I'm looking for any info as to why this approach was taken?
> Can someone point me to a page / document?
Because it's the same approach used everywhere else? The underlying
reason is that it's more efficient than using a normalized approach.
Of course, internally they aren't strings, but arrays of ACL items,
which are in turn tuples of
(grantor ID, grantee ID, with_grant_option, privileges), stored as
three 32-bit ints. They are converted in string format only for
display, just like everything else.
Does that answer your question? If it doesn't, please be more specific.
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
From | Date | Subject | |
---|---|---|---|
Next Message | Mikko Partio | 2007-02-17 15:13:49 | Re: Cast record as text SOLVED |
Previous Message | Karsten Hilbert | 2007-02-17 14:15:25 | Re: [ANNOUNCE] Advisory on possibly insecure security definer functions |