Re: 1.14.0 beta3 type creation problem
От | Julius Tuskenis |
---|---|
Тема | Re: 1.14.0 beta3 type creation problem |
Дата | |
Msg-id | 4E2E811C.1020302@nsoft.lt обсуждение исходный текст |
Ответ на | Re: 1.14.0 beta3 type creation problem (Guillaume Lelarge <guillaume@lelarge.info>) |
Список | pgadmin-support |
> 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
В списке pgadmin-support по дате отправления: