From: | "KOTAPATI(dot)KRISHNAIAH" <kotapati(dot)krishna(at)hotmail(dot)com> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #5719: Constraint Problem |
Date: | 2010-10-21 09:05:26 |
Message-ID: | 201010210905.o9L95QkF081431@wwwmaster.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 5719
Logged by: KOTAPATI.KRISHNAIAH
Email address: kotapati(dot)krishna(at)hotmail(dot)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;
From | Date | Subject | |
---|---|---|---|
Next Message | Alex Hunsaker | 2010-10-21 18:03:29 | Re: BUG #5719: Constraint Problem |
Previous Message | Tom Lane | 2010-10-20 16:57:16 | Re: BUG #5718: Cannot start postgres (FATAL: invalid cache id: 19) |