Index: src/backend/commands/copy.c =================================================================== RCS file: /home/projects/pgsql/cvsroot/pgsql/src/backend/commands/copy.c,v retrieving revision 1.139 diff -c -r1.139 copy.c *** src/backend/commands/copy.c 2001/06/08 21:16:48 1.139 --- src/backend/commands/copy.c 2001/07/11 21:50:30 *************** *** 307,312 **** --- 307,314 ---- { /* copy from file to database */ if (rel->rd_rel->relkind == RELKIND_SEQUENCE) elog(ERROR, "You cannot change sequence relation %s", relname); + if (rel->rd_rel->relkind == RELKIND_VIEW) + elog(ERROR, "You cannot copy view %s", relname); if (pipe) { if (IsUnderPostmaster) *************** *** 330,335 **** --- 332,339 ---- } else { /* copy from database to file */ + if (rel->rd_rel->relkind == RELKIND_VIEW) + elog(ERROR, "You cannot copy view %s", relname); if (pipe) { if (IsUnderPostmaster)