Re: Beta3: Explain gives error where PgAdmin 1.2.2

From: Andreas Pflug <pgadmin(at)pse-consulting(dot)de>
To: Joost Kraaijeveld <J(dot)Kraaijeveld(at)Askesis(dot)nl>
Cc: PgAdmin-support <pgadmin-support(at)postgresql(dot)org>
Subject: Re: Beta3: Explain gives error where PgAdmin 1.2.2
Date: 2005-11-09 11:42:38
Message-ID: 4371E0AE.9040303@pse-consulting.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgadmin-support by date

  From Date Subject
Next Message Andreas Pflug 2005-11-09 11:45:20 Re: Errors using
Previous Message Andreas Pflug 2005-11-09 11:41:35 Re: Graphical Explain