Thread: 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.
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 >
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@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
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 > > > >