diff options
| author | Philip Warner <pjw@rhyme.com.au> | 2000-09-18 06:47:46 +0000 |
|---|---|---|
| committer | Philip Warner <pjw@rhyme.com.au> | 2000-09-18 06:47:46 +0000 |
| commit | 7cce011178f9bccd2cc8700440e252d96cc4622b (patch) | |
| tree | c0d721b4bdeeb890866635b982a72782b6afddac /src | |
| parent | 565afb889d00fc11850d2590670a99d4eb972ace (diff) | |
| download | postgresql-7cce011178f9bccd2cc8700440e252d96cc4622b.tar.gz postgresql-7cce011178f9bccd2cc8700440e252d96cc4622b.zip | |
Only retrieve view definition if relation is a view (case statement)
Diffstat (limited to 'src')
| -rw-r--r-- | src/bin/pg_dump/pg_dump.c | 7 |
1 files changed, 5 insertions, 2 deletions
diff --git a/src/bin/pg_dump/pg_dump.c b/src/bin/pg_dump/pg_dump.c index a196e17a0cd..99358b3570b 100644 --- a/src/bin/pg_dump/pg_dump.c +++ b/src/bin/pg_dump/pg_dump.c @@ -22,7 +22,7 @@ * * * IDENTIFICATION - * $Header: /cvsroot/pgsql/src/bin/pg_dump/pg_dump.c,v 1.167 2000/09/18 03:24:03 pjw Exp $ + * $Header: /cvsroot/pgsql/src/bin/pg_dump/pg_dump.c,v 1.168 2000/09/18 06:47:46 pjw Exp $ * * Modifications - 6/10/96 - dave@bensoft.com - version 1.13.dhb * @@ -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); |