Won't that result in *everything* being considered a system table?

Doh. Quite right. Well, the 7.0 initdb creates pg_indexes as the last thing it does. (Even though there are higher oids in pg_attribute, pg_rewrite and pg_description.), so how about the attached patch?


Chris

Index: pg_dump.c
===================================================================
RCS file: /projects/cvsroot/pgsql-server/src/bin/pg_dump/pg_dump.c,v
retrieving revision 1.353
diff -c -r1.353 pg_dump.c
*** pg_dump.c   8 Oct 2003 03:52:32 -0000       1.353
--- pg_dump.c   21 Oct 2003 00:44:10 -0000
***************
*** 5876,5882 ****
        int                     last_oid;
  
        res = PQexec(g_conn,
!                         "SELECT oid from pg_database where datname = 'template1'");
        if (res == NULL ||
                PQresultStatus(res) != PGRES_TUPLES_OK)
        {
--- 5876,5882 ----
        int                     last_oid;
  
        res = PQexec(g_conn,
!                         "SELECT oid FROM pg_class WHERE relname='pg_indexes'");
        if (res == NULL ||
                PQresultStatus(res) != PGRES_TUPLES_OK)
        {
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Reply via email to