Thread: Explain broken with pg7.3 server
When I use the explain button in pgadmin2 1.4.2 with a postgresql 7.3 server, I only get the top line from the plan. 7.3 looks like it returns plans as multiple line result sets, instead of a big notice. -Matt
Arrgghh I hate when that happens. This was about the first 7.3 update that was done *way* before 7.3 was stable. The code in PostgreSQL must have been changed :-(. I'll look into a fix. Regards, Dave. > -----Original Message----- > From: Matthew Gabeler-Lee [mailto:mgabelerlee@zycos.com] > Sent: 06 December 2002 20:24 > To: pgadmin-support@postgresql.org > Subject: [pgadmin-support] Explain broken with pg7.3 server > > > When I use the explain button in pgadmin2 1.4.2 with a > postgresql 7.3 server, I only get the top line from the plan. > 7.3 looks like it returns plans as multiple line result > sets, instead of a big notice. > > -Matt > > ---------------------------(end of > broadcast)--------------------------- > TIP 6: Have you searched our list archives? > http://archives.postgresql.org
> -----Original Message----- > From: Matthew Gabeler-Lee [mailto:mgabelerlee@zycos.com] > Sent: 06 December 2002 20:24 > To: pgadmin-support@postgresql.org > Subject: [pgadmin-support] Explain broken with pg7.3 server > > > When I use the explain button in pgadmin2 1.4.2 with a > postgresql 7.3 server, I only get the top line from the plan. > 7.3 looks like it returns plans as multiple line result > sets, instead of a big notice. I've just committed changes to fix this to CVS. If you want to try a snapshot build, you can download a tarball from the binaries directory on http://cvs.pgadmin.org/. Installation instructions are in the readme. Regards, Dave.
Hi Dave, --On Freitag, 6. Dezember 2002 21:45 +0000 Dave Page <dpage@vale-housing.co.uk> wrote: > Arrgghh I hate when that happens. This was about the first 7.3 update > that was done *way* before 7.3 was stable. The code in PostgreSQL must > have been changed :-(. I'm sorry Dave, I should have mentioned it already because this was also the case with the early betas of 7.3 ;( I was so happy with the output of explain (if you type it in, so I didnt recognice the button did not work ;) Regards Tino
> -----Original Message----- > From: Tino Wildenhain [mailto:tino@wildenhain.de] > Sent: 06 December 2002 23:40 > To: Dave Page; Matthew Gabeler-Lee; pgadmin-support@postgresql.org > Subject: Re: [pgadmin-support] Explain broken with pg7.3 server > > > Hi Dave, > > --On Freitag, 6. Dezember 2002 21:45 +0000 Dave Page > <dpage@vale-housing.co.uk> wrote: > > > Arrgghh I hate when that happens. This was about the first > 7.3 update > > that was done *way* before 7.3 was stable. The code in > PostgreSQL must > > have been changed :-(. > > I'm sorry Dave, I should have mentioned it already because > this was also the case with the early betas of 7.3 ;( Never mind, we got it now :-) Regards, Dave.