Re: [HACKERS] renameatt() can rename attribute of index, sequence, ...

2010-03-12 Thread Robert Haas
2010/3/11 KaiGai Kohei : > (2010/03/11 23:55), Robert Haas wrote: >> 2010/3/10 KaiGai Kohei: >>> Indeed, it is useful to allow renaming attribute of composite types. >>> >>> However, it is also useless to allow to rename attribute of sequences, >>> but harmless, like renames on indexes. It seems to

Re: [HACKERS] renameatt() can rename attribute of index, sequence, ...

2010-03-11 Thread KaiGai Kohei
(2010/03/11 23:55), Robert Haas wrote: > 2010/3/10 KaiGai Kohei: >> Indeed, it is useful to allow renaming attribute of composite types. >> >> However, it is also useless to allow to rename attribute of sequences, >> but harmless, like renames on indexes. It seems to me it is fair enough >> to allo

Re: [HACKERS] renameatt() can rename attribute of index, sequence, ...

2010-03-11 Thread Robert Haas
2010/3/10 KaiGai Kohei : > Indeed, it is useful to allow renaming attribute of composite types. > > However, it is also useless to allow to rename attribute of sequences, > but harmless, like renames on indexes. It seems to me it is fair enough > to allow renaming attributes of tables, views and co

Re: [HACKERS] renameatt() can rename attribute of index, sequence, ...

2010-03-10 Thread KaiGai Kohei
(2010/03/11 0:54), Robert Haas wrote: > On Wed, Mar 3, 2010 at 7:16 PM, Robert Haas wrote: >> 2010/3/3 KaiGai Kohei: >>> (2010/03/03 22:42), Robert Haas wrote: 2010/3/3 KaiGai Kohei: > (2010/03/03 14:26), Robert Haas wrote: >> 2010/3/2 KaiGai Kohei: >>> Is it an expected behavior?

Re: [HACKERS] renameatt() can rename attribute of index, sequence, ...

2010-03-10 Thread Robert Haas
On Wed, Mar 3, 2010 at 7:16 PM, Robert Haas wrote: > 2010/3/3 KaiGai Kohei : >> (2010/03/03 22:42), Robert Haas wrote: >>> 2010/3/3 KaiGai Kohei: (2010/03/03 14:26), Robert Haas wrote: > 2010/3/2 KaiGai Kohei: >> Is it an expected behavior? >> >>    postgres=>    CREATE SEQUEN

Re: [HACKERS] renameatt() can rename attribute of index, sequence, ...

2010-03-03 Thread Robert Haas
2010/3/3 KaiGai Kohei : > (2010/03/03 22:42), Robert Haas wrote: >> 2010/3/3 KaiGai Kohei: >>> (2010/03/03 14:26), Robert Haas wrote: 2010/3/2 KaiGai Kohei: > Is it an expected behavior? > >    postgres=>    CREATE SEQUENCE s; >    CREATE SEQUENCE >    postgres=>    ALTER T

Re: [HACKERS] renameatt() can rename attribute of index, sequence, ...

2010-03-03 Thread KaiGai Kohei
(2010/03/03 22:42), Robert Haas wrote: > 2010/3/3 KaiGai Kohei: >> (2010/03/03 14:26), Robert Haas wrote: >>> 2010/3/2 KaiGai Kohei: Is it an expected behavior? postgres=>CREATE SEQUENCE s; CREATE SEQUENCE postgres=>ALTER TABLE s RENAME sequence_name TO abc

Re: [HACKERS] renameatt() can rename attribute of index, sequence, ...

2010-03-03 Thread Robert Haas
2010/3/3 KaiGai Kohei : > (2010/03/03 14:26), Robert Haas wrote: >> 2010/3/2 KaiGai Kohei: >>> Is it an expected behavior? >>> >>>   postgres=>  CREATE SEQUENCE s; >>>   CREATE SEQUENCE >>>   postgres=>  ALTER TABLE s RENAME sequence_name TO abcd; >>>   ALTER TABLE >>> >>>   postgres=>  CREATE TABL

Re: [HACKERS] renameatt() can rename attribute of index, sequence, ...

2010-03-03 Thread Boszormenyi Zoltan
Hi, KaiGai Kohei írta: > (2010/03/03 14:26), Robert Haas wrote: > >> 2010/3/2 KaiGai Kohei: >> >>> Is it an expected behavior? >>> >>> postgres=> CREATE SEQUENCE s; >>> CREATE SEQUENCE >>> postgres=> ALTER TABLE s RENAME sequence_name TO abcd; >>> ALTER TABLE >>> >>> postgres=>

Re: [HACKERS] renameatt() can rename attribute of index, sequence, ...

2010-03-02 Thread KaiGai Kohei
(2010/03/03 14:26), Robert Haas wrote: > 2010/3/2 KaiGai Kohei: >> Is it an expected behavior? >> >> postgres=> CREATE SEQUENCE s; >> CREATE SEQUENCE >> postgres=> ALTER TABLE s RENAME sequence_name TO abcd; >> ALTER TABLE >> >> postgres=> CREATE TABLE t (a int primary key, b text); >>

Re: [HACKERS] renameatt() can rename attribute of index, sequence, ...

2010-03-02 Thread Robert Haas
2010/3/2 KaiGai Kohei : > Is it an expected behavior? > >  postgres=> CREATE SEQUENCE s; >  CREATE SEQUENCE >  postgres=> ALTER TABLE s RENAME sequence_name TO abcd; >  ALTER TABLE > >  postgres=> CREATE TABLE t (a int primary key, b text); >  NOTICE:  CREATE TABLE / PRIMARY KEY will create implici

Re: [HACKERS] renameatt() can rename attribute of index, sequence, ...

2010-03-02 Thread KaiGai Kohei
(2010/03/03 11:22), Tom Lane wrote: > KaiGai Kohei writes: >> Is it an expected behavior? > > There's no particular reason to forbid it, is there? Perhaps, it is harmless. It just seemed to me the renameatt() was not implemented correctly according to the documentation. -- KaiGai Kohei -- S

Re: [HACKERS] renameatt() can rename attribute of index, sequence, ...

2010-03-02 Thread Tom Lane
KaiGai Kohei writes: > Is it an expected behavior? There's no particular reason to forbid it, is there? regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql