X-Git-Url: http://git.squeep.com/?p=websub-hub;a=blobdiff_plain;f=src%2Fdb%2Fpostgres%2Fsql%2Fsubscription-delivery-success.sql;h=b19b376593f54405e2a6ef7532bcef912d0f1ebe;hp=9ff01e0395ef7c689b3ae6d1af33d586d77b683a;hb=d5e7908d3e60ee0cb3149163d4749563cdfafeb3;hpb=a03352195c7ecfde25a8cf9aba6dd9666e1a3fea

diff --git a/src/db/postgres/sql/subscription-delivery-success.sql b/src/db/postgres/sql/subscription-delivery-success.sql
index 9ff01e0..b19b376 100644
--- a/src/db/postgres/sql/subscription-delivery-success.sql
+++ b/src/db/postgres/sql/subscription-delivery-success.sql
@@ -1,6 +1,7 @@
 --
 UPDATE subscription SET
 	content_delivered = now(),
+	latest_content_delivered = $(topicContentUpdated),
 	delivery_attempts_since_success = 0,
 	delivery_next_attempt = '-infinity'::timestamptz
 WHERE