Re: [GENERAL] Unable to Increase the column which was part of Primary key

2011-12-29 Thread Andreas Kretschmer
karthikeyan wrote: > Hi, > > I am trying to increase size of the column which was/is part of the Primary. > > Exiting table > CREATE TABLE test_dim_store > ( > storek integer NOT NULL DEFAULT > nextval('dim_store_storek_seq1'::regclass), > retailerk character varying(10) NOT NULL, > store

Re: [GENERAL] Unable to Increase the column which was part of Primary key

2011-12-28 Thread Tom Lane
karthikeyan writes: > I am trying to increase size of the column which was/is part of the Primary. > ... > Error message: > ERROR: xdb-83016: cannot alter scatter column > relation "test_dim_store" column "store_nbr" There is no such error text in the postgresql source code. I am guess