From 119346542b56f968eb5649e52a929d9937718512 Mon Sep 17 00:00:00 2001 From: Thierry Parmentelat Date: Wed, 23 Nov 2022 09:05:51 +0100 Subject: [PATCH] fixes in sql schema for f37/pgsql14: oddly this was working before --- planetlab5.sql | 2 -- 1 file changed, 2 deletions(-) diff --git a/planetlab5.sql b/planetlab5.sql index a4f028d..61ff7fd 100644 --- a/planetlab5.sql +++ b/planetlab5.sql @@ -1170,7 +1170,6 @@ nodes.key, CAST(date_part('epoch', nodes.date_created) AS bigint) AS date_created, CAST(date_part('epoch', nodes.last_updated) AS bigint) AS last_updated, CAST(date_part('epoch', nodes.last_contact) AS bigint) AS last_contact, -CAST(date_part('epoch', nodes.last_boot) AS bigint) AS last_boot, CAST(date_part('epoch', nodes.last_download) AS bigint) AS last_download, CAST(date_part('epoch', nodes.last_pcu_reboot) AS bigint) AS last_pcu_reboot, CAST(date_part('epoch', nodes.last_pcu_confirmation) AS bigint) AS last_pcu_confirmation, @@ -1231,7 +1230,6 @@ AS nodegroup_ids FROM conf_files; -------------------------------------------------------------------------------- -DROP VIEW view_pcus; CREATE OR REPLACE VIEW view_pcus AS SELECT pcus.pcu_id, -- 2.43.0