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: (view raw, whole thread or download thread mbox)
Lists: pgsql-testers
[Release]: 9.0Alpha4
[Test Type]: Application
[Test]: SELECT w/ schema qualified table name
[Platform]: Snow Leopard
[Failure]: comptibility issue, fails under 9.0 works 8.x

  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 (  The
install scripts had dozens of failures of this type under 9.0Alpha4.
INSERT,UPDATE,DELETE had variations on this error message.



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-2017 The PostgreSQL Global Development Group