| 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: | Whole Thread | Raw Message | 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 |