Beta3: Explain gives error where PgAdmin 1.2.2 does not

From: Joost Kraaijeveld <J(dot)Kraaijeveld(at)Askesis(dot)nl>
To: PgAdmin-support <pgadmin-support(at)postgresql(dot)org>
Subject: Beta3: Explain gives error where PgAdmin 1.2.2 does not
Date: 2005-11-06 07:10:16
Message-ID: 1131261016.6003.19.camel@Panoramix
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

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(dot)Kraaijeveld(at)Askesis(dot)nl
web: www.askesis.nl

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Joost Kraaijeveld 2005-11-06 08:20:34 Re: [1.4rc1] Can't change column type
Previous Message Joost Kraaijeveld 2005-11-06 06:29:01 Errors using