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 h

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

Re: [HACKERS] ALTER TABLE RENAME column

2006-11-17 Thread Mario Weilguni
vember 2006 16:27 An: Mario Weilguni Cc: Tom Lane; Jim Nasby; PostgreSQL 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

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: 73

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 Mario Weilguni
cht- 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 colum

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 andre

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: 732

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 versions

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

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 s

[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 broadcast)