Unix Technical Forum

Protocol 6.4 -> 7.4

This is a discussion on Protocol 6.4 -> 7.4 within the pgsql Interfaces odbc forums, part of the PostgreSQL category; --> Hi, I was using ODBC with protocol set as 6.4, but the problem was when an error occurs: the ...


Go Back   Unix Technical Forum > Database Server Software > PostgreSQL > pgsql Interfaces odbc

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-16-2008, 03:00 AM
Renato Gondim
 
Posts: n/a
Default Protocol 6.4 -> 7.4

Hi,
I was using ODBC with protocol set as 6.4, but the problem was when an error
occurs: the same code was returned for all kind of errors. After some tests,
I changed to protocol 7.4 and the problem was solved.
My question is: what could have changed with the use of protocol 7.4,
besides the error code? I've already done some tests on the statements, but
I'd like to know what to care for.

Thanks in advance,

Renato.


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

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 04-16-2008, 03:00 AM
Hiroshi Inoue
 
Posts: n/a
Default Re: Protocol 6.4 -> 7.4

Renato Gondim wrote:
> Hi,
> I was using ODBC with protocol set as 6.4, but the problem was when an error
> occurs: the same code was returned for all kind of errors. After some tests,
> I changed to protocol 7.4 and the problem was solved.
> My question is: what could have changed with the use of protocol 7.4,
> besides the error code? I've already done some tests on the statements, but
> I'd like to know what to care for.
>


By checking 7.4+ the driver would use FE/BE Protocol 3.

regards,
Hiroshi Inoue

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 04:58 PM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com