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