Sandro Santilli strk

GIS Hacker

strk / index.html

Last active August 29, 2015 13:56 — forked from andrewxhill/index.html

	<!DOCTYPE html>
	<html lang="en">
	<head>
	<meta charset="utf-8">
	<!--Edit the title of the page-->
	<title>CartoDB Point Clustering</title>
	<meta name="description" content="">
	<meta name="author" content="">
	<meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1">
	<link rel="stylesheet" href="http://libs.cartocdn.com/cartodb.js/v3/themes/css/cartodb.css" />

strk / gist:aac9149e43bc4a4ec9667efe23b35679

Last active February 15, 2018 17:31

Fix table_version revision disorder

	--
	-- Change ID of any revision having revision_time at a later time than
	-- any other revision with higher ID
	--
	-- New IDs for revisions to be moved will be assigned in
	-- revision_time order and start after the highest existing
	-- revision ID.
	--
	-- The number of moved revisions is returned.
	--

strk / gist:9b6c7cbee02e8d3fae3f317b052c49f0

Created February 15, 2018 16:03

create table_version revision disorder

	CREATE EXTENSION table_version;

	CREATE TABLE IF NOT EXISTS t (k int primary key, v text);
	SELECT table_version.ver_enable_versioning('public','t');
	SELECT table_version.ver_create_revision('r1'); -- 1001 (empty)
	SELECT table_version.ver_complete_revision();
	SELECT table_version.ver_create_revision('r2'); -- 1002
	INSERT INTO t VALUES (1, 'a');
	INSERT INTO t VALUES (2, 'b');
	INSERT INTO t VALUES (3, 'c');

strk / ver_unknown_revisions.sql

Created May 3, 2018 10:23

	DROP FUNCTION IF EXISTS table_version.ver_unknown_revisions();
	CREATE OR REPLACE FUNCTION table_version.ver_unknown_revisions()
	RETURNS TABLE (tab TEXT, rev INT) AS
	$$
	DECLARE
	v_rec RECORD;

	BEGIN
	DROP TABLE IF EXISTS tmp_ids;
	CREATE TEMP TABLE tmp_ids(t text, r int);