root/trunk/derived/biengeo/update.alternateNames.sql @ 12179
| 1 |
BEGIN; |
|---|---|
| 2 |
|
| 3 |
SELECT setval('alternatenames_alternatenameid_seq', (SELECT max(alternatenameid) FROM alternatenames)); |
| 4 |
-- 4m45.368s
|
| 5 |
|
| 6 |
-- index alternatenames
|
| 7 |
CREATE INDEX "alternatenames_alternatename_idx" ON alternateNames (alternateName); |
| 8 |
-- 10m42.827s
|
| 9 |
CREATE INDEX "alternatenames_geonameid_idx" ON alternateNames (geonameid); |
| 10 |
|
| 11 |
COMMIT; |
| 12 |
|