From 720924a624afa045682de3280f78ebb09cd94dda Mon Sep 17 00:00:00 2001 From: Regina Obe Date: Mon, 15 Jul 2013 16:09:22 +0000 Subject: [PATCH] reset gaz counter git-svn-id: http://svn.osgeo.org/postgis/trunk@11688 b70326c6-7e19-0410-871a-916f4a2858ee --- .../tiger_geocoder/tiger_2011/pagc_normalize/pagc_tables.sql | 3 +++ 1 file changed, 3 insertions(+) diff --git a/extras/tiger_geocoder/tiger_2011/pagc_normalize/pagc_tables.sql b/extras/tiger_geocoder/tiger_2011/pagc_normalize/pagc_tables.sql index 4230497f9..4c3698b24 100644 --- a/extras/tiger_geocoder/tiger_2011/pagc_normalize/pagc_tables.sql +++ b/extras/tiger_geocoder/tiger_2011/pagc_normalize/pagc_tables.sql @@ -873,6 +873,9 @@ INSERT INTO pagc_gaz (id, seq, word, stdword, token, is_custom) VALUES (446, 1, INSERT INTO pagc_gaz (id, seq, word, stdword, token, is_custom) VALUES (448, 3, 'WY', 'WY', 6, false); INSERT INTO pagc_gaz (id, seq, word, stdword, token, is_custom) VALUES (449, 1, 'WYOMING', 'WY', 11, false); INSERT INTO pagc_gaz (id, seq, word, stdword, token, is_custom) VALUES (835, 1, 'ST LOUIS', 'SAINT LOUIS', 7, false); + +SELECT pg_catalog.setval('pagc_gaz_id_seq', (SELECT greatest((SELECT MAX(id) FROM pagc_gaz),50000)), true); + -- start pagc_lex -- INSERT INTO pagc_lex (id, seq, word, stdword, token, is_custom) VALUES (2934, 1, 'BAY STATE', 'BAY STATE', 5, false); INSERT INTO pagc_lex (id, seq, word, stdword, token, is_custom) VALUES (2389, 2, 'STAT', 'STA', 24, false); -- 2.50.1