Re: [SQL] Postgres roles

2008-02-09 Thread Shane Ambler
Pascal Tufenkji wrote: Hi Shane, You are exactly right. My issue is that, I now have one role called sti - that has carried the group members from the old version - So what do you think my options are, so I can separate them? I have only one option in my mind: - Revoke the me

Re: [SQL] What are the (various) best practices/opinions for table/column/constraint naming?

2008-02-09 Thread Karsten Hilbert
Speaking on behalf of the GNUmed schema. The type of thing comes first for consistency. primary key: pk Some might argue pk_ is preferrable such that in joins one ist not forced to use column aliases. We do in such cases. The "... where table.pk = ..." just seems soo intuitive. for