thread. NetBSD-current has it though.
Thomas T. Thai
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
> Even dropping the table and all of its indexes and recreating it does
> nothing to solve this problem, so I don't have any reason to suspect
> corruption of the table itself. Corruption elsewhere is a
> possibility, I suppose, but I haven't noticed any strangeness
> elsewhere.
This sounds very
>> On Wed, 2003-03-26 at 20:42, Thomas T. Thai wrote:
> [...]
>>> ERROR: datumGetSize: Invalid typLen 0
>>
>> Works for me:
>>
>> [nconway:/home/nconway]% psql -f bug.sql
>> CREATE TABLE
>> INSERT 287424 1
>> INSERT 28742
Please also note that if you change the data type from text to int, then
the test succeeds:
CREATE TABLE wow_cfgmap (
ts_id int
);
insert into wow_cfgmap values (1);
insert into wow_cfgmap values (2);
CREATE TABLE wow_cfg (
ts_id int
);
insert into wow_cfg values (1);
select
I just tested this on 7.4-snapshot-2003-03-24 and the same error occurred.
The one regression test (opr_sanity) in 7.4-snapshot that failed also had
this error.
ERROR: datumGetSize: Invalid typLen 0
> System: NetBSD / Alpha 1.6 (64 bit)
> Postgresql 7.3.2
>
> Bug: after vacuum analyze, I'm una
After experiencing so many problems with 7.3.2, I decided to test
7.4-snapshot. It failed only on one test, instead of 17.
NetBSD-1.6 / Alpha (64-bit)
Postgresql-7.4-snapshot-2003-03-24
The error I'm getting is:
! ERROR: datumGetSize: Invalid typLen 0
That error caused many problems in 7.3.2
>> On Wed, 2003-03-19 at 20:32, Oleg Bartunov wrote:
>>> On Wed, 19 Mar 2003, Alvaro Herrera wrote:
>>> > stringA||COALESCE(NULL, '')
>>> >
>>>
>>> we don't know in advance if it's NULL or not.
>>
>> Right, that's the point of COALESCE: the first non-NULL argument is
>> returned -- so if the first
> On Wed, 2003-03-19 at 20:32, Oleg Bartunov wrote:
>> On Wed, 19 Mar 2003, Alvaro Herrera wrote:
>> > stringA||COALESCE(NULL, '')
>> >
>>
>> we don't know in advance if it's NULL or not.
>
> Right, that's the point of COALESCE: the first non-NULL argument is
> returned -- so if the first argument
On Fri, 7 Mar 2003, mlw wrote:
I couldn't get to it yesterday either. FTP worked fine though.
--
Thomas T. Thai
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
