Thread: pg admin problem
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.
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? > > Many thanks in advance, > Ivan. > > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster >
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... :\