1 files changed, 6 insertions, 1 deletions
diff --git a/migrations/6_genericize_access_control.sql b/migrations/6_genericize_access_control.sql
index b415d5b..c7727bf 100644
--- a/migrations/6_genericize_access_control.sql
+++ b/migrations/6_genericize_access_control.sql
@@ -1,3 +1,5 @@
+BEGIN;
+
 ALTER TABLE lazychat_targets RENAME TO post_targets;
 
 CREATE VIEW user_visible_posts AS
@@ -5,10 +7,13 @@ CREATE VIEW user_visible_posts AS
      FROM effective_user_roles eur, post_targets t
     WHERE t.target = eur.role
   UNION
-    SELECT m.owner, m.message
+    SELECT m.owner, m.id
     FROM posts m;
 
 CREATE OR REPLACE VIEW user_visible_lazychat_messages AS
   SELECT uvp.user, uvp.message
     FROM user_visible_posts uvp
     INNER JOIN lazychat_messages lm ON lm.id = uvp.message;
+
+COMMIT;
+