diff options
| author | Bruce Momjian <bruce@momjian.us> | 2001-07-11 21:53:59 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2001-07-11 21:53:59 +0000 |
| commit | b6564c445e0eed59902d394462be7014f755b294 (patch) | |
| tree | cd13e8ff44e7e6a7f3ff28eea2de98101ea36648 | |
| parent | 75d872aa69da3e6569ba0f57b73bb8f7731d6430 (diff) | |
| download | postgresql-b6564c445e0eed59902d394462be7014f755b294.tar.gz | |
Disable COPY TO/FROM on views.
| -rw-r--r-- | src/backend/commands/copy.c | 6 |
1 files changed, 5 insertions, 1 deletions
diff --git a/src/backend/commands/copy.c b/src/backend/commands/copy.c index 6f0c977c70..e1b85a46ff 100644 --- a/src/backend/commands/copy.c +++ b/src/backend/commands/copy.c @@ -7,7 +7,7 @@ * * * IDENTIFICATION - * $Header: /cvsroot/pgsql/src/backend/commands/copy.c,v 1.139 2001/06/08 21:16:48 petere Exp $ + * $Header: /cvsroot/pgsql/src/backend/commands/copy.c,v 1.140 2001/07/11 21:53:59 momjian Exp $ * *------------------------------------------------------------------------- */ @@ -307,6 +307,8 @@ DoCopy(char *relname, bool binary, bool oids, bool from, bool pipe, { /* 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,6 +332,8 @@ DoCopy(char *relname, bool binary, bool oids, bool from, bool pipe, } 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) |