Re: BUG: Vacuum Analyze - datumGetSize: Invalid typLen 0 - Mailing list pgsql-hackers

From Neil Conway
Subject Re: BUG: Vacuum Analyze - datumGetSize: Invalid typLen 0
Date
Msg-id 1048741551.363.4.camel@tokyo
Whole thread Raw
In response to BUG: Vacuum Analyze - datumGetSize: Invalid typLen 0  ("Thomas T. Thai" <tom@minnesota.com>)
Responses Re: BUG: Vacuum Analyze - datumGetSize: Invalid typLen 0  ("Tom" <tom@minnesota.com>)
Re: BUG: Vacuum Analyze - datumGetSize: Invalid typLen 0  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 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



pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: updateable cursors & visibility
Next
From: "Tom"
Date:
Subject: Re: BUG: Vacuum Analyze - datumGetSize: Invalid typLen 0