Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

Next:From: Alex HunsakerDate: 2010-10-21 18:03:29
Subject: Re: BUG #5719: Constraint Problem
Previous:From: Tom LaneDate: 2010-10-20 16:57:16
Subject: Re: BUG #5718: Cannot start postgres (FATAL: invalid cache id: 19)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group