[GENERAL] Windows re-installation problem

2006-01-17 Thread Rob Brenart
I uninstalled PostgreSQL from windows for the sake of re-installing (for the sake of documenting an install for our product on a clean machine), and now during re-install on the Service Configuration screen I get "Invalid username specified: Logon failure: unknown user name or bad password."

Re: [GENERAL] Slow first query

2005-07-19 Thread Rob Brenart
Richard Huxton wrote: Rob Brenart wrote: I'm running postgresql 8.0 under WindowsXP for a development box (the production server isn't up yet, and will be linux, so I don't know that the problem will travel)... Using a PHP connection to it for a simple web app, if I leave

[GENERAL] Slow first query

2005-07-19 Thread Rob Brenart
I'm running postgresql 8.0 under WindowsXP for a development box (the production server isn't up yet, and will be linux, so I don't know that the problem will travel)... Using a PHP connection to it for a simple web app, if I leave the app alone for a bit (about 20 seconds I'd say) and do some

Re: [GENERAL] Looking for a good ERD Tool

2005-07-14 Thread Rob Brenart
I was afraid of that, it's such a useless duplication of effort, but what can you do... what's EMS Manager though, I'm just using phpPgAdmin EMS is a more polished version phpPgAdmin has a lot more features I dunno if I'd define the same way you have, one of the great things about phpPgAd

Re: [GENERAL] Case insensitive unique constraint

2005-07-14 Thread Rob Brenart
Klint Gore wrote: On Thu, 14 Jul 2005 02:14:16 -0500, Rob Brenart <[EMAIL PROTECTED]> wrote: I have a simple table to store account names... I want each name to be unique in a case insensitive manner... but I want the case the user enters to be remembered so I can't do a simple

[GENERAL] Case insensitive unique constraint

2005-07-14 Thread Rob Brenart
I have a simple table to store account names... I want each name to be unique in a case insensitive manner... but I want the case the user enters to be remembered so I can't do a simple lower() on the data's way in. Is there an easy way to go about this? Am I about to write my first server sid

[GENERAL] Looking for a good ERD Tool

2005-07-06 Thread Rob Brenart
I'm looking for a good ERD tool that's designed to work with PostgreSQL... currently I use the one found here http://www.fabforce.net/dbdesigner4/index.php for MySQL, and I just create the actual tables and such by hand... kinda of a kludge, and I lose all the reverse engineering benefits... bu