Revision 7053
Added by ben leinfelder over 12 years ago
upgrade-db-to-2.0.0-postgres.sql | ||
---|---|---|
163 | 163 |
*/ |
164 | 164 |
ALTER TABLE xml_access DROP COLUMN docid; |
165 | 165 |
|
166 |
|
|
167 |
/** |
|
168 |
* expand xml_path_index 'path' column to hold larger strings |
|
169 |
*/ |
|
170 |
ALTER TABLE xml_path_index ALTER COLUMN path TYPE text; |
|
171 |
|
|
166 | 172 |
/* |
167 | 173 |
* update the database version |
168 | 174 |
*/ |
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]