Re: Beta3: Explain gives error where PgAdmin 1.2.2

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