fix for pg_dump (caused by array output syntax changes) - Mailing list pgsql-patches

From Weiping
Subject fix for pg_dump (caused by array output syntax changes)
Date
Msg-id 413C8A2D.40705@qmail.zhengmai.net.cn
Whole thread Raw
Responses Re: fix for pg_dump (caused by array output syntax changes)  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-patches
don't know if it's too simple, and didn't solved for quite a period of time.
But I still need pg_dump to do my backup, so do a simple(but ugly) hack.
Wish it helps.

regards laser
*** pg_dump.c    2004-09-06 23:52:08.000000000 +0800
--- pg_dump.c.new    2004-09-06 23:55:30.000000000 +0800
***************
*** 1527,1533 ****
      {
          appendPQExpBuffer(query, "SELECT tableoid, oid, nspname, "
                            "(select usename from pg_user where nspowner = usesysid) as usename, "
!                           "nspacl, "
                            "(SELECT spcname FROM pg_tablespace t WHERE t.oid = nsptablespace) AS nsptablespace "
                            "FROM pg_namespace");
      }
--- 1527,1533 ----
      {
          appendPQExpBuffer(query, "SELECT tableoid, oid, nspname, "
                            "(select usename from pg_user where nspowner = usesysid) as usename, "
!                           "nspacl[0:2], "
                            "(SELECT spcname FROM pg_tablespace t WHERE t.oid = nsptablespace) AS nsptablespace "
                            "FROM pg_namespace");
      }
***************
*** 2380,2386 ****
           */
          appendPQExpBuffer(query,
                            "SELECT c.tableoid, c.oid, relname, "
!                           "relacl, relkind, relnamespace, "
                            "(select usename from pg_user where relowner = usesysid) as usename, "
                            "relchecks, reltriggers, "
                            "relhasindex, relhasrules, relhasoids, "
--- 2380,2386 ----
           */
          appendPQExpBuffer(query,
                            "SELECT c.tableoid, c.oid, relname, "
!                           "relacl[0:1], relkind, relnamespace, "
                            "(select usename from pg_user where relowner = usesysid) as usename, "
                            "relchecks, reltriggers, "
                            "relhasindex, relhasrules, relhasoids, "

pgsql-patches by date:

Previous
From: Tom Lane
Date:
Subject: Re: Change "recycled transaction log" from LOG to DEBUG1
Next
From: Tom Lane
Date:
Subject: Re: fix for pg_dump (caused by array output syntax changes)