Mercurial > p > roundup > code
comparison roundup/backends/back_postgresql.py @ 2745:b284ff7af3fb
add optimised index on postgresql text index table
| author | Richard Jones <richard@users.sourceforge.net> |
|---|---|
| date | Fri, 08 Oct 2004 08:10:37 +0000 |
| parents | 402d6d556558 |
| children | a7045bad20de |
comparison
equal
deleted
inserted
replaced
| 2742:8ac87d4092e2 | 2745:b284ff7af3fb |
|---|---|
| 149 %s_value VARCHAR(255), %s_time REAL)'''%(name, name, name, | 149 %s_value VARCHAR(255), %s_time REAL)'''%(name, name, name, |
| 150 name)) | 150 name)) |
| 151 self.sql('CREATE INDEX %ss_key_idx ON %ss(%s_key)'%(name, name, | 151 self.sql('CREATE INDEX %ss_key_idx ON %ss(%s_key)'%(name, name, |
| 152 name)) | 152 name)) |
| 153 | 153 |
| 154 def fix_version_3_tables(self): | |
| 155 rdbms_common.Database.fix_version_3_tables(self) | |
| 156 self.sql('''CREATE INDEX words_both_idx ON public.__words | |
| 157 USING btree (_word, _textid)''') | |
| 158 | |
| 154 def add_actor_column(self): | 159 def add_actor_column(self): |
| 155 # update existing tables to have the new actor column | 160 # update existing tables to have the new actor column |
| 156 tables = self.database_schema['tables'] | 161 tables = self.database_schema['tables'] |
| 157 for name in tables.keys(): | 162 for name in tables.keys(): |
| 158 self.sql('ALTER TABLE _%s add __actor VARCHAR(255)'%name) | 163 self.sql('ALTER TABLE _%s add __actor VARCHAR(255)'%name) |