| From: | Don Y <pgsql(at)DakotaCom(dot)Net> |
|---|---|
| To: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: ALTER SEQUENCE |
| Date: | 2006-05-17 21:48:47 |
| Message-ID: | 446B9A3F.4080700@DakotaCom.Net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Bruce Momjian wrote:
> Don Y wrote:
>> Hi,
>>
>> It doesn't appear that there is a way to rename a sequence
>> (ideally with a "cascade" action).
>
>
> Uh, the ALTER SEQUENCE manual page says:
Uh, the 8.0.3 man page for ALTER SEQUENCE makes no mention of this.
Nor does "\h ALTER SEQUENCE" in psql yield any pointers.
> Some variants of ALTER TABLE can be used with sequences as
> well; for example, to rename a sequence use ALTER TABLE
> RENAME.
>
> Does that help?
Sure! It appears to allow both the rename and change of ownership.
Thanks!
Obviously, the documentation doesn't agree with the code :-(
But, it still leaves unanswered the question of the risk involved
in just changing the name/owner in the system tables...
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Emi Lu | 2006-05-17 21:48:52 | Re: RES: Add column and specify the column position in |
| Previous Message | Bruce Momjian | 2006-05-17 21:46:39 | Re: ALTER SEQUENCE |