Revision 7053
Added by ben leinfelder about 12 years ago
| xmltables-postgres.sql | ||
|---|---|---|
| 405 | 405 |
CREATE TABLE xml_path_index ( |
| 406 | 406 |
nodeid INT8 default nextval('xml_path_index_id_seq'),
|
| 407 | 407 |
docid VARCHAR(250), -- the document id |
| 408 |
path VARCHAR(1000), -- precomputed path through tree
|
|
| 408 |
path TEXT, -- precomputed path through tree
|
|
| 409 | 409 |
nodedata TEXT, -- the data for this node (e.g., |
| 410 | 410 |
-- for TEXT it is the content) |
| 411 | 411 |
nodedatanumerical FLOAT8, -- the data for this node if it is a number |
Also available in: Unified diff
increase amount of text the 'xml_path_index.path' column can accommodate. I was seeing errors like this during indexing:
knb 20120312-11:42:05: [ERROR]: DocumentImpl.buildIndex - SQL Exception while indexing document knb-lter-and.3147 : ERROR: value too long for type character varying(1000) [edu.ucsb.nceas.metacat.DocumentImpl]