Update update_cservice_pgsql13_20220410.sql

Fix added to INSERT into last_seen in order for cservice.addme.sql script to work.

diff --git a/doc/update_cservice_pgsql13_20220410.sql b/doc/update_cservice_pgsql13_20220410.sql
index f5c9647807ffa167a5f0b33491ba8f88dd612619..91665ea137dc075783555d8b3a77f87a7e5774b1 100644 (file)
--- a/doc/update_cservice_pgsql13_20220410.sql
+++ b/doc/update_cservice_pgsql13_20220410.sql
@@ -6,7 +6,7 @@ alter table glines alter column LastUpdated set default date_part('epoch', CURRE
 CREATE OR REPLACE FUNCTION new_user() RETURNS TRIGGER AS '
 -- creates the users associated last_seen record
 BEGIN
-        INSERT INTO users_lastseen (user_id, last_seen, last_updated) VALUES(NEW.id, date_part("epoch", CURRENT_TIMESTAMP)::int,  date_part("epoch", CURRENT_TIMESTAMP)::int);
+        INSERT INTO users_lastseen (user_id, last_seen, last_updated) VALUES(NEW.id, extract(epoch FROM now())::int, extract(epoch FROM now())::int);
         RETURN NEW;
 END;
 ' LANGUAGE 'plpgsql';