Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-testers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group