schema.table.column syntax no longer supported?

[TEST REPORT]
[Release]: 9.0Alpha4
[Test Type]: Application
[Test]: SELECT w/ schema qualified table name
[Platform]: Snow Leopard
[Parameters]:
[Failure]: comptibility issue, fails under 9.0 works 8.x
[Results]:

create schema S;
create table S.T (x int, y int);
select S.T.* from S.T;

results in this error
ERROR: invalid reference to FROM-clause entry for table "t"

This was hit while trying to install a server (www.labkey.org). The
install scripts had dozens of failures of this type under 9.0Alpha4.
INSERT,UPDATE,DELETE had variations on this error message.

[Comments]:

> This was hit while trying to install a server (www.labkey.org). The
> install scripts had dozens of failures of this type under 9.0Alpha4.
> INSERT,UPDATE,DELETE had variations on this error message.

Thanks, will see if I can replicate.

--
-- Josh Berkus
PostgreSQL Experts Inc.
http://www.pgexperts.com

Josh Berkus wrote:
>> This was hit while trying to install a server (www.labkey.org). The
>> install scripts had dozens of failures of this type under 9.0Alpha4.
>> INSERT,UPDATE,DELETE had variations on this error message.
>
> Thanks, will see if I can replicate.
>

I can replicate this as well with a recent cvs/git build.

CREATE TABLE a(a int4);
CREATE TABLE b(b int4);
UPDATE public.a SET a=1 FROM public.b WHERE public.a.a=public.b.b;

will replicate this issue

It works fine in 8.4

--
Steve Singer
Afilias Canada
Data Services Developer
416-673-1142

Steve,

That's a bug alright. Raising it on -hackers.

--
-- Josh Berkus
PostgreSQL Experts Inc.
http://www.pgexperts.com