Hi
In advance, my apologizes if I'm not addressing to the right place this comment of mine, I'm quite new on Drupal world and , therefore, on E-commerce.
Just Today evening I installed Drupal, and E-Commerce , with PostgreSQL instead MySQL.
After Installed the E-Commerce Module I started to get errors in the Log
query: INSERT INTO ec_tax (realm_value, realm, ptype, operand, operator, taxid) VALUES('fr', 'country', 'file', '+', '6.00', '')
Reviewing the postgresql logs I see that
ERROR: relation "ec_tax_taxid_seq" does not exist
So I searched in the file tax.install
tax.install,v 1.3 2006/05/09 12:23:37...
For postgresql the create database is for ec_tax contains..
taxid integer NOT NULL default '0',
Where I believe this is wrong
If you set taxid as intenger, then, nothing creates the sequence ec_taxid_seq
This lines imho should be
taxid serial,
(If taxid is the primary key makes not sense to say NOT NULL, and makes no sense default '0' if it's serial type)
I recreated manually the table in postgres, and now the taxes works with my postgresql.
BTW: I first was navigating trough the known bugs and googled if this was known because this should impact any postgresql user.... but I didn't found much postgresql activity on e-commerce
Comments
better the queue methinks
Hey there.
Best thing is to post this in the ecommerce issues queue.
http://drupal.org/project/issues/ecommerce