Skip site navigation (1) Skip section navigation (2)

Re: alter table rename

From: Neil Conway <neilc(at)samurai(dot)com>
To: Gavin Sherry <swm(at)alcove(dot)com(dot)au>
Cc: Philip Rhoades <phil(at)pricom(dot)com(dot)au>, sydpug(at)postgresql(dot)org
Subject: Re: alter table rename
Date: 2004-10-27 01:57:55
Message-ID: 1098842275.1964.45.camel@localhost.localdomain (view raw or flat)
Thread:
Lists: sydpug
On Wed, 2004-10-27 at 11:42, Gavin Sherry wrote:
> On Tue, 26 Oct 2004, Philip Rhoades wrote:
> > I presume it is OK to ask these questions here?

It's fine, although you might get more response from a wider audience
such as pgsql-general.

> You can use ALTER TABLE <index/sequence name> RENAME TO <new name> in 7.4.

Note that this doesn't change the serial column's default value though.

BTW, in 8.0 you can change a column type's via ALTER TABLE so you don't
need this hackery.

> No one has done ALTER SEQUENCE though.

Yeah, we ought to do that -- we already have an ALTER SEQUENCE, it just
doesn't do RENAME.

-Neil



In response to

sydpug by date

Next:From: Anand KumriaDate: 2004-10-28 04:16:12
Subject: next meeting?
Previous:From: Gavin SherryDate: 2004-10-27 01:42:27
Subject: Re: alter table rename

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group