Re: [GENERAL] Changing referenced primary key column type

2009-08-07 Thread Tom Lane
"Andrus Moor" writes: > 8.x Db contains tables > create table ametikoh ( ametikoht numeric(7) NOT NULL DEFAULT > nextval('firma1.ametikoh_ametikoht_seq'::regclass) primary key ); > create table iandmed ( ametikoht numeric(7) references ametikoh); > I created conversion script which normalizes c

[GENERAL] Changing referenced primary key column type

2009-08-07 Thread Andrus Moor
8.x Db contains tables create table ametikoh ( ametikoht numeric(7) NOT NULL DEFAULT nextval('firma1.ametikoh_ametikoht_seq'::regclass) primary key ); create table iandmed ( ametikoht numeric(7) references ametikoh); I created conversion script which normalizes column types: alter table amet