2012/12/25 Pavel Stehule <pavel.steh...@gmail.com>: > Hello > > 2012/12/25 Pavel Golub <pa...@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?
one idea regrole - defined only for "real" roles - support InvalidOid - doesn't support "public" regaclrole - defined for any roles, that can be used for ACL (with "public"), doesn't support InvalidOid Regards Pavel > > Regards > > Pavel > >> >> PS> Regards >> >> PS> Pavel >> >> >> >> >> >> -- >> With best wishes, >> Pavel mailto:pa...@gf.microolap.com >> -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers