From: | André Gomes <andre(at)iee(dot)usp(dot)br> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | VACUUM ANALYZE |
Date: | 2004-07-23 21:03:06 |
Message-ID: | 41017D0A.9010903@iee.usp.br |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Your name : André Gomes Lamas Otero
Your email address : andre(at)iee(dot)usp(dot)br
System Configuration
---------------------
Architecture (example: Intel Pentium) : Alpha
Operating System (example: Linux 2.4.18) : Linux 2.2
PostgreSQL version (example: PostgreSQL-7.4.2): PostgreSQL-7.4.2
Compiler used (example: gcc 2.95.2) : gcc 2.95.4
Please enter a FULL description of your problem:
------------------------------------------------
Befire 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.
Please describe a way to repeat the problem. Please try to provide a
concise reproducible example, if at all possible:
----------------------------------------------------------------------
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...
From | Date | Subject | |
---|---|---|---|
Next Message | Alexander M. Pravking | 2004-07-23 21:56:02 | Function does not see relations within schema it belongs to? |
Previous Message | Peter Eisentraut | 2004-07-23 15:00:21 | Re: reproducible bug in I don't know what component |