You'll be glad to know that it's already fixed. Will be available in
beta 4.
Thank you. I guess the sql for changing owner for a type got fixed too
(in beta3 it recreates all the attributes when simply changing the
owner). The SQL below is what is generated by the dialog:
ALTER TYPE frt_exp_pajamos OWNER TO gr_owner;
ALTER TYPE frt_exp_pajamos DROP ATTRIBUTE kategorija;
ALTER TYPE frt_exp_pajamos DROP ATTRIBUTE mb_saskaita;
ALTER TYPE frt_exp_pajamos DROP ATTRIBUTE suma;
ALTER TYPE frt_exp_pajamos DROP ATTRIBUTE pvm_suma;
ALTER TYPE frt_exp_pajamos ADD ATTRIBUTE kategorija integer;
ALTER TYPE frt_exp_pajamos ADD ATTRIBUTE mb_saskaita dmn_saskaita;
ALTER TYPE frt_exp_pajamos ADD ATTRIBUTE suma numeric(10,2) COLLATE ;
ALTER TYPE frt_exp_pajamos ADD ATTRIBUTE pvm_suma numeric(10,2) COLLATE ;
--
Julius Tuskenis
Programavimo skyriaus vadovas
UAB nSoft
mob. +37068233050
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support
