Mercurial > p > roundup > code
comparison roundup/backends/back_postgresql.py @ 6587:4f8fc55730e1
Add words_both_idx to newly created databases.
The changes to the otk and session table done by fix_version_3_tables
look like they were rolled into create_version_2_tables, but the new
index creation wasn't. So call self.fix_version_3_tables() to add the
index.
| author | John Rouillard <rouilj@ieee.org> |
|---|---|
| date | Sat, 22 Jan 2022 01:33:06 -0500 |
| parents | c1d3fbcdbfbd |
| children | e70e2789bc2c |
comparison
equal
deleted
inserted
replaced
| 6586:24e2eeb2ed9a | 6587:4f8fc55730e1 |
|---|---|
| 194 self.init_dbschema() | 194 self.init_dbschema() |
| 195 self.sql("CREATE TABLE schema (schema TEXT)") | 195 self.sql("CREATE TABLE schema (schema TEXT)") |
| 196 self.sql("CREATE TABLE dual (dummy integer)") | 196 self.sql("CREATE TABLE dual (dummy integer)") |
| 197 self.sql("insert into dual values (1)") | 197 self.sql("insert into dual values (1)") |
| 198 self.create_version_2_tables() | 198 self.create_version_2_tables() |
| 199 self.fix_version_3_tables() | |
| 199 # Need to commit here, otherwise otk/session will not find | 200 # Need to commit here, otherwise otk/session will not find |
| 200 # the necessary tables (in a parallel connection!) | 201 # the necessary tables (in a parallel connection!) |
| 201 self.commit() | 202 self.commit() |
| 202 | 203 |
| 203 def checkpoint_data(self): | 204 def checkpoint_data(self): |