Re: advisory locks and permissions - Mailing list pgsql-hackers

From Stephen Frost
Subject Re: advisory locks and permissions
Date
Msg-id 20060921150159.GF24675@kenobi.snowman.net
Whole thread Raw
In response to Re: advisory locks and permissions  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: advisory locks and permissions  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
* Tom Lane (tgl@sss.pgh.pa.us) wrote:
> An admin who is concerned about this can revoke public access on the
> functions for himself ... but should that be the default out-of-the-box
> configuration?  I feel more comfortable with saying "you have to turn
> on this potentially-dangerous feature" than with saying you have to turn
> it off.

I agree with having it turned off by default, at least in 8.2.  Once
it's out there and in use we can review that decision for 8.3 and
possibly implement appropriate safeguards based on the usage.

> Another reason for restricting access to the advisory-lock functions
> is that an uninformed application might take the wrong locks, and
> bollix up your intended usage accidentally.

This begs for a mechanism to define who can take what locks, etc..
Which seems to be an 8.3 issue.
Thanks,
    Stephen

pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: 'configure --disable-shared' and 'make check'
Next
From: Bruce Momjian
Date:
Subject: Re: Release Notes: Major Changes in 8.2