Re: [HACKERS] ALTER TABLE RENAME column

2006-11-17 Thread Richard Huxton
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

Re: [HACKERS] ALTER TABLE RENAME column

2006-11-17 Thread Jonah H. Harris
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:

Re: [HACKERS] ALTER TABLE RENAME column

2006-11-17 Thread Andrew Dunstan
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

Re: [HACKERS] ALTER TABLE RENAME column

2006-11-17 Thread Mario Weilguni
- 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

Re: [HACKERS] ALTER TABLE RENAME column

2006-11-17 Thread Jonah H. Harris
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

Re: [HACKERS] ALTER TABLE RENAME column

2006-11-17 Thread Jonah H. Harris
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:

Re: [HACKERS] ALTER TABLE RENAME column

2006-11-17 Thread Mario Weilguni
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

Re: [HACKERS] ALTER TABLE RENAME column

2006-11-17 Thread Tom Lane
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

Re: [HACKERS] ALTER TABLE RENAME column

2006-11-17 Thread Jonah H. Harris
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

[HACKERS] ALTER TABLE RENAME column

2006-11-16 Thread Jim Nasby
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

Re: [HACKERS] ALTER TABLE RENAME column

2006-11-16 Thread Tom Lane
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

Re: [HACKERS] ALTER TABLE RENAME column

2006-11-16 Thread Peter Eisentraut
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