E-Commerce and PostgreSQL

We encourage users to post events happening in the community to the community events group on https://www.drupal.org.
c_lombao@yahoo.com's picture

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

sime's picture

Hey there.

Best thing is to post this in the ecommerce issues queue.
http://drupal.org/project/issues/ecommerce

e-Commerce Module

Group organizers

Group notifications

This group offers an RSS feed. Or subscribe to these personalized, sitewide feeds: