Re: Should SET ROLE inherit config params?

From: Simon Riggs <simon(at)2ndQuadrant(dot)com>
To: Josh Berkus <josh(at)agliodbs(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Greg Stark <stark(at)enterprisedb(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Should SET ROLE inherit config params?
Date: 2009-03-12 19:12:01
Message-ID: 1236885121.28644.241.camel@ebony.2ndQuadrant
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


On Thu, 2009-03-12 at 08:26 -0700, Josh Berkus wrote:
> Tom,
>
> > Discuss the implications of changing such a GUC partway
> > through this sequence. For extra credit, explain what would happen if
> > it were set via ALTER ROLE SET for one role or the other.
> >
> > In short: -1 from me.
>
> Heh. That's your best rejection yet. Someday I'll print out all the
> rejection e-mails from you and wallpaper my office. ;-)

Josh, this isn't a rejection. Both Tom and I asked for more exploration
of the implications of doing as you suggest. Tom has been more helpful
than I was in providing some scenarios that would cause problems. It is
up to you to solve the problems, which is often possible.

I can't vouch for your taste in wallpaper, but this doesn't deserve a
place in your collection...

--
Simon Riggs www.2ndQuadrant.com
PostgreSQL Training, Services and Support

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Morgan 2009-03-12 19:28:16 Access to last date and time role was used to connect
Previous Message Josh Berkus 2009-03-12 15:28:58 Re: View running statements