Re: Role incompatibilities

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Stephen Frost <sfrost(at)snowman(dot)net>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Role incompatibilities
Date: 2006-04-10 19:41:59
Message-ID: 200604101941.k3AJfxn16861@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


Is there a TODO here?

---------------------------------------------------------------------------

Peter Eisentraut wrote:
> Am Samstag, 25. M?rz 2006 16:10 schrieb Tom Lane:
> > No, the current implementation is a compromise between exact standards
> > compatibility and backwards compatibility with our historical "groups"
> > behavior. I'm not really prepared to toss the latter overboard.
>
> My two major sticking points here are the SET ROLE command and the noinherit
> feature. The SET ROLE command is not required by our historical group
> behavior (because we didn't have it before) and does not do what the SQL
> standard says it should do. The noinherit feature is not required by the
> historical group behavior (because groups are yes-inherit) and is not in the
> SQL standard either. So these two features were just mistakes as far as I
> can tell.
>
> I'm not passing judgement on whether a command like the currently implemented
> SET ROLE command or a feature like the currently implemented noinherit
> feature is useful. They are just not in line with either the historical
> group behavior or the SQL standard.
>
> --
> Peter Eisentraut
> http://developer.postgresql.org/~petere/
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>

--
Bruce Momjian http://candle.pha.pa.us
EnterpriseDB http://www.enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2006-04-10 20:25:22 Re: Domains as Subtypes
Previous Message Luke Lonergan 2006-04-10 19:09:26 Re: Support Parallel Query Execution in Executor