Thread: Explain broken with pg7.3 server

Explain broken with pg7.3 server

From
Matthew Gabeler-Lee
Date:
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

Re: Explain broken with pg7.3 server

From
"Dave Page"
Date:
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

Re: Explain broken with pg7.3 server

From
"Dave Page"
Date:

> -----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.

Re: Explain broken with pg7.3 server

From
Tino Wildenhain
Date:
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

Re: Explain broken with pg7.3 server

From
"Dave Page"
Date:

> -----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.