Hi,

Given the query below, running explain beta3 gives me:

"Query inserted one row with OID 0. ERROR:  schema "prototype" does not
exist". 

PgAdmin 1.2.2 does not give an error. The table prototype.orders exists.


update prototype.orders
set amount = odbc.orders.orderbedrag_valuta
from odbc.orders
where
ordernumber = odbc.orders.ordernummer

Is it PgAdmin or my query?


-- 
Groeten,

Joost Kraaijeveld
Askesis B.V.
Molukkenstraat 14
6524NB Nijmegen
tel: 024-3888063 / 06-51855277
fax: 024-3608416
e-mail: [EMAIL PROTECTED]
web: www.askesis.nl 



---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Reply via email to