Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 9D493632414 for ; Thu, 15 Apr 2010 20:38:04 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 85694-10 for ; Thu, 15 Apr 2010 23:37:53 +0000 (UTC) X-Greylist: delayed 00:08:03.218161 by SQLgrey-1.7.6 Received: from mail-vw0-f46.google.com (mail-vw0-f46.google.com [209.85.212.46]) by mail.postgresql.org (Postfix) with ESMTP id 2C0E26322B5 for ; Thu, 15 Apr 2010 20:37:54 -0300 (ADT) Received: by vws5 with SMTP id 5so502547vws.19 for ; Thu, 15 Apr 2010 16:37:52 -0700 (PDT) MIME-Version: 1.0 Received: by 10.220.159.81 with HTTP; Thu, 15 Apr 2010 16:29:49 -0700 (PDT) Date: Thu, 15 Apr 2010 16:29:49 -0700 Received: by 10.220.4.21 with SMTP id 21mr416534vcp.102.1271374189113; Thu, 15 Apr 2010 16:29:49 -0700 (PDT) Message-ID: Subject: schema.table.column syntax no longer supported? From: Matthew Bellew To: pgsql-testers@postgresql.org Content-Type: text/plain; charset=UTF-8 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.001 tagged_above=-10 required=5 tests=BAYES_40=-0.001 X-Spam-Level: X-Archive-Number: 201004/8 X-Sequence-Number: 78 [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]: