Thread: Re: [pgadmin-support] Reverse engineered Column definition incorrect for DEFAULT

Re: [pgadmin-support] Reverse engineered Column definition incorrect for DEFAULT

From
"Hiroshi Saito"
Date:
Dear Donald.

Thank you very much.
It will be reflected soon.

Dave Apply it?

----- Original Message -----
From: Donald Fraser

> The reverse engineered code for column definitions if incorrect for DEFAULT values.
> I create table such as:

(snip)
> 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.

Attachment