From b8a91d9d1c7ec75aaecf13df687ec7b5b0ed35a6 Mon Sep 17 00:00:00 2001
From: Simon Riggs <simon@2ndQuadrant.com>
Date: Mon, 23 Jan 2012 23:25:04 +0000
Subject: ALTER <thing> [IF EXISTS] ... allows silent DDL if required, e.g.
 ALTER FOREIGN TABLE IF EXISTS foo RENAME TO bar

Pavel Stehule
---
 src/backend/commands/sequence.c | 10 +++++++++-
 1 file changed, 9 insertions(+), 1 deletion(-)

(limited to 'src/backend/commands/sequence.c')

diff --git a/src/backend/commands/sequence.c b/src/backend/commands/sequence.c
index f7712a96556..d3739cb0952 100644
--- a/src/backend/commands/sequence.c
+++ b/src/backend/commands/sequence.c
@@ -425,7 +425,15 @@ AlterSequence(AlterSeqStmt *stmt)
 	List	   *owned_by;
 
 	/* Open and lock sequence. */
-	relid = RangeVarGetRelid(stmt->sequence, AccessShareLock, false);
+	relid = RangeVarGetRelid(stmt->sequence, AccessShareLock, stmt->missing_ok);
+	if (relid == InvalidOid)
+	{
+		ereport(NOTICE,
+				(errmsg("relation \"%s\" does not exist, skipping",
+							stmt->sequence->relname)));
+		return;
+	}
+
 	init_sequence(relid, &elm, &seqrel);
 
 	/* allow ALTER to sequence owner only */
-- 
cgit v1.2.3