Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 848284762CD for ; Mon, 28 Oct 2002 16:32:58 -0500 (EST) Received: from wolff.to (unknown [66.93.197.35]) by postgresql.org (Postfix) with SMTP id 9872F47611B for ; Mon, 28 Oct 2002 16:32:57 -0500 (EST) Received: (qmail 30747 invoked by uid 500); 28 Oct 2002 21:42:10 -0000 Date: Mon, 28 Oct 2002 15:42:10 -0600 From: Bruno Wolff III To: Danny Morgan Cc: pgsql-admin@postgresql.org Subject: Re: Sequences Message-ID: <20021028214210.GA30735@wolff.to> Mail-Followup-To: Danny Morgan , pgsql-admin@postgresql.org References: <"H00000be0014148c.1035831644.cmg-mail-1.com*"@MHS> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <"H00000be0014148c.1035831644.cmg-mail-1.com*"@MHS> User-Agent: Mutt/1.3.25i X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200210/275 X-Sequence-Number: 6133 On Mon, Oct 28, 2002 at 14:00:44 -0500, Danny Morgan wrote: > I have a strange dilemma. I've created a couple sequences I can't > remove. > > Here is an example > > I can > CREATE SEQUENCE "count1" ..........; > DROP SEQUENCE count1; > > I can't > CREATE SEQUENCE "count1ListItems1" ..........; > DROP SEQUENCE count1ListItems1; Try: DROP SEQUENCE "count1ListItems1"; (Quoting preserves capitalization.)