The following bug has been logged online:

Bug reference: 2121
Logged by: Alexis Cedeño Trujillo
Email address: acedeno@ceis.cujae.edu.cu
PostgreSQL version: 8.0 & 8.1.1
Operating system: Windows
Description: Problem with backup and query
Details:

Hello,
We are research`students
By this, we would like to catch The Postgre SQL`technical advisors
attention about a problem occured while using this tool.
These are the facts: while executing a consult, looked as a many to many
relationship between two entities, it didn`t return the
Expected results. Forthermore it generated a bug.
However, after installed all the aditional modules delivred with the
PostgreSQL 8.0 for windows, the consult were functioning goodly but by
generating another problem statement due to the newly features installed:
the incorrect database restore or simply the inability to realize this basic
operation.
We notify that before the aditional features installation, there wasn`t the
database restore problem.
So what can we do to resolve the problem?
By expecting your response,
Thanks.

Alexis Cedeño Trujillo

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

On 12/22/05, Alexis Cedeño Trujillo <acedeno@ceis.cujae.edu.cu> wrote:
>
> The following bug has been logged online:
>
> Bug reference: 2121
> Logged by: Alexis Cedeño Trujillo
> Email address: acedeno@ceis.cujae.edu.cu
> PostgreSQL version: 8.0 & 8.1.1
> Operating system: Windows
> Description: Problem with backup and query
> Details:
>
> Hello,
> We are research`students
> By this, we would like to catch The Postgre SQL`technical advisors
> attention about a problem occured while using this tool.
> These are the facts: while executing a consult, looked as a many to many
> relationship between two entities, it didn`t return the
> Expected results. Forthermore it generated a bug.
> However, after installed all the aditional modules delivred with the
> PostgreSQL 8.0 for windows, the consult were functioning goodly but by
> generating another problem statement due to the newly features installed:
> the incorrect database restore or simply the inability to realize this basic
> operation.
> We notify that before the aditional features installation, there wasn`t the
> database restore problem.
> So what can we do to resolve the problem?
> By expecting your response,
> Thanks.
>
> Alexis Cedeño Trujillo
>

could be a good idea to report the exact problem and not just to say
there was a problem...

you must say what the problem was... what were you doing when
happened... what version of postgres...


--
Atentamente,
Jaime Casanova
(DBA: DataBase Aniquilator

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend