Sequences

From: dmorgan(at)corpmedia(dot)com (Danny Morgan)
To: pgsql-admin(at)postgresql(dot)org
Subject: Sequences
Date: 2002-10-28 18:56:49
Message-ID: "H00000be00141482.1035831408.cmg-mail-1.com*"@MHS
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Danny Morgan 2002-10-28 19:00:44 Sequences
Previous Message Tom Lane 2002-10-28 18:31:14 Re: Error on Vacuum Full