Thread: 1.14.0 beta3 type creation problem

1.14.0 beta3 type creation problem

From
Julius Tuskenis
Date:
Hello,

when creating a type containing numeric field I get SQL that is not 
"understood" by my server. The sql generated by the dialog is:

CREATE TYPE taetasgftasdfa AS   (q integer,    qq integer,    qqq numeric(10,4) COLLATE ,    qqqq integer);

OS: WinXp
pgAdmin: 1.14.0 beta3

PostgreSQL 8.3.4 on i686-pc-linux-gnu, compiled by GCC gcc (Gentoo 
4.3.2-r3 p1.6, pie-10.1.5) 4.3.2

Thank You in advance for fixing this. :)

-- 
Julius Tuskenis
Programavimo skyriaus vadovas
UAB nSoft
mob. +37068233050



Re: 1.14.0 beta3 type creation problem

From
Guillaume Lelarge
Date:
On Tue, 2011-07-26 at 09:31 +0300, Julius Tuskenis wrote:
> Hello,
> 
> when creating a type containing numeric field I get SQL that is not 
> "understood" by my server. The sql generated by the dialog is:
> 
> CREATE TYPE taetasgftasdfa AS
>     (q integer,
>      qq integer,
>      qqq numeric(10,4) COLLATE ,
>      qqqq integer);
> 
> OS: WinXp
> pgAdmin: 1.14.0 beta3
> 
> PostgreSQL 8.3.4 on i686-pc-linux-gnu, compiled by GCC gcc (Gentoo 
> 4.3.2-r3 p1.6, pie-10.1.5) 4.3.2
> 
> Thank You in advance for fixing this. :)
> 

You'll be glad to know that it's already fixed. Will be available in
beta 4.


-- 
Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com



Re: 1.14.0 beta3 type creation problem

From
Julius Tuskenis
Date:
> 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