fix for pg_dump (caused by array output syntax changes)

Поиск
Список
Период
Сортировка
От Weiping
Тема fix for pg_dump (caused by array output syntax changes)
Дата
Msg-id 413C8A2D.40705@qmail.zhengmai.net.cn
обсуждение исходный текст
Ответы Re: fix for pg_dump (caused by array output syntax changes)  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Change "recycled transaction log" from LOG to DEBUG1
Следующее
От: Tom Lane
Дата:
Сообщение: Re: fix for pg_dump (caused by array output syntax changes)