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
Show quoted text
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
Import Notes
Reference msg id not found: 000a01c183d7$aed88fc0$3264a8c0@hm.comReference msg id not found: 3C199CE8.F9F8ED8E@fourpalms.org
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