SEO

A long time a special optimizing strategy was devised to improve
performance on the types of queries generated by ODBC clients. Prior to
key set query optimization (KSQO) the postgres optimizer would choke.
In not so recent versions of the backend server the general optimizer
was improved enough to deprecate KSQO. I guess the ODBC driver has
lagged behind. So, at least your version still sends the SET KSQO
command. I believe you can turn this off somewhere in the driver
configuration dialog. In any case it should be harmless.

David


-----Original Message-----
From: kj subbu [mailto:kjsubbu@hotmail.com]
Sent: Friday, January 21, 2005 9:22 AM
To: pgsql-odbc@postgresql.org
Subject: [ODBC] ksqo is not valid option name

Hi Postgres lovers
I have serious problem in postgresql and odbc
..
i have the below things in my server
redhat linux version : 3.0 (EL)
postgres ver :7.3.6
unix odbc version - 2.2.8

when i test the postgresql databse with isql with odbc dsn name is
connectecd perfectly but not is not disconnectd . at the same time i got
the
error : ksqo is not valid option name

I connect the postgresql server with the help of pgadmin is connected
perfectly with unsupported protocol error.

i dont know y the error is coming and this error on ODBC VERISON OR
POSTGRSQL VERSION


can u help me in this issue



Thanks & Regards
Subbiah K J

__________________________________________________ _______________
Get head hunted by 5000 tech recruiters.
http://www.naukri.com/tieups/tieups.php?othersrcp=534 Post your CV on
Naukri.com.


---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

HI Dave

Thanks for your mail . how to change the default odbc driver version for
connectivity .
i try to access one postgresql db with the help of odbctest with which i
create the odbc dsn name.
its connected with errors driver is not supported . but i try to access the
same db with odbc version 2 iits connected with no errors .

how to change the default odbc driver version

pl help me in this issue

Thanks and RegardS
Subbiah K J



>From: "Dave Hartwig" <daveh@routescape.com>
>To: "kj subbu" <kjsubbu@hotmail.com>, <pgsql-odbc@postgresql.org>
>Subject: Re: [ODBC] ksqo is not valid option name Date: Fri, 21 Jan 2005
>14:28:22 -0500
>
>A long time a special optimizing strategy was devised to improve
>performance on the types of queries generated by ODBC clients. Prior to
>key set query optimization (KSQO) the postgres optimizer would choke.
>In not so recent versions of the backend server the general optimizer
>was improved enough to deprecate KSQO. I guess the ODBC driver has
>lagged behind. So, at least your version still sends the SET KSQO
>command. I believe you can turn this off somewhere in the driver
>configuration dialog. In any case it should be harmless.
>
>David
>
>
>-----Original Message-----
>From: kj subbu [mailto:kjsubbu@hotmail.com]
>Sent: Friday, January 21, 2005 9:22 AM
>To: pgsql-odbc@postgresql.org
>Subject: [ODBC] ksqo is not valid option name
>
>Hi Postgres lovers
> I have serious problem in postgresql and odbc
>.
>i have the below things in my server
>redhat linux version : 3.0 (EL)
>postgres ver :7.3.6
>unix odbc version - 2.2.8
>
>when i test the postgresql databse with isql with odbc dsn name is
>connectecd perfectly but not is not disconnectd . at the same time i got
>the
>error : ksqo is not valid option name
>
>I connect the postgresql server with the help of pgadmin is connected
>perfectly with unsupported protocol error.
>
>i dont know y the error is coming and this error on ODBC VERISON OR
>POSTGRSQL VERSION
>
>
>can u help me in this issue
>
>
>
>Thanks & Regards
>Subbiah K J
>
>_________________________________________________ ________________
>Get head hunted by 5000 tech recruiters.
>http://www.naukri.com/tieups/tieups.php?othersrcp=534 Post your CV on
>Naukri.com.
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
>
>---------------------------(end of broadcast)---------------------------
>TIP 7: don't forget to increase your free space map settings

__________________________________________________ _______________
Connect with 1000s of singles.
http://www.bharatmatrimony.com/cgi-bin/bmclicks1.cgi?74 Receive chat
requests. Instant message Now.


---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend