Re: [SQL] Implementing ACLs in Pure SQL?

2008-08-29 Thread Michael B Allen
On Fri, Aug 29, 2008 at 6:57 PM, ries van Twisk <[EMAIL PROTECTED]> wrote: > > Then in plpgsql I resolve the correct ACL for a user. I didn't think procedures would help me much in this case but I would be interested in hearing how they would. Another way to do it would be to have a table for sto

Re: [SQL] Implementing ACLs in Pure SQL?

2008-08-29 Thread ries van Twisk
On Aug 29, 2008, at 5:33 PM, Michael B Allen wrote: Hello, I've been tinkering with SQL level access control for web applications. Currently I have a UNIX style uid / gid for each record and do a WHERE e.uid IN (10,20,30) where 10, 20 and 30 would be the IDs of groups the user is in. Howev

[SQL] Implementing ACLs in Pure SQL?

2008-08-29 Thread Michael B Allen
Hello, I've been tinkering with SQL level access control for web applications. Currently I have a UNIX style uid / gid for each record and do a WHERE e.uid IN (10,20,30) where 10, 20 and 30 would be the IDs of groups the user is in. However, I'm not satisfied with this model as it has all of the

[SQL] pg_dump and "could not identify an ordering operator for type name"

2008-08-29 Thread Gerardo Herzig
Hi dudes. Im facing a problem with pg_dump, pg_dump: SQL command failed pg_dump: Error message from server: ERROR: could not identify an ordering operator for type name HINT: Use an explicit ordering operator or modify the query. pg_dump: The command was: SELECT t.tableoid, t.oid, t.relname as i