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