Thread: Beta3: Explain gives error where PgAdmin 1.2.2 does not

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: J.Kraaijeveld@Askesis.nl
web: www.askesis.nl 

Joost Kraaijeveld wrote:
> 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?

Can't tell. Please provide table definitions.

Regards,
Andreas