From 6fb6b472a53f4bd63dd5f99ebb36b26c8622130c Mon Sep 17 00:00:00 2001 From: Philip Warner Date: Mon, 18 Sep 2000 06:47:46 +0000 Subject: [PATCH] Only retrieve view definition if relation is a view (case statement) --- src/bin/pg_dump/pg_dump.c | 5 ++++- 1 file changed, 4 insertions(+), 1 deletion(-) diff --git a/src/bin/pg_dump/pg_dump.c b/src/bin/pg_dump/pg_dump.c index e14c17cd33..e569542142 100644 --- a/src/bin/pg_dump/pg_dump.c +++ b/src/bin/pg_dump/pg_dump.c @@ -1839,11 +1839,14 @@ getTables(int *numTables, FuncInfo *finfo, int numFuncs) appendPQExpBuffer(query, "SELECT pg_class.oid, relname, relkind, relacl, " "(select usename from pg_user where relowner = usesysid) as usename, " - "relchecks, reltriggers, relhasindex, pg_get_viewdef(relname) as viewdef " + "relchecks, reltriggers, relhasindex, " + "Case When relkind = '%c' then pg_get_viewdef(relname) " + "Else NULL End as viewdef " "from pg_class " "where relname !~ '^pg_' " "and relkind in ('%c', '%c', '%c') " "order by oid", + RELKIND_VIEW, RELKIND_RELATION, RELKIND_SEQUENCE, RELKIND_VIEW); res = PQexec(g_conn, query->data); -- 2.39.5