From patchwork Wed Oct 24 22:11:19 2012 Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit X-Patchwork-Submitter: Simo Sorce X-Patchwork-Id: 194005 Return-Path: X-Original-To: incoming@patchwork.ozlabs.org Delivered-To: patchwork-incoming@bilbo.ozlabs.org Received: from ozlabs.org (localhost [IPv6:::1]) by ozlabs.org (Postfix) with ESMTP id 9FBF72C00C8 for ; Thu, 25 Oct 2012 09:11:24 +1100 (EST) Received: from mail.samba.org (fn.samba.org [216.83.154.106]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (Client did not present a certificate) by ozlabs.org (Postfix) with ESMTPS id CCFDD2C009B for ; Thu, 25 Oct 2012 09:11:21 +1100 (EST) Received: from [127.0.0.1] (localhost [127.0.0.1]) by mail.samba.org (Postfix) with ESMTP id 74703AD370 for ; Wed, 24 Oct 2012 16:11:19 -0600 (MDT) Message-ID: <1351116679.2010.35.camel@pico.ipa.ssimo.org> Subject: [PATCH] fix postgres grant script From: simo To: Patchwork@lists.ozlabs.org Date: Wed, 24 Oct 2012 18:11:19 -0400 Organization: Samba Team X-Mailer: Evolution 3.4.4 (3.4.4-2.fc17) Mime-Version: 1.0 X-BeenThere: patchwork@lists.ozlabs.org X-Mailman-Version: 2.1.15 Precedence: list List-Id: Patchwork development List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: patchwork-bounces+incoming=patchwork.ozlabs.org@lists.ozlabs.org Sender: "Patchwork" 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