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

From Hiroshi Saito
Subject Re: [pgadmin-support] Reverse engineered Column definition incorrect for DEFAULT
Date
Msg-id 087201c38905$7aa45e20$1f324d80@w2k
Whole thread Raw
List pgadmin-hackers
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

pgadmin-hackers by date:

Previous
From: "Dave Page"
Date:
Subject: Re: wxWindows Upgrade]
Next
From: "Hiroshi Saito"
Date:
Subject: Re: gcc ignoring defined macros?