From bbdfb06bda93b72106ead0256034959bc78d01c7 Mon Sep 17 00:00:00 2001 From: Regina Obe Date: Wed, 17 Apr 2013 12:46:07 +0000 Subject: [PATCH] oops had wrong data type for tables git-svn-id: http://svn.osgeo.org/postgis/trunk@11306 b70326c6-7e19-0410-871a-916f4a2858ee --- .../tiger_geocoder/tiger_2011/pagc_normalize/pagc_tables.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) 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 e750dfd26..df24a95b3 100644 --- a/extras/tiger_geocoder/tiger_2011/pagc_normalize/pagc_tables.sql +++ b/extras/tiger_geocoder/tiger_2011/pagc_normalize/pagc_tables.sql @@ -10,11 +10,11 @@ DECLARE var_temp text; BEGIN var_temp := tiger.SetSearchPathForInstall('tiger'); /** set set search path to have tiger in front **/ IF NOT EXISTS(SELECT table_name FROM information_schema.columns WHERE table_schema = 'tiger' AND table_name = 'pagc_gaz') THEN - CREATE TABLE pagc_gaz (id serial NOT NULL primary key ,seq integer ,word character varying, stdword character varying, token integer,is_custom boolean NOT NULL default true); + CREATE TABLE pagc_gaz (id serial NOT NULL primary key ,seq integer ,word text, stdword text, token integer,is_custom boolean NOT NULL default true); GRANT SELECT ON pagc_gaz TO public; END IF; IF NOT EXISTS(SELECT table_name FROM information_schema.columns WHERE table_schema = 'tiger' AND table_name = 'pagc_lex') THEN - CREATE TABLE pagc_lex (id serial NOT NULL primary key,seq integer,word character varying,stdword character varying,token integer,is_custom boolean NOT NULL default true); + CREATE TABLE pagc_lex (id serial NOT NULL primary key,seq integer,word text,stdword text,token integer,is_custom boolean NOT NULL default true); GRANT SELECT ON pagc_lex TO public; END IF; IF NOT EXISTS(SELECT table_name FROM information_schema.columns WHERE table_schema = 'tiger' AND table_name = 'pagc_rules') THEN -- 2.50.1