Hi Kim
>> robust db but it doesn't have built-in text indexing > Try the serial type. •••• As far as I'm aware, the only full text indexing available for pg is tsearch2 (which hasn't been updated since 2003). To install tsearch requires the user to compile from source which is not a real friendly way to distribute an application. I really wanted to get it going and it took me a long time - I can't realistically expect an end user looking for a demo to go through that pain.
I misread, sorry. I read 'autoIndexing' for the primary key, which is covered by the serial type.
I've never had any hassles with 'where upper(fieldName) like '%FIND%' with pg I give NySQL credit where
due, they make very nice installers.
.. I've had hassles with the ODBC installer. the version that 'works' ends with .9 vs the latest version that ends with .12 (against a 4.1 mysql db)
I think if there was a complete installer for pg with tsearch2 included I'd still be using pg. For those who don't need full text indexing, pg is probably a fair choice.
> Try pgAdmin III •••• That's what I do use but I don't think it's anywhere near as nice as the MySQL AB administrator/browser applications or the many shareware/ freeware alternatives for MySQL (CocoaMySQL, YourSQL Navicat etc)
Still, it works fine. Cheers -- Keith Hutchison http://balance-infosystems.com http://realopen.org http://www.kasamba.com/Keith-Hutchison _______________________________________________ Unsubscribe or switch delivery mode: <http://www.realsoftware.com/support/listmanager/> Search the archives of this list here: <http://support.realsoftware.com/listarchives/lists.html>
