protocol differencies

The official tester's forum for ZeosLib 7.1. Ask for help, post proposals or solutions.
zarkadenes
Fresh Boarder
Fresh Boarder
Posts: 1
Joined: 30.11.2013, 23:46

protocol differencies

Postby zarkadenes » 01.12.2013, 00:08

Hi,
What is the difference between protocol:postgresql-8 and postgresql-9?

User avatar
EgonHugeist
Zeos Dev Team
Zeos Dev Team
Posts: 1739
Joined: 31.03.2011, 22:38

Re: protocol differencies

Postby EgonHugeist » 01.12.2013, 21:55

The Name? Actually there are NO behavior changes. Just a hint "we support PG9+".
King regards, Michael

You want to help? viewtopic.php?f=4&t=3671
You found a (possible) bug? Use the new bugtracker dude! http://sourceforge.net/p/zeoslib/tickets/

Image

Wild_Pointer
Expert Boarder
Expert Boarder
Posts: 162
Joined: 18.03.2008, 13:03
Contact:

Re: protocol differencies

Postby Wild_Pointer » 03.12.2013, 10:28

Hello,
EgonHugeist wrote:The Name? Actually there are NO behavior changes. Just a hint "we support PG9+".

Are you sure? For some unknown reason we get range check errors on some computers when using postgresql-8 and they are gone if we use postgres-9... I was unable to reproduce it on my computer, but the problem is reported by some of our clients...

User avatar
EgonHugeist
Zeos Dev Team
Zeos Dev Team
Posts: 1739
Joined: 31.03.2011, 22:38

Re: protocol differencies

Postby EgonHugeist » 03.12.2013, 16:29

@Wild_Pointer

I am. I did not more than adding a clone of generic PostgresPlainDriver with the postgres-9 name.

Code: Select all

constructor TZPostgreSQLDriver.Create;
begin
  inherited Create;
  AddSupportedProtocol(AddPlainDriverToCache(TZPostgreSQL9PlainDriver.Create, 'postgresql'));
  AddSupportedProtocol(AddPlainDriverToCache(TZPostgreSQL7PlainDriver.Create));
  AddSupportedProtocol(AddPlainDriverToCache(TZPostgreSQL8PlainDriver.Create));
  AddSupportedProtocol(AddPlainDriverToCache(TZPostgreSQL9PlainDriver.Create));
end;


and:

Code: Select all

TZPostgreSQL9PlainDriver = class(TZPostgreSQL8PlainDriver)

the only overrides they are differing differ are Name etc. But nothing related. Actually im playing with field types on 7.2. Some behavior changes are to expact just to avoid such cases...

For some unknown reason we get range check errors on some computers when using postgresql-8 and they are gone if we use postgres-9... I was unable to reproduce it on my computer, but the problem is reported by some of our clients...

Uff i trust you. It might be possible this only was fixed becouse of forward developing of Zeos? There are things which do NOT make me happy with postgre:
Decimal and Numeric-Types do NOT have a limitation. Updateing them as string might work because postgres only stores #0 terminated strings (the performance drop against other providers) and reading back could lead to pain. If you can't track origin and there is NO sample .... I can't help.
King regards, Michael

You want to help? viewtopic.php?f=4&t=3671
You found a (possible) bug? Use the new bugtracker dude! http://sourceforge.net/p/zeoslib/tickets/

Image


Return to “ZeosLib 7.1 stable Forum”

Who is online

Users browsing this forum: No registered users and 1 guest