From: | <ogjunk-pgjedan(at)yahoo(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Renaming a sequence? |
Date: | 2006-03-25 03:22:59 |
Message-ID: | 20060325032259.66690.qmail@web50310.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi,
I just renamed some of my tables, but I now have sequences with older names.
I followed info from http://www.postgresql.org/docs/current/static/sql-altersequence.html :
"Some variants of ALTER TABLE can be used with sequences as well; for example, to rename a sequence use ALTER TABLE RENAME"
So this is what I did:
ALTER TABLE topic_id_seq RENAME TO watchlist_id_seq;
That *appeared* to work, but I still see the old sequence name:
mydb => \d watchlist
Table "public.watchlist"
Column | Type | Modifiers
--------------+-------------------------------+-------------------------------------------------------
id | integer | not null default nextval('public.topic_id_seq'::text)
...
Indexes:
"pk_topic_id" PRIMARY KEY, btree (id)
It looks like my sequence WAS renamed, but my table's PK points to the old sequence name, which is not supposed to exist any more. Is there any way to change this without killing the sequence?
Thanks,
Otis
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas F. O'Connell | 2006-03-25 06:23:22 | Re: Continuous On-line Backups |
Previous Message | adey | 2006-03-25 00:53:19 | Re: Bloated pg_shdepend_depender_index |