Renaming a sequence?

Поиск
Список
Период
Сортировка
От
Тема Renaming a sequence?
Дата
Msg-id 20060325032259.66690.qmail@web50310.mail.yahoo.com
обсуждение исходный текст
Ответы Re: Renaming a sequence?  ("Andy Shellam" <andy.shellam@mailnetwork.co.uk>)
Список 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
TABLERENAME"  

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
existany more.  Is there any way to change this without killing the sequence? 

Thanks,
Otis




В списке pgsql-admin по дате отправления:

Предыдущее
От: adey
Дата:
Сообщение: Re: Bloated pg_shdepend_depender_index
Следующее
От: "Thomas F. O'Connell"
Дата:
Сообщение: Re: Continuous On-line Backups