diff schema/updates/1009/01.drop-fa-date_info-default.sql @ 4057:b79b60c0cc5a

date_info has to be provided by the data source
author Tom Gottfried <tom@intevation.de>
date Thu, 25 Jul 2019 08:16:34 +0200
parents
children
line wrap: on
line diff
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/schema/updates/1009/01.drop-fa-date_info-default.sql	Thu Jul 25 08:16:34 2019 +0200
@@ -0,0 +1,2 @@
+ALTER TABLE waterway.fairway_availability ALTER COLUMN date_info DROP DEFAULT;
+DROP TRIGGER fairway_availability_date_info ON waterway.fairway_availability;