Revision 2949
Added by berkley almost 19 years ago
src/xmltables-postgres.sql | ||
---|---|---|
289 | 289 |
* Returnfields -- table to store combinations of returnfields requested |
290 | 290 |
* and the number of times this table is accessed |
291 | 291 |
*/ |
292 |
CREATE SEQUENCE xml_returnfield_id_seq; |
|
292 | 293 |
CREATE TABLE xml_returnfield ( |
293 | 294 |
returnfield_id INT8 default nextval('xml_returnfield_id_seq'), -- the id for this returnfield entry |
294 | 295 |
returnfield_string VARCHAR(2000), -- the returnfield string |
... | ... | |
297 | 298 |
); |
298 | 299 |
CREATE INDEX xml_returnfield_idx1 ON xml_returnfield(returnfield_string); |
299 | 300 |
|
300 |
CREATE SEQUENCE xml_returnfield_id_seq; |
|
301 |
|
|
302 | 301 |
/* |
303 | 302 |
* Queryresults -- table to store queryresults for a given docid |
304 | 303 |
* and returnfield_id |
305 | 304 |
*/ |
305 |
CREATE SEQUENCE xml_queryresult_id_seq; |
|
306 | 306 |
CREATE TABLE xml_queryresult( |
307 | 307 |
queryresult_id INT8 default nextval('xml_queryresult_id_seq'), -- id for this entry |
308 | 308 |
returnfield_id INT8, -- id for the returnfield corresponding to this entry |
... | ... | |
316 | 316 |
|
317 | 317 |
CREATE INDEX xml_queryresult_idx1 ON xml_queryresult (returnfield_id, docid); |
318 | 318 |
|
319 |
CREATE SEQUENCE xml_queryresult_id_seq; |
|
320 |
|
|
321 | 319 |
/* |
322 | 320 |
* Logging -- table to store metadata and data access log |
323 | 321 |
*/ |
Also available in: Unified diff
fixed a bug with postgres 8.1.6 where the sequence must be created before the table is created.