Error in pgsql Script lineage.pgsql
| Project: | Taxonomy Lineage |
| Component: | Code |
| Category: | bug report |
| Priority: | critical |
| Assigned: | Unassigned |
| Status: | closed |
Jump to:
the Script (lineage.pgsql) in zip Download is like about:
CREATE TABLE term_lineage (
tid integer NOT NULL default '0',
lineage varchar(255) NOT NULL default ''
depth integer varchar(255) NOT NULL default ''
);
CREATE INDEX term_lineage_tid_idx ON term_lineage(tid);
CREATE INDEX term_lineage_lineage_idx ON term_lineage(lineage);
1) The field depth is Integer
2) The character "," is missing in line 3
This script will working correctly:
CREATE TABLE term_lineage (
tid integer NOT NULL default '0',
lineage varchar(255) NOT NULL default '',
depth integer NOT NULL default '0'
);
CREATE INDEX term_lineage_tid_idx ON term_lineage(tid);
CREATE INDEX term_lineage_lineage_idx ON term_lineage(lineage);

#1
I appear to have fixed this a month ago and just forgot to close the issue.
#2