DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:in-reply-to:references:date:message-id:subject:from:to
	:cc:content-type:content-transfer-encoding;
	b=N+6mrVtbpswouUhDpHG33M2KiC+nsgsyiRdcnX4j1VWvjWcrMLDSCkv+T3yfusiqyX
	jQPckMZCa25CKdLKoO085INAj/xz1sODIbeISX2yB3gLEPF6UNgArkebdg3eA8m0TXDR
	uT/aA7PWtNRuL9nJRUwosoPV+sFAdRBdMgZKc=
MIME-Version: 1.0
In-Reply-To: <8AB806D0-91F7-4D31-BB6E-690E4419C770@socialserve.com>
References: <8AB806D0-91F7-4D31-BB6E-690E4419C770@socialserve.com>
Date: Wed, 17 Mar 2010 11:48:06 -0300
Message-ID: <690707f61003170748q3e5a38cfvee438e6efd871726@mail.gmail.com>
Subject: Re: 8.4 versus 8.2 against nonexistent column "name" ...
From: Osvaldo Kussama <osvaldo.kussama@gmail.com>
To: James Robinson <jlrobins@socialserve.com>
Cc: pgsql-sql@postgresql.org
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

2010/3/17 James Robinson <jlrobins@socialserve.com>:
> Can anyone shine a light on why 8.4 behaves surprisingly when being queri=
ed
> for a bogus column "name", but only using qualified table/column referenc=
es.
>
> Here's a sample script:
>
> -----
> create table foo
> (
> =A0 =A0 =A0 =A0id int,
> =A0 =A0 =A0 =A0x int
> );
>
> insert into foo(id, x)
> values
> =A0 =A0 =A0 =A0(1, 23),
> =A0 =A0 =A0 =A0(2, 43),
> =A0 =A0 =A0 =A0(4, 45);
>
> -- Fails on both -- no column named 'name'
> select name from foo;
>
> -- Fails on 8.2, still no 'name' column, but 8.4 succeeds returning whole
> rows.
> select f.name from foo f;
> ----
>
> On 8.2.11, both selects fail:
>
> CREATE TABLE
> INSERT 0 3
> ERROR: =A0column "name" does not exist
> LINE 1: select name from foo;
> =A0 =A0 =A0 =A0 =A0 =A0 =A0^
> ERROR: =A0column f.name does not exist
> LINE 1: select f.name from foo f;
> =A0 =A0 =A0 =A0 =A0 =A0 =A0^
>
>
> On 8.4.2, the first select fails, but the second succeeds, returning whol=
e
> rows wrapped up like tuples:
>
> CREATE TABLE
> INSERT 0 3
> ERROR: =A0column "name" does not exist
> LINE 1: select name from foo;
> =A0 =A0 =A0 =A0 =A0 =A0 =A0^
> =A0name
> --------
> (1,23)
> (2,43)
> (4,45)
> (3 rows)
>
> A quick skim through the 8.3. and 8.4. release notes found nothing
> interesting related to 'name'.
>


See this thread:
http://archives.postgresql.org/pgsql-general/2010-02/msg01035.php

Osvaldo