Return-Path: joey
Received: by postgres.Berkeley.EDU (5.61/1.29)
	id AA01804; Wed, 15 Jan 92 14:02:01 -0800
Message-Id: <9201152202.AA01804@postgres.Berkeley.EDU>
From: joey@postgres.Berkeley.EDU (Joe Hellerstein)
Subject: bug in copy on indexed tables
To: postgres@postgres.berkeley.edu
Sender: pg_adm@postgres.berkeley.edu
Date: Wed, 15 Jan 92 14:02:30 PST

It seems that copy from does not work on tables which have indices.
Here's a script:

(joey@eden).../bin 140> monitor -q
monitor -q
* create no_ix (num = int4, val = int4)\g
create no_ix (num = int4, val = int4)\g
CREATE
* create has_ix (num = int4, val = int4)\g
create has_ix (num = int4, val = int4)\g
CREATE
* define index ix on has_ix using btree (num int4_ops)\g
define index ix on has_ix using btree (num int4_ops)\g
DEFINE
* copy no_ix from "/users/joey/pg/bin/joedata"\g
copy no_ix from "/users/joey/pg/bin/joedata"\g
COPY
* copy has_ix from "/users/joey/pg/bin/joedata"\g
copy has_ix from "/users/joey/pg/bin/joedata"\g
Error: No response from the backend, exiting...

(joey@eden).../bin 141>