Re: pgAdmin problem with explain

Hi Dave,

This is the message in log:
SQLExecDirect: EXPLAIN explain select
N.IDS,N.IDS_NUM,N.IDS_SLU,N.IDS_SKLAD,SK.MNAME AS
SKNAME,N.ZAPR,N.NOMNUM,NOM.NUM,N.NOMNAME,NOM.MNAME AS
NOMNAME,N.PART,N.SERIENNUM,N.IZV,N.KOL,N.IDS_MED,N.MED,N.IDS_MED_MAIN,N.MED_MAIN,N.OTN_MED,N.CENA,N.VAL,N.KURS,N.CENADDS,N.DDS,N.CENA_LV,N.CENA_LVDDS,N.TOT,N.DTO,N.PTO,N.ORDER_NUM,N.IDS_DOC2,NOM.OSN_MED,NOM.DOP1_MED,NOM.DOP2_MED,NOM.OTN_DOP1_MED,NOM.OTN_DOP2_MED,N.DTON
,N.OFFIC,N.DATE_IZL,N.IZL,N.OTCH_CENA,N.CENAMITALV,N.CENATAKSILV,N.CENATRANSLV,N.CENA,N.CENAZASTRLV
from A_SKLAD N left outer join A_LOCATION SK ON ( N.IDS_SKLAD=SK.IDS )
left outer join A_NOMEN NOM ON ( N.IDS_NUM = NOM.IDS ) where N.FID = 0 AND
N.IDS_DOC = 'SOF_500' ORDER BY N.ORDER_NUM ;

A Query Execution Plan could not be calculated for the specified SQL query.

Done - 0.21 Secs.
Entering pgAdmin II:frmSQLExplain.Form_Resize()

But I do not understand why pg can not calculate the plan !

Regards,
Ivan.

Dave Page wrote:

> Can you please recreate the error with logging set to Full Debut (under
> Tools -> Options) and sen the logfiles?
>
> Regards, Dave.
>
> > -----Original Message-----
> > From: pginfo [mailto:pginfo(at)t1(dot)unisoftbg(dot)com]
> > Sent: 14 October 2002 14:28
> > To: pgadmin-support(at)postgresql(dot)org
> > Subject: [pgadmin-support] pgAdmin problem with explain
> >
> >
> > Hi all,
> >
> > I am using pd admin ( the latest) on Win98.
> > I will to use "explain" butto, and it works well for a simple
> > query. After I put a complex query ( with many joins) I get
> > this error: "Cold not establish connection to ODBC driver !
> > Error: -1".
> >
> > How can I solve this problem ( I tested it on diferent
> > computers and got
> >
> > the same result) ?
> >
> > Is it possible ( with pg admin0 to start " explain mysquery "
> > and to get
> >
> > the result.
> > I tested it and got only " OK", but not the execution plan.
> > Can I do it with pg admin or by anoder way?
> >
> > Many thanks in advance,
> > Ivan.
> >
> >
> >
> >
> > ---------------------------(end of
> > broadcast)---------------------------
> > TIP 4: Don't 'kill -9' the postmaster
> >
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly