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

Re: schema.table.column syntax no longer supported?

From: Steve Singer <ssinger(at)ca(dot)afilias(dot)info>
To: Josh Berkus <josh(at)agliodbs(dot)com>
Cc: Matthew Bellew <matthewb(at)labkey(dot)com>, pgsql-testers(at)postgresql(dot)org
Subject: Re: schema.table.column syntax no longer supported?
Date: 2010-04-27 22:04:27
Message-ID: 4BD75F6B.1020202@ca.afilias.info (view raw or flat)
Thread:
Lists: pgsql-testers
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

In response to

Responses

pgsql-testers by date

Next:From: Josh BerkusDate: 2010-04-27 22:29:21
Subject: Re: schema.table.column syntax no longer supported?
Previous:From: Josh BerkusDate: 2010-04-22 22:22:26
Subject: Re: Named parameter notation in Postgresql 9.0

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