git://git.onelab.eu
/
plcapi.git
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
|
inline
| side by side (parent:
cbf8b26
)
fixes in sql schema for f37/pgsql14: oddly this was working before
author
Thierry Parmentelat
<thierry.parmentelat@inria.fr>
Wed, 23 Nov 2022 08:05:51 +0000
(09:05 +0100)
committer
Thierry Parmentelat
<thierry.parmentelat@inria.fr>
Wed, 23 Nov 2022 15:42:49 +0000
(16:42 +0100)
planetlab5.sql
patch
|
blob
|
history
diff --git
a/planetlab5.sql
b/planetlab5.sql
index
a4f028d
..
61ff7fd
100644
(file)
--- 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.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,
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;
--------------------------------------------------------------------------------
FROM conf_files;
--------------------------------------------------------------------------------
-DROP VIEW view_pcus;
CREATE OR REPLACE VIEW view_pcus AS
SELECT
pcus.pcu_id,
CREATE OR REPLACE VIEW view_pcus AS
SELECT
pcus.pcu_id,