If I understand this correctly, I think you want to implement the sort
of security that Veil provides. Take a look at
http://pgfoundry.org/projects/veil/
The documentation is at
http://veil.projects.postgresql.org/curdocs/index.html
__
Marc
On Sun, 2006-01-01 at 17:02 -0400, littlebutty wrote:
On Thu, Dec 22, 2005 at 05:04:30PM -0800, littlebutty wrote:
> HERE IS WHAT I WANT TO DO:
> How do I setup a postgres constraint that will not allow an insert on
> the permission table with an integer value that has more than one bit
> set. In other words you could insert 1, 2, 4, 8, 16, 32, etc.
Does anyone know how I can solve this problem in Postgres:
I am creating a table of user permissions. I want to represent each
permission as a bit location. Each new permission I add to my system
would be assigned to the next available bit (or column if you will)
That way I can simply turn on a
