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

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 1ts_name | ts_name 
---------+---------default | defaultdefault | default
(2 rows)

VACUUMts_name | ts_name 
---------+---------default | defaultdefault | 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