RE: PostgreSQL compatibility fixes

This message was sent from: Development
http://forums.oscommerce.com/viewtopic.php?p=219324#219324
----------------------------------------------------------------

I have a to-be-finished PEAR::DB version here.
The catalog is almost completely posted, it's just the administration that I haven't done so far.

I guess if  pyrofka's query fixes are combined with the version I have here, you'd have a version that would work with both MySQL as Postgresql.

I probably won't have the time to look at this this week, but if there's interest in combining the two I'd be happy to hand my code to anyone who's interested in making it happen. Or I cuold take a stab at it next week.
It shouldn't be much work, if I remember correctly changing database.php and a change to configure.php is all that it would take.

Let me know if anyone is interested.

Cheers,
Rob


PS: If you are using pgsql, I found out that adding some extra indexes to the database can speed queries up considerably.