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, "
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Reply via email to