Postgresql definitions

The following has been tested in postgresql 7.4 and 8.0

CREATE TABLE taxonomy_assoc (
txnid SERIAL,
nid integer NOT NULL default 0,
tid integer NOT NULL default 0,
PRIMARY KEY (txnid)
);
CREATE INDEX txn_nid on taxonomy_assoc (nid);
CREATE INDEX txn_tid on taxonomy_assoc (tid);