Re: [ADMIN] Questions on setup and usage

2009-07-06 Thread Michael Gould
I know that by using lowercase object names that I can work with those object in a case insensitive way, however is there a way through maybe a locale or character set to make the data and the indexes case insensitive such that you don't need to use ILIKE? Best Regards Michael Gould "Kevin Gri

Re: [ADMIN] Questions on setup and usage

2009-07-06 Thread Kevin Grittner
Please keep the list copied. Also, it's best to quote the minimum required for context, and to avoid top-posting. (It's much easier for most people to read this way.) Michael Gould wrote: > "Kevin Grittner" wrote: >>> 3. We use active directory to validate a user's login. We have >>> "rul

Re: [ADMIN] Questions on setup and usage

2009-07-06 Thread Kevin Grittner
Michael Gould wrote: > 1. The ability to encrypt stored procedures and triggers. I know > that PostGres doesn't have this feature but is there a way to > protect stored procedure and trigger source yet allow it to be > executed by any user and how would it be done. You could code them in a

[ADMIN] Questions on setup and usage

2009-07-02 Thread Michael Gould
We have a commerical application which we currently are running under a different database but would like to consider a enterprise version using PostGres.  There are several features in this other database that have become important to us. 1.  The ability to encrypt stored procedures and triggers