BUG #5719: Constraint Problem - Mailing list pgsql-bugs

The following bug has been logged online:

Bug reference:      5719
Logged by:          KOTAPATI.KRISHNAIAH
Email address:      kotapati.krishna@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;