Re: pg_dump 8.0.3 failing against PostgreSQL 7.3.2

Jochem van Dieten <jochemd@oli.tudelft.nl> writes:
> Tom Lane wrote:
>> Well, that trace makes it look like it's unhappy about the "null::text"
>> in the command, because there is no other typecast in the SELECT target
>> statement.

> Problem database:
>> wedstrijdzeilen=> select * from pg_type where typname in ('unknown','text') order by typname;
>> typname | typnamespace | typowner | typlen | typbyval | typtype | typisdefined | typdelim | typrelid | typelem |
typinput | typoutput  | t 
>> ypalign | typstorage | typnotnull | typbasetype | typtypmod | typndims | typdefaultbin | typdefault
>>
---------+--------------+----------+--------+----------+---------+--------------+----------+----------+---------+-----------+------------+--
>> --------+------------+------------+-------------+-----------+----------+---------------+------------
>> text    |           11 |        1 |     -1 | f        | b       | t            | ,        |        0 |       0 |
textin   | textout    | i 
>> | x          | f          |           0 |        -1 |        0 |               |
>> text    |      7965528 |      152 |      4 | t        | c       | t            | ,        |  8330945 |       0 |
record_in| record_out | i 
>> | p          | f          |           0 |        -1 |        0 |               |

[ light dawns ]  You've created a table named "text", haven't you?

            regards, tom lane