Horton
Menu

Re: BUG: Vacuum Analyze - datumGetSize: Invalid typLen 0

Neil Conway <neilc@samurai.com>

View thread
From: Neil Conway <neilc@samurai.com>
To: tom@minnesota.com
Cc: PostgreSQL Hackers <pgsql-hackers@postgresql.org>, teodor@sigaev.ru, oleg@sai.msu.su
Date: 2003-03-27T05:05:51Z
Lists: pgsql-hackers 
On Wed, 2003-03-26 at 20:42, Thomas T. Thai wrote:
> initdb and start postmaster
> %createdb foo
> %psql foo < bug.sql
> CREATE TABLE
> INSERT 16996 1
> INSERT 16997 1
> CREATE TABLE
> INSERT 17003 1
>   ts_name | ts_name
> ---------+---------
>   default | default
>   default | default
> (2 rows)
> 
> VACUUM
> ERROR:  datumGetSize: Invalid typLen 0

Works for me:

[nconway:/home/nconway]% psql -f bug.sql 
CREATE TABLE
INSERT 287424 1
INSERT 287425 1
CREATE TABLE
INSERT 287431 1
 ts_name | ts_name 
---------+---------
 default | default
 default | default
(2 rows)

VACUUM
 ts_name | ts_name 
---------+---------
 default | default
 default | default
(2 rows)

That's on CVS from a couple days ago, loading bug.sql into an
already-existing database. The machine is running Linux on x86 and
PostgreSQL is compiled with gcc 3.2.3.

Not to suggest that the bug doesn't exist -- merely that it appears to
be platform or hardware-dependant.

Cheers,

Neil