From d04bf78af08885e17ebaae7f198f93bbf06817e7 Mon Sep 17 00:00:00 2001
From: Dan Goodliffe <dan@randomdan.homeip.net>
Date: Sun, 25 Jul 2021 12:46:14 +0100
Subject: Support the rotate event to move to the next binlog file

---
 lib/output/pq/sql/updateSourceRotate.sql | 4 ++++
 1 file changed, 4 insertions(+)
 create mode 100644 lib/output/pq/sql/updateSourceRotate.sql

(limited to 'lib/output/pq/sql/updateSourceRotate.sql')

diff --git a/lib/output/pq/sql/updateSourceRotate.sql b/lib/output/pq/sql/updateSourceRotate.sql
new file mode 100644
index 0000000..74e22fc
--- /dev/null
+++ b/lib/output/pq/sql/updateSourceRotate.sql
@@ -0,0 +1,4 @@
+UPDATE mygrate.source SET
+	filename = $1,
+	position = $2
+WHERE source_id = $3
-- 
cgit v1.2.3

