Peter Eisentraut wrote:
Jim Nasby wrote:
Any reason not to support renaming columns? Can this be added to
TODO?
Upgrade to Postgres95.
Hey, is Jim running MySQL 5?
--
Richard Huxton
Archonet Ltd
---(end of broadcast)---
TIP 9: In
On 11/16/06, Jim Nasby [EMAIL PROTECTED] wrote:
Any reason not to support renaming columns? Can this be added to TODO?
ALTER TABLE yo_table RENAME COLUMN yo_column TO yo_new_column;
?
--
Jonah H. Harris, Software Architect | phone: 732.331.1300
EnterpriseDB Corporation| fax:
Jonah H. Harris wrote:
On 11/16/06, Jim Nasby [EMAIL PROTECTED] wrote:
Any reason not to support renaming columns? Can this be added to TODO?
ALTER TABLE yo_table RENAME COLUMN yo_column TO yo_new_column;
Maybe Jim actually wants a reason to remove support for this ... :-)
cheers
andrew
-
Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Im Auftrag von Tom Lane
Gesendet: Freitag, 17. November 2006 07:05
An: Jim Nasby
Cc: PostgreSQL Hackers
Betreff: Re: [HACKERS] ALTER TABLE RENAME column
Jim Nasby [EMAIL PROTECTED] writes:
Any reason not to support renaming columns? Can
On 11/17/06, Mario Weilguni [EMAIL PROTECTED] wrote:
Sounds like this is not done, at least not renaming sequencens and constraints,
or am I wrong here?
To rename a sequence or a table:
ALTER TABLE yo_table RENAME TO yo_new_table;
ALTER TABLE yo_sequence RENAME TO yo_new_sequence;
Or am I
On 11/17/06, Mario Weilguni [EMAIL PROTECTED] wrote:
+ o Add ALTER TABLE RENAME COLUMN (should rename appropriate sequences and
constraints)
Actually, I don't believe it cascades the rename automagically... if
that's what you're asking.
--
Jonah H. Harris, Software Architect | phone:
Hackers
Betreff: Re: [HACKERS] ALTER TABLE RENAME column
On 11/17/06, Mario Weilguni [EMAIL PROTECTED] wrote:
Sounds like this is not done, at least not renaming sequencens and
constraints, or am I wrong here?
To rename a sequence or a table:
ALTER TABLE yo_table RENAME TO yo_new_table; ALTER
Mario Weilguni [EMAIL PROTECTED] writes:
IMO this should do:
Alter sequence foo_bar_seq rename to foo_baf_seq;
Alter table foo alter baf set default nextval('foo_baf_seq')
No, it should not, because that risks breaking other references to the
sequence (eg, in user-written functions). If the
On 11/17/06, Tom Lane [EMAIL PROTECTED] wrote:
No, it should not, because that risks breaking other references to the
sequence (eg, in user-written functions). If the user is feeling that
he wants consistency, he can rename the sequence himself and take
responsibility for any side-effects on
Any reason not to support renaming columns? Can this be added to TODO?
patch
Description: Binary data
--
Jim Nasby[EMAIL PROTECTED]
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
---(end of
Jim Nasby [EMAIL PROTECTED] writes:
Any reason not to support renaming columns? Can this be added to TODO?
Uh, we did that years ago.
regards, tom lane
---(end of broadcast)---
TIP 5: don't forget to increase your free
Jim Nasby wrote:
Any reason not to support renaming columns? Can this be added to
TODO?
Upgrade to Postgres95.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
12 matches
Mail list logo