Re: pg_dump 8.0.3 failing against PostgreSQL 7.3.2 - Mailing list pgsql-general
From | Tom Lane |
---|---|
Subject | Re: pg_dump 8.0.3 failing against PostgreSQL 7.3.2 |
Date | |
Msg-id | 7109.1118153200@sss.pgh.pa.us Whole thread Raw |
In response to | Re: pg_dump 8.0.3 failing against PostgreSQL 7.3.2 (Tom Lane <tgl@sss.pgh.pa.us>) |
Responses |
Re: pg_dump 8.0.3 failing against PostgreSQL 7.3.2
|
List | 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 by date: