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 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