Postgres Pro
Downloads
Home   >   mailing lists

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

From Joost Kraaijeveld
Subject Beta3: Explain gives error where PgAdmin 1.2.2 does not
Date
Msg-id 1131261016.6003.19.camel@Panoramix
Whole thread Raw
Responses Re: Beta3: Explain gives error where PgAdmin 1.2.2
List pgadmin-support
Tree view 
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

pgadmin-support by date:

Previous
From: Joost Kraaijeveld
Date:
Subject: Errors using
Next
From: Chris
Date:
Subject: [1.4rc1] Can't rename constraint