Thread: Just as an FYI We are up solid now on pgsql libpq version

---

From: pgsql-odbc-owner@postgresql.org [mailto:pgsql-odbc-owner@postgresql.org] On Behalf Of Joel Fradkin
Sent: 04 October 2005 23:27
To: pgsql-odbc@postgresql.org
Subject: [ODBC] Just as an FYI We are up solid now on pgsql libpq version

Hi Dave, 

 

Hi Joel,

 

Thought I would give you an update.

We have been up solid. I built the version we are using just prior to your separating aschii and non aschii (so it’s the non aschii version).

I have not seen any odbc related issues. I am still using the 7.4 non libpq version with my DTS dumps from SQL server, but our production web servers have been working great on 8.0.3 postgres.

 

Excellent news - hopefully you boss is somewhat happier now as well :-)

It might be worth trying the very latest CVS code with your DTS packages - there's at least one fix in there specifically for a SQL Server problem, plus the ANSI build of the driver is much more akin to the 7,4 series.

 

I have heard the 8.1 is supposed to be faster and will look at converting to it at some time in the future, but since the speed has been great and the reliability has been great I am almost afraid to touch anything.

 

I would consider upgrading to 8.0.4 which is just out (and is a simple upgrade to 8.0.3 with no dump/reload), but hold off on 8.1 until you have good reason to upgrade. It seems unwise to upgrade a stable system just because you *might* gain a few seconds on the odd query.

 

My thanks go out again to all the wonderful folks on list that helped me resolve the issues.

 

No problem - glad to help. Thanks for bearing with us whilst we brought the new driver up to speed!

Regards, Dave.

"Dave Page" <dpage@vale-housing.co.uk> writes:
> [mailto:pgsql-odbc-owner@postgresql.org] On Behalf Of Joel Fradkin
>>     We have been up solid. I built the version we are using just
>> prior to your separating aschii and non aschii (so it's the non aschii
>> version).

> Excellent news - hopefully you boss is somewhat happier now as well :-)

> It might be worth trying the very latest CVS code with your DTS packages
> - there's at least one fix in there specifically for a SQL Server
> problem, plus the ANSI build of the driver is much more akin to the 7,4
> series.

Seems like it's about time to consider sticking the new version into
Fedora.  I can't use a CVS pull for that, though; I have to have a
traceable tarball.  Are you planning to make a release soon?

            regards, tom lane

> -----Original Message-----
> From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
> Sent: 05 October 2005 18:55
> To: Dave Page
> Cc: pgsql-odbc@postgresql.org
> Subject: Re: [ODBC] Just as an FYI We are up solid now on
> pgsql libpq version
>
> Seems like it's about time to consider sticking the new version into
> Fedora.  I can't use a CVS pull for that, though; I have to have a
> traceable tarball.  Are you planning to make a release soon?

Yes. There's only one bug that I consider a show stopper at the moment -
in declare/fetch mode, the driver fails to retrieve the second and
subsequent blocks of rows, effectively limiting the resultset size to
the cache size. Anoop and Sivakumar are working on this at the moment.

Do you have any deadlines to work to? I'm certainly hoping the fix will
be in place in plenty of time for release with pgInstaller 8.1.

Regards, Dave.

"Dave Page" <dpage@vale-housing.co.uk> writes:
> From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
>> Seems like it's about time to consider sticking the new version into
>> Fedora.  I can't use a CVS pull for that, though; I have to have a
>> traceable tarball.  Are you planning to make a release soon?

> Do you have any deadlines to work to?

Yeah, I'd like it in place before the end of October.  After that,
I'd probably have to negotiate to get it into Fedora Core 5.

(I'm hoping PG 8.1 is done, or at least RC status, by the end of the
month too...)

            regards, tom lane