On 28 March 2014 11:07, Khangelani Gama <kgama(at)argility(dot)com> wrote:
> Hi Chris or anyone who can help
>
> When I try this just below, it complains about foo (new table created in
> db2) , saying ERROR: schema foo does not exist. I got stuck on this error
> for a while now but still trying to see why but still no luck so far. If you
> have something please help
>
> begin;
>
> update foo
> set br_desc = bar.br_desc
> , br_active = bar.br_active
> (rest of columns)
> where foo.br_cde = bar.br_cde;
Really? I would have expected ERROR: table or schema bar does not exist.
Look up the syntax for UPDATE FROM.