Subject: bug in copy on indexed tables

From: [email-masked] (Joe Hellerstein)
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>