Re: proposal: regrole type?
Pavel Stehule <pavel.stehule@gmail.com>
From: Pavel Stehule <pavel.stehule@gmail.com>
To: Pavel Golub <pavel@gf.microolap.com>
Cc: PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Date: 2012-12-25T18:24:01Z
Lists: pgsql-hackers
Hello 2012/12/25 Pavel Golub <pavel@microolap.com>: > Hello, Pavel. > > You wrote: > > PS> Hello > > PS> Can we implement REGROLE type, that simplify role name <-> oid transformations? > > +1 from me. My old wish. I started implementation. I found a two points, that should be solved before. we operate over roles with (without) fictive role "public". So we need two datatypes :( I have no idea about second name :( - there should be difference if type enables or disallow "public". second issue is value of ACL_ID_PUBLIC, that is zero - and there is not difference from InvalidOid - what should be acceptable via "-" symbol. Any ideas? Regards Pavel > > PS> Regards > > PS> Pavel > > > > > > -- > With best wishes, > Pavel mailto:pavel@gf.microolap.com >