PostgreSQL schema

I've tried using this patch. During checkout, when I click "Continue to payment details" I get an empty shopping cart and the following messages:

warning: pg_query(): Query failed: ERROR: relation "ec_store_transaction_txnid_seq" does not exist in /usr/share/drupal/includes/database.pgsql.inc on line 104.

user error:
query: SELECT nextval('ec_store_transaction_txnid_seq') in /usr/share/drupal/includes/database.pgsql.inc on line 121.

warning: pg_query(): Query failed: ERROR: invalid input syntax for type numeric: "" in /usr/share/drupal/includes/database.pgsql.inc on line 104.

user error:
query: INSERT INTO ec_store_transaction (shipping_cost, gross, payment_method, uid, mail, changed, shipping_firstname, shipping_lastname, shipping_street1, shipping_street2, shipping_city, shipping_state, shipping_zip, shipping_country, billing_firstname, billing_lastname, billing_street1, billing_street2, billing_city, billing_state, billing_zip, billing_country, created, payment_status, workflow, txnid) VALUES ('', '1', 'cod', '1', 'darren@wans.net', '1125374400', 'Darren', 'Oh', '911 Dove Ridge Drive', '', 'Lakeland', 'Florida', '33803-3707', '223', 'Darren', 'Oh', '911 Dove Ridge Drive', '', 'Lakeland', 'Florida', '33803-3707', '223', '1125428503', '1', '1', '') in /usr/share/drupal/includes/database.pgsql.inc on line 121.

warning: Cannot modify header information - headers already sent by (output started at /usr/share/drupal/includes/common.inc:344) in /usr/share/drupal/modules/ecommerce/contrib/cod/cod.module on line 88.

Try this schema instead, it has the ability to autoincrement.

Note, you may need to use the DB module and put this in the query field, if you don't have access to phppgadmin. Furthermore you may need to edit the droptables component, or manually drop the tables an remove the drop component from this to make it function properly.

--
-- PostgreSQL database dump
--

SET client_encoding = 'SQL_ASCII';
SET check_function_bodies = false;
SET client_min_messages = warning;

SET search_path = public, pg_catalog;

ALTER TABLE ONLY public.ec_transaction DROP CONSTRAINT ec_transaction_pk;
DROP TABLE public.ec_transaction;
SET default_tablespace = '';

SET default_with_oids = true;

--
-- Name: ec_transaction; Type: TABLE; Schema: public; Owner: biocoinadmin; Tablespace:
--

CREATE TABLE ec_transaction (
txnid bigserial NOT NULL,
uid integer DEFAULT 0 NOT NULL,
mail character varying(64) DEFAULT ''::character varying NOT NULL,
shipping_firstname character varying(32) DEFAULT ''::character varying NOT NULL,
shipping_lastname character varying(32) DEFAULT ''::character varying NOT NULL,
shipping_street1 character varying(64) DEFAULT ''::character varying NOT NULL,
shipping_street2 character varying(64) DEFAULT ''::character varying NOT NULL,
shipping_zip character varying(11) DEFAULT ''::character varying NOT NULL,
shipping_city character varying(32) DEFAULT ''::character varying NOT NULL,
shipping_state character varying(32) DEFAULT ''::character varying NOT NULL,
shipping_cost numeric(11,2) DEFAULT 0.00 NOT NULL,
shipping_country character varying(2) DEFAULT ''::character varying NOT NULL,
billing_firstname character varying(32) DEFAULT ''::character varying NOT NULL,
billing_lastname character varying(32) DEFAULT ''::character varying NOT NULL,
billing_street1 character varying(64) DEFAULT ''::character varying NOT NULL,
billing_street2 character varying(64) DEFAULT ''::character varying NOT NULL,
billing_zip character varying(11) DEFAULT ''::character varying NOT NULL,
billing_city character varying(32) DEFAULT ''::character varying NOT NULL,
billing_state character varying(32) DEFAULT ''::character varying NOT NULL,
billing_country character varying(2) DEFAULT ''::character varying NOT NULL,
payment_method character varying(32) DEFAULT ''::character varying NOT NULL,
payment_status character varying(32) DEFAULT '1'::character varying NOT NULL,
coupon integer DEFAULT 0 NOT NULL,
workflow integer DEFAULT 1 NOT NULL,
gross numeric(11,2) DEFAULT 0.00 NOT NULL,
expires integer DEFAULT 0,
created integer DEFAULT 0 NOT NULL,
changed integer DEFAULT 0 NOT NULL,
CONSTRAINT ec_transaction_coupon_check CHECK ((coupon >= 0)),
CONSTRAINT ec_transaction_txnid_check CHECK ((txnid >= 0)),
CONSTRAINT ec_transaction_uid_check CHECK ((uid >= 0)),
CONSTRAINT ec_transaction_workflow_check CHECK ((workflow >= 0)),
CONSTRAINT ec_transaction_pk PRIMARY KEY (txnid)
);

--
-- PostgreSQL database dump complete
--

Let me know if you have any more problems, I have the ecommerce module 99% functional in PHP5 and PostGres 8.0, but it has taken quite a bit of work.

Work on the E-Commerce project (and PostgreSQL support) has moved on to other versions. This issue will probably not be given much further attention.