Postgres Pro
Downloads
Home   >   mailing lists

Re: Is this a bug? - Mailing list pgsql-sql

From Roland Roberts
Subject Re: Is this a bug?
Date
Msg-id m2ofm4gfxs.fsf@tycho.rlent.pnet
Whole thread Raw
In response to Re: Is this a bug?  ("Jack Gao" <wei@gaofamily.org>)
List pgsql-sql
Tree view 
>>>>> "Jack" == Jack Gao <wei@gaofamily.org> writes:
   Jack> So, I can't use JOIN in UPDATE?

You are trying to update two different tables.  Use a transaction
instead.
   begin transaction;   update foo ....;   update bar ....;   end transaction;

roland
--            PGP Key ID: 66 BC 3B CD
Roland B. Roberts, PhD                             RL Enterprises
roland@rlenter.com                     76-15 113th Street, Apt 3B
roland@astrofoto.org                       Forest Hills, NY 11375

pgsql-sql by date:

Previous
From: "Josh Berkus"
Date:
Subject: Re: handling exceptions, really not simple... :-((
Next
From: Roland Roberts
Date:
Subject: Re: Help with INSERT into 2 tables