Jochem van Dieten <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
