3 -- change the way event objects are fetched, use a view for that purpose
7 CREATE OR REPLACE VIEW view_event_objects AS
17 CAST(date_part('epoch', events.time) AS bigint) AS time,
18 event_object.object_id,
19 event_object.object_type
20 FROM events LEFT JOIN event_object USING (event_id);
23 ---------- bump subversion
25 UPDATE plc_db_version SET subversion = 7;
26 SELECT subversion from plc_db_version;