BUG #1200: VACUUM ANALYZE bug

From: "PostgreSQL Bugs List" <pgsql-bugs(at)postgresql(dot)org>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #1200: VACUUM ANALYZE bug
Date: 2004-07-26 17:35:18
Message-ID: 20040726173518.2CE17CF4D38@www.postgresql.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 1200
Logged by: Andr Otero

Email address: andre(at)iee(dot)usp(dot)br

PostgreSQL version: 7.4

Operating system: Debian Linux on Alpha

Description: VACUUM ANALYZE bug

Details:

Before I run the VACUUM ANALYZE command all query that use JOIN command
return the error: ERROR invalid typeLen: 0.
However the data of tables are unbroken.

Example:
create table departaments
( dp-id int,
name varchar(30),
primary key(dp-id) );

create table requests
( rq-id int,
dp-id int references departaments(dp-id),
description varchar(30),
primary key(dp-id) );

insert into departaments values (1,'Informatica');
insert into departaments values (2,'Recurcos Humanos');
insert into departaments values (3,'Compras');
insert into departaments values (4,'Marketing');
insert into departaments values (5,'Diretoria');
insert into departaments values (6,'Ensino');

insert into requests values (1,1,'nothing');
insert into requests values (2,1,'nothing');
insert into requests values (3,2,'nothing');
insert into requests values (4,3'nothing');
insert into requests values (5,4,'nothing');
insert into requests values (6,4'nothing');

select rq-id,name from requests left join departaments on requests.dp-id =
departaments.dp.id;

this result in:
rq-id | name
1 | Informatica
2 | Informatica
3 | Recursos Humanos
4 | Compras
5 | Marketing
6 | Marketing

now execute VACUUM ANALYZE.... the query dont work...

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2004-07-26 18:19:10 Re: BUG #1200: VACUUM ANALYZE bug
Previous Message Michael Meskes 2004-07-26 11:18:52 Re: ecpg -D SYMBOL