Skip site navigation (1) Skip section navigation (2)

Re: "Official" version

From: "Scot Loach" <sloach(at)sandvine(dot)com>
To: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>, <sfrost(at)snowman(dot)net>
Cc: <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: "Official" version
Date: 2005-08-21 15:02:01
Message-ID: 71837C040963F748B9B94E123A289678664C29@mailserver.sandvine.com (view raw or flat)
Thread:
Lists: pgsql-odbc
I don't have much time - I did have enough time to do a basic run against it though, and it seems to have some problems.
I tried it with a select statement and got this error back when I did a fetch on it.

Null statement result in PGAPI_ExtendedFetch.


-----Original Message-----
From: Dave Page [mailto:dpage(at)vale-housing(dot)co(dot)uk]
Sent: Saturday, August 20, 2005 11:41 AM
To: Scot Loach; dpage(at)vale-housing(dot)co(dot)uk; sfrost(at)snowman(dot)net;
dpage(at)vale-housing(dot)co(dot)uk
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: RE: [ODBC] "Official" version


I've tested declare/fetch a fair bit - it was originally broken by the thread/transactions bug but seems OK now.

Haven't tried server side prepare though. Have you got some time to test it?

/D


-----Original Message-----
From: "Scot Loach"<sloach(at)sandvine(dot)com>
Sent: 20/08/05 13:49:21
To: "Dave Page"<dpage(at)vale-housing(dot)co(dot)uk>, "sfrost(at)snowman(dot)net"<sfrost(at)snowman(dot)net>, "dpage(at)vale-housing(dot)co(dot)uk"<dpage(at)vale-housing(dot)co(dot)uk>
Cc: "pgsql-odbc(at)postgresql(dot)org"<pgsql-odbc(at)postgresql(dot)org>
Subject: RE: [ODBC] "Official" version

Good point on the declare/fetch usage, obviously this needs to be tried before the driver is considered stable.

Same goes for the server-side prepared queries, has anyone tried this feature with the libpq driver?


-----Original Message-----
From:	pgsql-odbc-owner(at)postgresql(dot)org on behalf of Dave Page
Sent:	Sat 8/20/2005 4:35 AM
To:	sfrost(at)snowman(dot)net; dpage(at)vale-housing(dot)co(dot)uk
Cc:	pgsql-odbc(at)postgresql(dot)org
Subject:	Re: [ODBC] "Official" version

That’s odd - much of my testing has been in Access and i'm unaware of any outstanding issues.

Can you provide a minimal pg_dump file containing a table that illustrates the problem please?

/D

-----Original Message-----
From: "Stephen Frost"<sfrost(at)snowman(dot)net>
Sent: 19/08/05 23:11:27
To: "Dave Page"<dpage(at)vale-housing(dot)co(dot)uk>
Cc: "pgsql-odbc(at)postgresql(dot)org"<pgsql-odbc(at)postgresql(dot)org>
Subject: Re: [ODBC] "Official" version

I was playing around with psqlodbclibpq-08_01_0003.zip and seemed to be
having problems in Access with it.  I'd get errors about a failed
command happening inside a transaction and that all commands till the
end of the transaction would be ignored.  Is there a more recent version
of the driver?  This is against an 8.0.3 database.

Never saw this with the older driver.  I got it right off the bat (when
getting the table listing in Access to link to) when I had 
'declare/fetch' on (which I really need...).  When I turned that off I
was able to get past the table list and actually link to a table but
when I tried to open the table that's what I got. :/

I'd really like to get these issues resolved, of course...

	Thanks,

		Stephen



-----Unmodified Original Message-----
* Dave Page (dpage(at)vale-housing(dot)co(dot)uk) wrote:
> I think it's fairly safe to say that the new libpq version of psqlODBC
> is more stable than the previous release versions of the driver, and
> also now offers more features such as SSL, Kerberos authentication (has
> anyone tried this yet?), pgpass files and so on.
> 
> In light of this, I think the libpq version should now take over as the
> official driver, and lose the 'libpq' suffix that was added for testing.
> 
> If anyone has any strong objections, please shriek soon!!

I was playing around with psqlodbclibpq-08_01_0003.zip and seemed to be
having problems in Access with it.  I'd get errors about a failed
command happening inside a transaction and that all commands till the
end of the transaction would be ignored.  Is there a more recent version
of the driver?  This is against an 8.0.3 database.

Never saw this with the older driver.  I got it right off the bat (when
getting the table listing in Access to link to) when I had 
'declare/fetch' on (which I really need...).  When I turned that off I
was able to get past the table list and actually link to a table but
when I tried to open the table that's what I got. :/

I'd really like to get these issues resolved, of course...

	Thanks,

		Stephen

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

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


pgsql-odbc by date

Next:From: Dave PageDate: 2005-08-21 18:59:53
Subject: Re: "Official" version
Previous:From: Scot LoachDate: 2005-08-21 15:00:31
Subject: Re: changed behavior in libpq odbc driver

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group