Re: Reverse engineered Column definition incorrect - Mailing list pgadmin-support

Donald Fraser wrote:

> The reverse engineered code for column definitions if incorrect for 
> DEFAULT values.
> I create table such as:
>  
> REATE TABLE public.tbl_bkgndata
> (
>   id int4 NOT NULL DEFAULT nextval('tbl_bkgndata_id_seq'::text),
> ) WITHOUT OIDS;
>  
> Reverse engineered column definition is:
>  
> ALTER TABLE public.tbl_bkgndata ADD COLUMN id int4;
> ALTER TABLE public.tbl_bkgndata ALTER COLUMN id SET STORAGE PLAIN;
> ALTER TABLE public.tbl_bkgndata ALTER COLUMN id SET NOT NULL;
> ALTER TABLE public.tbl_bkgndata ALTER COLUMN id DEFAULT 
> nextval('tbl_bkgndata_id_seq'::text);
>  
> Last row should read:
> ALTER TABLE public.tbl_bkgndata ALTER COLUMN id SET DEFAULT 
> nextval('tbl_bkgndata_id_seq'::text);
>  
> That is the key word SET is missing.


Fixed in cvs, thanks for reporting.

Regards,
Andreas