schema.table.column syntax no longer supported?

From: Matthew Bellew <matthewb(at)labkey(dot)com>
To: pgsql-testers(at)postgresql(dot)org
Subject: schema.table.column syntax no longer supported?
Date: 2010-04-15 23:29:49
Message-ID: h2x480de0691004151629m2d42937cs8dace11e4c677c43@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-testers

[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]:

Responses

Browse pgsql-testers by date

  From Date Subject
Next Message Josh Berkus 2010-04-15 23:45:27 Re: schema.table.column syntax no longer supported?
Previous Message Erik Rijkers 2010-04-08 21:37:18 Re: testing HS/SR - performance difference primary vs. standby