The following bug has been logged online: Bug reference: 5719 Logged by: KOTAPATI.KRISHNAIAH Email address: kotapati.kris...@hotmail.com PostgreSQL version: PostgreSQL8.3.1 Operating system: Microsoft Windows [Version 6.1.7600] Description: Constraint Problem Details:
create table kittu1 as select * from kota1; when i use this command ,i got the following details: CREATE TABLE kota1 ( did integer NOT NULL, "name" character varying(40), deptno integer NOT NULL DEFAULT 12, CONSTRAINT kota1_pkey PRIMARY KEY (did) ) WITH (OIDS=FALSE); ALTER TABLE kota1 OWNER TO postgres; CREATE TABLE kittu1 ( did integer, "name" character varying(40), deptno integer ) WITH (OIDS=FALSE); ALTER TABLE kittu OWNER TO postgres; -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs