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

Re: ksqo is not valid option name

--- kj subbu wrote:

> 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

This error will not interrupt your connection, or
anything else, it is really a warning. It refers to
an option that was removed from the psqlodbc driver
some time ago, which suggests that you are using an
old version of the driver. That may or may not matter
for you.

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




__________________________________
Do you Yahoo!?
Yahoo! Mail - Helps protect you from nasty viruses.
http://promotions.yahoo.com/new_mail

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

Re: ksqo is not valid option name

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]=20
Sent: Friday, January 21, 2005 9:22 AM
To: pgsql-odbc@postgresql.org
Subject: [ODBC] ksqo is not valid option name=20

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=20
connectecd perfectly but not is not disconnectd . at the same time i got
the=20
error : ksqo is not valid option name

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

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


can u help me in this issue



Thanks & Regards
Subbiah K J

____________________________________________________________ _____
Get head hunted by 5000 tech recruiters.=20
http://www.naukri.com/tieups/tieups.php?othersrcp=3D534 Post your CV on=20
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

Re: ksqo is not valid option name

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"
>To: "kj subbu" ,
>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