Re: pg_dump 8.0.3 failing against PostgreSQL 7.3.2

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: pg_dump 8.0.3 failing against PostgreSQL 7.3.2
Дата
Msg-id 7109.1118153200@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: pg_dump 8.0.3 failing against PostgreSQL 7.3.2  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: pg_dump 8.0.3 failing against PostgreSQL 7.3.2  (Jochem van Dieten <jochemd@oli.tudelft.nl>)
Список pgsql-general
I wrote:
> [ light dawns ]  You've created a table named "text", haven't you?

You need this patch.  Thanks for the report!

            regards, tom lane

Index: pg_dump.c
===================================================================
RCS file: /cvsroot/pgsql/src/bin/pg_dump/pg_dump.c,v
retrieving revision 1.400.4.4
diff -c -r1.400.4.4 pg_dump.c
*** pg_dump.c    30 Apr 2005 08:19:44 -0000    1.400.4.4
--- pg_dump.c    7 Jun 2005 14:01:42 -0000
***************
*** 5115,5121 ****
      {
          appendPQExpBuffer(query,
                            "SELECT proretset, prosrc, probin, "
!                           "null::text as proargnames, "
                            "provolatile, proisstrict, prosecdef, "
                            "(SELECT lanname FROM pg_catalog.pg_language WHERE oid = prolang) as lanname "
                            "FROM pg_catalog.pg_proc "
--- 5115,5121 ----
      {
          appendPQExpBuffer(query,
                            "SELECT proretset, prosrc, probin, "
!                           "null as proargnames, "
                            "provolatile, proisstrict, prosecdef, "
                            "(SELECT lanname FROM pg_catalog.pg_language WHERE oid = prolang) as lanname "
                            "FROM pg_catalog.pg_proc "
***************
*** 5126,5132 ****
      {
          appendPQExpBuffer(query,
                            "SELECT proretset, prosrc, probin, "
!                           "null::text as proargnames, "
           "case when proiscachable then 'i' else 'v' end as provolatile, "
                            "proisstrict, "
                            "'f'::boolean as prosecdef, "
--- 5126,5132 ----
      {
          appendPQExpBuffer(query,
                            "SELECT proretset, prosrc, probin, "
!                           "null as proargnames, "
           "case when proiscachable then 'i' else 'v' end as provolatile, "
                            "proisstrict, "
                            "'f'::boolean as prosecdef, "
***************
*** 5139,5145 ****
      {
          appendPQExpBuffer(query,
                            "SELECT proretset, prosrc, probin, "
!                           "null::text as proargnames, "
           "case when proiscachable then 'i' else 'v' end as provolatile, "
                            "'f'::boolean as proisstrict, "
                            "'f'::boolean as prosecdef, "
--- 5139,5145 ----
      {
          appendPQExpBuffer(query,
                            "SELECT proretset, prosrc, probin, "
!                           "null as proargnames, "
           "case when proiscachable then 'i' else 'v' end as provolatile, "
                            "'f'::boolean as proisstrict, "
                            "'f'::boolean as prosecdef, "

В списке pgsql-general по дате отправления:

Предыдущее
От: Michael Fuhr
Дата:
Сообщение: Re: return two elements
Следующее
От: peter royal
Дата:
Сообщение: locking question - why is this not a deadlock?