Re: Sequences

* smacks your hand for using uppercase letters *

Another big no no is not keeping your create sequences for sequences ( what
a pun ) in a file somewhere.
Otherwise you can't drop them because you don't remember what parameters
they took ( but you can always, as you say, look at system tables )
Check the \ds.
If not there try \dS, which leads you to do:
select * from pg_statio_all_sequences;
if it's still not there - give up - it's not there :-p

Gareth

-----Original Message-----
From: pgsql-admin-owner(at)postgresql(dot)org
[mailto:pgsql-admin-owner(at)postgresql(dot)org]On Behalf Of Danny Morgan
Sent: 28 October 2002 18:57
To: pgsql-admin(at)postgresql(dot)org
Subject: [ADMIN] 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

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org