Re: COPY TO looses on view

>
> Thank _you_.
>
> I didn't see anything in the documentation under COPY TO that
> indicated it should not work with views.  Since you say it should
> raise and error, the documentation should probably be updated too.
>
> -Steve Pothier-
>
>    Date: Thu, 28 Jun 2001 10:56:29 -0400
>    From: Tom Lane <tgl@sss.pgh.pa.us>
>    Cc: pgsql-bugs@postgresql.org
>
>    Steve Pothier <pothiers@aries.tucson.saic.com> writes:
>    > I created a simple view from an existing table.  I can select on the
>    > view ok but COPY TO "does nothing" (no error, no output).
>
>    It should raise an error.  Thanks for pointing that out.

OK, the following patch throws an error if you try to COPY TO/FROM
views.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026
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)