From patchwork Wed Oct 24 22:11:19 2012 Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Subject: fix postgres grant script Date: Wed, 24 Oct 2012 12:11:19 -0000 From: Simo Sorce X-Patchwork-Id: 194005 Message-Id: <1351116679.2010.35.camel@pico.ipa.ssimo.org> To: Patchwork@lists.ozlabs.org Current script fails with a rollback because one of the recently added sequences does not exist in the db. Simo. >From 96b4cc59dff0d340ad0d3932b6dd0c2b66f82e7a Mon Sep 17 00:00:00 2001 From: Simo Sorce 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