Re: pgAdmin problem with explain - Mailing list pgadmin-support

From Dave Page
Subject Re: pgAdmin problem with explain
Date
Msg-id 03AF4E498C591348A42FC93DEA9661B8128ACA@mail.vale-housing.co.uk
Whole thread Raw
In response to pgAdmin problem with explain  (pginfo <pginfo@t1.unisoftbg.com>)
List pgadmin-support
Can I have the logs please, not just a couple of messages.

Regards, Dave.

> -----Original Message-----
> From: pginfo [mailto:pginfo@t1.unisoftbg.com]
> Sent: 14 October 2002 14:37
> To: Dave Page
> Cc: pgadmin-support@postgresql.org
> Subject: Re: [pgadmin-support] 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_M
> ED_MAIN,N.MED_MAIN,N.OTN_MED,N.CENA,N.VAL,N.KURS,N.CENADDS,N.D
> DS,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,NO
> M.OTN_DOP2_MED,N.DTON
> ,N.OFFIC,N.DATE_IZL,N.IZL,N.OTCH_CENA,N.CENAMITALV,N.CENATAKSI
> LV,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@t1.unisoftbg.com]
> > > Sent: 14 October 2002 14:28
> > > To: pgadmin-support@postgresql.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@postgresql.org so that your
> > message can get through to the mailing list cleanly
>
>
>
>

pgadmin-support by date:

Previous
From: pginfo
Date:
Subject: Re: pgAdmin problem with explain
Next
From: "Erol Oz"
Date:
Subject: Problem with locale