Reverse engineered Column definition incorrect for DEFAULT

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.

Responses

Browse pgadmin-hackers by date

  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?

Browse pgadmin-support by date

  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