RE: PostgreSQL compatibility fixes

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

[quote="Cryp2Nite"]
We can leave the whole PEAR::DB database abstraction layer out of the combined code if you don't want it in. All of these changes are contained in includes/functions/database.php (and some config settings in incldes/configure.php) so it's easy to leave this out of it.

Cheers,
Rob[/quote]

huh
actually that was a spelling mistake, sorry :(
i meant thtat there's no point in maintaining a different branch since porting is so easy

my 'changes' is just a few sql fixes and a few hacks which i made in half a day so as i said that's not a big deal

as a matter of fact osc has kind of abstract db layer
but it doeasn't make much difference if the queries are uncorrect
if one uses subqueries (ansi sql) then it will not work on mysql

having said that
i am willing to cooperate as far as making osc more db independent
i can fix and test against pgsql

You can contact me at pokryfka:at:artland.com.pl

all changes i made are commented with '///' so ou can easily find them if You want

some fixes need cleanups
there are also a few more changes worth making (like not inserting '0' inseted of NULL to foreign keyfields)