karthikeyan kar...@relationalsolutions.com 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
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_nbr character varying(5) NOT NULL,
karthikeyan kar...@relationalsolutions.com 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