From: | "Donald Fraser" <demolish(at)cwgsy(dot)net> |
---|---|
To: | "[pgADMIN]" <pgadmin-support(at)postgresql(dot)org> |
Subject: | Reverse engineered Column definition incorrect for DEFAULT |
Date: | 2003-10-02 15:07:45 |
Message-ID: | 011701c388f6$f2226aa0$1664a8c0@DEMOLITION |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-hackers pgadmin-support |
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.
Regards
Donald Fraser.
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2003-10-02 15:09:46 | Re: wxWindows Upgrade |
Previous Message | Hiroshi Saito | 2003-10-02 15:01:58 | Re: gcc ignoring defined macros? |
From | Date | Subject | |
---|---|---|---|
Next Message | Hiroshi Saito | 2003-10-02 16:51:51 | Re: [pgadmin-support] Reverse engineered Column definition incorrect for DEFAULT |
Previous Message | Andreas Pflug | 2003-10-01 20:23:11 | Re: bit length not correct in pgAdmin III 1.0 |