pg admin problem

Started by pginfoover 23 years ago3 messagesgeneral
Jump to latest
#1pginfo
pginfo@t1.unisoftbg.com

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.

#2frbn
frbn@efbs-seafrigo.fr
In reply to: pginfo (#1)
Re: pg admin problem

pginfo wrote:

Show quoted text

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

#3frbn
frbn@efbs-seafrigo.fr
In reply to: pginfo (#1)
Re: pg admin problem

pginfo wrote:

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?

use putty: http://people.nl.linux.org/~bjs/putty/download.html
to connect to your server and do it in the psql client.

ps: sorry for the dup... :\