Thread: Re: [CORE] report a bug

Thomas
    hi, thanks for your help. but the version of what I use is 7.1.3 and 7.2. I try these two version and get the same
result- " OUTER JOIN is not yet supported".  
    I am sorry for the inconvenience to you. but I am so urgent and need your help
thanks and regards
huangming


----- Original Message -----
From: "Thomas Lockhart" <lockhart@fourpalms.org>
To: "Huang Ming" <huangm2000@sina.com.cn>
Cc: <pgsql-core@postgresql.org>
Sent: Friday, December 14, 2001 2:32 PM
Subject: Re: [CORE] report a bug


> >     All of join clause can not be executed in a SQL statement. system
> > throw a exception with the message " OUTER JOIN is not yet supported"
>
> You need to be running a current (7.1.x) version of PostgreSQL. Earlier
> versions did not have outer joins implemented.
>
> btw, the -general or -novice mailing list would be a more appropriate
> place to ask these kinds of questions, since there are more people who
> can help and who know good answers.
>
> Regards.
>
>                   - Thomas
>
>

On Fri, 14 Dec 2001, Huang Ming wrote:

> Thomas
>     hi, thanks for your help. but the version of what I use is 7.1.3
> and 7.2. I try these two version and get the same result - " OUTER
> JOIN is not yet supported".
>     I am sorry for the inconvenience to you. but I am so urgent and
> need your help thanks and regards

We're going to need more information than that because other people
(myself included) use outer joins under both those versions.

"Huang Ming" <huangm2000@sina.com.cn> writes:
>     hi, thanks for your help. but the version of what I use is 7.1.3
>     and 7.2. I try these two version and get the same result - " OUTER
>     JOIN is not yet supported".

I will assert with great confidence that the server you are using is
*not* running 7.1, nor 7.2, but 7.0.  That error message only exists
in 7.0.

You might possibly be using a 7.1 psql, or other client, but the
server you are connecting to is older.

            regards, tom lane