pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Jack Gao <weigao@hotmail.com>
To: pgsql-sql@postgresql.org
Subject: Re: Is this a bug?
Date: Thu, 15 Nov 2001 09:50:00 -0800
Message-ID: <9t0v84$25ni$1@news.tht.net> (raw)
References: <m2ofm4gfxs.fsf@tycho.rlent.pnet>


"Roland Roberts" <roland@astrofoto.org> wrote in message
news:m2ofm4gfxs.fsf@tycho.rlent.pnet...
> >>>>> "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

No, I just need to update one table, which is tblUserConfig.

> --
>        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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org





view thread (7+ messages)

Message-ID: <9t0v84$25ni$1@news.tht.net>
Permalink:  ../9t0v84$25ni$1@news.tht.net/
Also on:    postgresql.org/message-id/9t0v84$25ni$1@news.tht.net

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: weigao@hotmail.com
  Subject: Re: Is this a bug?
  In-Reply-To: <9t0v84$25ni$1@news.tht.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox