From f87c538db461c16c110c05190c9f14ed605f6df3 Mon Sep 17 00:00:00 2001 From: =?utf8?q?=C3=98yvind=20A=2E=20Holm?= Date: Sat, 27 Jul 2013 19:43:21 +0200 Subject: [PATCH] Remove "numpoints" column from wayp, wayp_new and wayp_rej + related code It takes too long to update the thing, and I've found no real use for it. 4824090c-f6e4-11e2-8499-fefdb24f8e10 --- postgres/create_table.sql | 3 --- postgres/create_views.sql | 1 - postgres/distupdate.sql | 2 -- 3 files changed, 6 deletions(-) diff --git a/postgres/create_table.sql b/postgres/create_table.sql index fd3fb59..8321379 100644 --- a/postgres/create_table.sql +++ b/postgres/create_table.sql @@ -21,7 +21,6 @@ CREATE TABLE wayp ( descr text, -- A text description. Additional info intended for the user, not the GPS. src text, sym text, - numpoints integer, id integer ); @@ -35,7 +34,6 @@ CREATE TABLE wayp_new ( descr text, -- A text description. Additional info intended for the user, not the GPS. src text, sym text, - numpoints integer, id serial ); @@ -49,7 +47,6 @@ CREATE TABLE wayp_rej ( descr text, -- A text description. Additional info intended for the user, not the GPS. src text, sym text, - numpoints integer, id integer ); diff --git a/postgres/create_views.sql b/postgres/create_views.sql index d72e307..863a197 100644 --- a/postgres/create_views.sql +++ b/postgres/create_views.sql @@ -154,7 +154,6 @@ CREATE OR REPLACE VIEW wp AS -- {{{ coor AS coor, substr(name, 1, 20) AS name, type AS type, - numpoints as nump, substr(cmt, 1, 20) AS cmt, ele AS ele, time AS time diff --git a/postgres/distupdate.sql b/postgres/distupdate.sql index 33be518..e26f7e1 100644 --- a/postgres/distupdate.sql +++ b/postgres/distupdate.sql @@ -14,6 +14,4 @@ BEGIN ISOLATION LEVEL SERIALIZABLE; OR date IS NULL; \i statcurr.sql - \echo ================ Update wayp.numpoints ================ - UPDATE wayp SET numpoints = numpoints(name); COMMIT; -- 2.11.4.GIT