Patchwork fix postgres grant script

login
register
mail settings
Submitter Simo Sorce
Date Oct. 24, 2012, 10:11 p.m.
Message ID <1351116679.2010.35.camel@pico.ipa.ssimo.org>
Download mbox | patch
Permalink /patch/194005/
State Superseded
Headers show

Comments

Simo Sorce - Oct. 24, 2012, 10:11 p.m.
Current script fails with a rollback because one of the recently added
sequences does not exist in the db.

Simo.

Patch

From 96b4cc59dff0d340ad0d3932b6dd0c2b66f82e7a Mon Sep 17 00:00:00 2001
From: Simo Sorce <idra@samba.org>
Date: Wed, 24 Oct 2012 18:07:00 -0400
Subject: [PATCH] Fix grant script

patchwork_patchchangenotification_id_seq does not exist,
so running this script simply fails with a rollback
---
 lib/sql/grant-all.postgres.sql | 1 -
 1 file changed, 1 deletion(-)

diff --git a/lib/sql/grant-all.postgres.sql b/lib/sql/grant-all.postgres.sql
index 72abb57..dc0cf9f 100644
--- a/lib/sql/grant-all.postgres.sql
+++ b/lib/sql/grant-all.postgres.sql
@@ -47,7 +47,6 @@  GRANT SELECT, UPDATE ON
 	patchwork_emailconfirmation_id_seq,
 	patchwork_userprofile_id_seq,
 	patchwork_userprofile_maintainer_projects_id_seq,
-	patchwork_patchchangenotification_id_seq
 TO "www-data";
 
 -- allow the mail user (in this case, 'nobody') to add patches
-- 
1.7.12.1