The following bug has been logged online:
Bug reference: 1785
Logged by: K.G.Sivaraman
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.0
Operating system: Solaris 8.0
Description:Return code !!!
Details:
I am using TABLE SPACE to create my database.
But when
The following bug has been logged online:
Bug reference: 1784
Logged by: Giacomo G
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.0.3
Operating system: linux kernel 2.6.12.2
Description:"adding missing FROM-clause" when not needed
Details:
If I populate the
On Mon, Jul 25, 2005 at 03:03:54AM +0100, Giacomo G wrote:
> But, when i run the same query with the real name of table in the where
> statement I get this:
>
> test=# select * from foo t0 join bar t1 on ( t0.a = t1.c ) where foo.a = 1;
> NOTICE: adding missing FROM-clause entry for table "foo"
Giacomo G wrote:
But, when i run the same query with the real name of table in the where
statement I get this:
This isn't the "real name" of the table "t0". It is another reference to
table "foo", and as such should either raise an error or arrange to
alter the from-clause to make it valid (
"Giacomo G" <[EMAIL PROTECTED]> writes:
> But, when i run the same query with the real name of table in the where
> statement I get this:
> test=# select * from foo t0 join bar t1 on ( t0.a = t1.c ) where foo.a = 1;
> NOTICE: adding missing FROM-clause entry for table "foo"
That is correct --- t
