BUG #5719: Constraint Problem

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;

Responses

Browse pgsql-bugs by date

  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)