From: | Julius Tuskenis <julius(at)nsoft(dot)lt> |
---|---|
To: | pgadmin-support(at)postgresql(dot)org |
Subject: | Re: 1.14.0 beta3 type creation problem |
Date: | 2011-07-26 08:55:56 |
Message-ID: | 4E2E811C.1020302@nsoft.lt |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Mamatha_Kagathi_Chan | 2011-08-04 12:11:38 | Re: Query regarding Infinite Cache |
Previous Message | Guillaume Lelarge | 2011-07-26 07:48:50 | Re: 1.14.0 beta3 type creation problem |