Thread: Sequences

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;

    It states sequence xx does not exist.

I can \ds and it is there.

I'm using v7.2.3, is there a way to manually remove a sequence or best
yet why can't I remove a sequence that has only 16 chars?

Thanks,
Danny L. Morgan

On Mon, Oct 28, 2002 at 14:00:44 -0500,
  Danny Morgan <dmorgan@corpmedia.com> 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.)

Thanks, worked like a charm.

Danny L. Morgan

-----Original Message-----
From: bruno [mailto:bruno@wolff.to]
Sent: Monday, October 28, 2002 4:42 PM
To: dmorgan
Cc: pgsql-admin
Subject: Re: [ADMIN] Sequences


On Mon, Oct 28, 2002 at 14:00:44 -0500,
  Danny Morgan <dmorgan@corpmedia.com> 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.)

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)