Re: Beta3: Explain gives error where PgAdmin 1.2.2 - Mailing list pgadmin-support

From Andreas Pflug
Subject Re: Beta3: Explain gives error where PgAdmin 1.2.2
Date
Msg-id 4371E0AE.9040303@pse-consulting.de
Whole thread Raw
In response to Beta3: Explain gives error where PgAdmin 1.2.2 does not  (Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>)
List pgadmin-support
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


pgadmin-support by date:

Previous
From: Andreas Pflug
Date:
Subject: Re: Graphical Explain
Next
From: Andreas Pflug
Date:
Subject: Re: Errors using