psqlodbc.git
19 years agoFix server side prepare [Ludek Finstrle] REL-08_01_0102
Dave Page [Wed, 30 Nov 2005 13:41:44 +0000 (13:41 +0000)]
Fix server side prepare [Ludek Finstrle]

19 years agoFix for bug "#1000444 Table names repeated in BDE with usedeclarefetch=1", courtesy...
Dave Page [Mon, 28 Nov 2005 11:01:35 +0000 (11:01 +0000)]
Fix for bug "#1000444 Table names repeated in BDE with usedeclarefetch=1", courtesy of Ludek Finstrle

19 years agoCleanup a bunch of inconsistent PGAPI_ declarations/definitions
Dave Page [Fri, 25 Nov 2005 10:43:25 +0000 (10:43 +0000)]
Cleanup a bunch of inconsistent PGAPI_ declarations/definitions

19 years agoBump version number.
Dave Page [Thu, 24 Nov 2005 12:33:54 +0000 (12:33 +0000)]
Bump version number.

19 years agoMake sure the StringLength is set correctly for SQLGetConnectAttr values that are...
Dave Page [Thu, 24 Nov 2005 11:44:59 +0000 (11:44 +0000)]
Make sure the StringLength is set correctly for SQLGetConnectAttr values that are actually in SQLGetConnectOption

19 years agoCorrect value returned by SQLGetInfo for SQL_CATALOG_LOCATION/SQL_QUALIFIER_LOCATION
Dave Page [Thu, 24 Nov 2005 10:20:09 +0000 (10:20 +0000)]
Correct value returned by SQLGetInfo for SQL_CATALOG_LOCATION/SQL_QUALIFIER_LOCATION

19 years agoAdd installer upgrade script.
Dave Page [Tue, 15 Nov 2005 11:06:14 +0000 (11:06 +0000)]
Add installer upgrade script.

19 years agoDon't include the version number in the Start Menu folder on Windows otherwise you...
Dave Page [Fri, 11 Nov 2005 10:46:16 +0000 (10:46 +0000)]
Don't include the version number in the Start Menu folder on Windows otherwise you end up with duplicates after an upgrade.

19 years agoCorrect a couple of broken filenames.
Dave Page [Fri, 11 Nov 2005 10:01:40 +0000 (10:01 +0000)]
Correct a couple of broken filenames.

19 years agoSeem to have skipped a version. Must stop working after midnight :-( REL-08_01_0101
Dave Page [Thu, 10 Nov 2005 09:44:14 +0000 (09:44 +0000)]
Seem to have skipped a version. Must stop working after midnight :-(

19 years agoVersion number bump
Dave Page [Wed, 9 Nov 2005 15:28:05 +0000 (15:28 +0000)]
Version number bump

19 years agoFix non-declare/fetch mode.
Dave Page [Wed, 9 Nov 2005 15:26:07 +0000 (15:26 +0000)]
Fix non-declare/fetch mode.

19 years agoReturn the error message from libpq on connection failure.
Dave Page [Wed, 9 Nov 2005 09:38:29 +0000 (09:38 +0000)]
Return the error message from libpq on connection failure.

19 years agoCorrect resource compiler options
Dave Page [Wed, 9 Nov 2005 09:38:02 +0000 (09:38 +0000)]
Correct resource compiler options

19 years agoCorrect directory name, per Jeff Bohmer
Dave Page [Tue, 8 Nov 2005 09:13:33 +0000 (09:13 +0000)]
Correct directory name, per Jeff Bohmer

19 years agoPost-release version number bump
Dave Page [Sun, 6 Nov 2005 00:01:59 +0000 (00:01 +0000)]
Post-release version number bump

20 years agoUpdate version number for release. REL-08_01_0100
Dave Page [Sat, 5 Nov 2005 14:04:52 +0000 (14:04 +0000)]
Update version number for release.

20 years agoRemove remaining references to Debian and Red Hat HOWTOs.
Peter Eisentraut [Fri, 4 Nov 2005 19:30:17 +0000 (19:30 +0000)]
Remove remaining references to Debian and Red Hat HOWTOs.

20 years ago1) QR_get_fields() gets called when SC_fetch() is entered. However, the QR
Dave Page [Fri, 4 Nov 2005 15:37:55 +0000 (15:37 +0000)]
1) QR_get_fields() gets called when SC_fetch() is entered. However, the QR
cleanup will free the QResultClass object. And the pointer "coli" is no longer
valid when CI_get_oid() gets called further down.
I have fixed this by calling QR_get_fields() after the first if-statement.

2) This is basically the same "cache" bug: PGAPI_ExtendedFetch() caches the
stored QResultClass object when the function is entered. But after SC_fetch()
was called, the pointer is no longer valid.
I have fixed this by calling SC_get_Curres() again after the call to
SC_fetch().
[Rainer Bauer]

20 years agoIt's C, not C++ Dave :-(
Dave Page [Fri, 4 Nov 2005 15:17:49 +0000 (15:17 +0000)]
It's C, not C++ Dave :-(

20 years agoThe test for self being NULL in QR_Destructor() should be the first statement. Curren...
Dave Page [Fri, 4 Nov 2005 15:03:25 +0000 (15:03 +0000)]
The test for self being NULL in QR_Destructor() should be the first statement. Currently, self->conn is called before the check. [Rainer Bauer]

20 years agoRemove wildly outdated Debian and Red Hat HOWTOs.
Peter Eisentraut [Fri, 4 Nov 2005 10:50:52 +0000 (10:50 +0000)]
Remove wildly outdated Debian and Red Hat HOWTOs.

20 years agoFix declare/fetch memory leak. Now we get a nice flat line :-)
Dave Page [Thu, 3 Nov 2005 22:31:16 +0000 (22:31 +0000)]
Fix declare/fetch memory leak. Now we get a nice flat line :-)

20 years agoAdd a VC++ project file.
Dave Page [Thu, 3 Nov 2005 22:07:17 +0000 (22:07 +0000)]
Add a VC++ project file.

20 years agoRemove (libpq) suffix to the driver name on dialogues etc. Use nicer font on English...
Dave Page [Thu, 3 Nov 2005 13:25:05 +0000 (13:25 +0000)]
Remove (libpq) suffix to the driver name on dialogues etc. Use nicer font on English dialogues per grizzle from Magnus :-).

20 years agoRemove (libpq) suffix to the driver name on dialogues etc.
Dave Page [Thu, 3 Nov 2005 13:11:52 +0000 (13:11 +0000)]
Remove (libpq) suffix to the driver name on dialogues etc.

20 years agoSwitch off echo
Dave Page [Thu, 3 Nov 2005 12:53:09 +0000 (12:53 +0000)]
Switch off echo

20 years agoFix a major memory leak in declare/fetch mode. Ensure that forward only cursors can... REL-08_01_0006
Dave Page [Thu, 3 Nov 2005 12:05:13 +0000 (12:05 +0000)]
Fix a major memory leak in declare/fetch mode. Ensure that forward only cursors can only be used in a forward direction.

20 years agoFix Declare/fetch when used with bound columns.
Dave Page [Wed, 2 Nov 2005 16:29:29 +0000 (16:29 +0000)]
Fix Declare/fetch when used with bound columns.

20 years agoFix typo, per Johann Zuschlag
Dave Page [Wed, 2 Nov 2005 14:49:33 +0000 (14:49 +0000)]
Fix typo, per Johann Zuschlag

20 years agoPrevent setting a connstrout value when the max length is set to zero.
Dave Page [Wed, 2 Nov 2005 10:45:43 +0000 (10:45 +0000)]
Prevent setting a connstrout value when the max length is set to zero.

20 years agoInitial fix for Declare/Fetch option [Anoop, Sivakumar and Vaidhy @ Pervasive]
Dave Page [Mon, 31 Oct 2005 19:57:06 +0000 (19:57 +0000)]
Initial fix for Declare/Fetch option [Anoop, Sivakumar and Vaidhy @ Pervasive]

20 years agoWhen EN_Destructor is called it searches through the connection array
Dave Page [Tue, 25 Oct 2005 07:38:54 +0000 (07:38 +0000)]
When EN_Destructor is called it searches through the connection array
and destroys any connections which belong that environment. Unfortunately
it doesn't NULL out the connection array entry afterwards so a future
call to EN_Destructor can wind up trying to destroy that connection
again if another environment has been allocated at the same address.

Also, shouldn't EN_Destructor hold the CONNS critical section while it
is playing with the connection array?

The attached patch fixes both of these issues and seems to have fixed
the crashes I was observing.
[Tom Hughes]

20 years agoThis patch fixes a potential segfault that can happen if a dbc handle is created...
Dave Page [Tue, 25 Oct 2005 07:35:19 +0000 (07:35 +0000)]
This patch fixes a potential segfault that can happen if a dbc handle is created and then destroyed without attempting a connection.
[Scot Loach]

20 years agoMassive compiler warnings cleanup.
Peter Eisentraut [Thu, 20 Oct 2005 13:06:10 +0000 (13:06 +0000)]
Massive compiler warnings cleanup.

20 years agoUse program files environment var in installer per Johann Zuschlag
Dave Page [Wed, 12 Oct 2005 13:22:13 +0000 (13:22 +0000)]
Use program files environment var in installer per Johann Zuschlag

20 years agoBump version number
Dave Page [Wed, 12 Oct 2005 09:21:08 +0000 (09:21 +0000)]
Bump version number

20 years agoUse program files environment var in Windows makefile per Johann Zuschlag REL-08_01_0005
Dave Page [Wed, 12 Oct 2005 08:15:18 +0000 (08:15 +0000)]
Use program files environment var in Windows makefile per Johann Zuschlag

20 years agoUse pg_config to find libpq.
Peter Eisentraut [Wed, 12 Oct 2005 08:12:30 +0000 (08:12 +0000)]
Use pg_config to find libpq.

20 years agoFix spelling of PostgreSQL.
Peter Eisentraut [Tue, 11 Oct 2005 07:47:11 +0000 (07:47 +0000)]
Fix spelling of PostgreSQL.

20 years agoAdd Kerberos support.
Dave Page [Fri, 7 Oct 2005 09:47:36 +0000 (09:47 +0000)]
Add Kerberos support.
Update paths to use libpq from PostgreSQL 8.1 by default.

20 years agoAdd OpenSSL and MIT Kerberos acknowledgements
Dave Page [Fri, 7 Oct 2005 09:03:34 +0000 (09:03 +0000)]
Add OpenSSL and MIT Kerberos acknowledgements

20 years agoCreate logfiles in mode 0600 on *nix
Dave Page [Thu, 6 Oct 2005 10:01:43 +0000 (10:01 +0000)]
Create logfiles in mode 0600 on *nix

20 years agoDon't reuse the UNICODE macro
Dave Page [Wed, 5 Oct 2005 20:31:40 +0000 (20:31 +0000)]
Don't reuse the UNICODE macro

20 years agoI've attached a patch that uses the SQLSTATE from the backend any time
Dave Page [Tue, 4 Oct 2005 19:03:19 +0000 (19:03 +0000)]
I've attached a patch that uses the SQLSTATE from the backend any time
the error condition after executing a query is
STMT_ERROR_TAKEN_FROM_BACKEND.  Besides solving the problem I reported,
this seems to make much more sense than setting the SQLSTATE arbitrarily
to HY000 "General Error" in this situation.  I look forward to your
feedback.
[Chris Ingram]

20 years agoMap 'name' to SQL_VARCHAR rather than SQL_CHAR - this fixes an error with SQL Server...
Dave Page [Wed, 28 Sep 2005 08:33:24 +0000 (08:33 +0000)]
Map 'name' to SQL_VARCHAR rather than SQL_CHAR - this fixes an error with SQL Server linked servers which gets confused by the mismatch between the column size and the data size.

20 years agoFurther multibyte tweaks from Hiroshi.
Dave Page [Fri, 23 Sep 2005 09:35:58 +0000 (09:35 +0000)]
Further multibyte tweaks from Hiroshi.

20 years agoUpdate multibyte encodings and mappings [Hiroshi Saito]
Dave Page [Wed, 21 Sep 2005 20:26:17 +0000 (20:26 +0000)]
Update multibyte encodings and mappings [Hiroshi Saito]

20 years agoThese files are no longer used by the Libpq version of psqlodbc.
Anoop Kumar [Mon, 19 Sep 2005 13:44:09 +0000 (13:44 +0000)]
These files are no longer used by the Libpq version of psqlodbc.

20 years agoSocket code is removed from the source. Now, psqlodbc driver relies completely on...
Anoop Kumar [Mon, 19 Sep 2005 13:31:59 +0000 (13:31 +0000)]
Socket code is removed from the source.  Now, psqlodbc driver relies completely on Libpq for the communication.

20 years agoDon't lose notices that don't come from a query.
Dave Page [Sat, 17 Sep 2005 22:58:51 +0000 (22:58 +0000)]
Don't lose notices that don't come from a query.

20 years agoThis patch fill fix the notice handler so that the odbc driver doesn't output notices...
Dave Page [Sat, 17 Sep 2005 22:27:24 +0000 (22:27 +0000)]
This patch fill fix the notice handler so that the odbc driver doesn't output notices from the backend to stderr.
[Scot Loach]

20 years agoThis patch corrects the previous fix for returning 08S01 error code for the server...
Dave Page [Sat, 17 Sep 2005 22:16:08 +0000 (22:16 +0000)]
This patch corrects the previous fix for returning 08S01 error code for the server disconnecting.
The previous patch sent this error code for any error on the statement (such as a primary key collision).
[Scot Loach]

20 years agoRemove old doc file.
Dave Page [Fri, 16 Sep 2005 23:12:17 +0000 (23:12 +0000)]
Remove old doc file.

20 years agoBump version number
Dave Page [Fri, 16 Sep 2005 23:10:28 +0000 (23:10 +0000)]
Bump version number

20 years agoDon't include win_unicode.c twice REL-08_01_0004
Dave Page [Fri, 16 Sep 2005 23:05:00 +0000 (23:05 +0000)]
Don't include win_unicode.c twice

20 years agoBackout previous rowcount patch which seems to be causing some odd errors with MS...
Dave Page [Fri, 16 Sep 2005 16:01:43 +0000 (16:01 +0000)]
Backout previous rowcount patch which seems to be causing some odd errors with MS ADO.

20 years agoFix paths for new build targets
Dave Page [Thu, 15 Sep 2005 08:16:55 +0000 (08:16 +0000)]
Fix paths for new build targets

20 years agoAllow SQLRowCount to work following SELECT queries [Scot Loach]
Dave Page [Thu, 15 Sep 2005 08:09:43 +0000 (08:09 +0000)]
Allow SQLRowCount to work following SELECT queries [Scot Loach]

20 years agoFix identifier case sensitivity [Chris Ingram]
Dave Page [Thu, 15 Sep 2005 07:45:44 +0000 (07:45 +0000)]
Fix identifier case sensitivity [Chris Ingram]

20 years agoExplain which driver users should choose.
Dave Page [Tue, 6 Sep 2005 15:19:13 +0000 (15:19 +0000)]
Explain which driver users should choose.

20 years agoRe-enable ANSI/Unicode compilation.
Dave Page [Tue, 6 Sep 2005 07:47:26 +0000 (07:47 +0000)]
Re-enable ANSI/Unicode compilation.

20 years agoRemove unnecessary query length limitation, and clean up so dodgy code.
Dave Page [Fri, 2 Sep 2005 14:31:42 +0000 (14:31 +0000)]
Remove unnecessary query length limitation, and clean up so dodgy code.

20 years agoAdd basic support for savepoints [Hiroshi Saito/Dave Page]
Dave Page [Fri, 2 Sep 2005 08:40:59 +0000 (08:40 +0000)]
Add basic support for savepoints [Hiroshi Saito/Dave Page]

20 years agoOnly mark the connection dead when it actually fails, not for any error.
Dave Page [Thu, 1 Sep 2005 14:45:16 +0000 (14:45 +0000)]
Only mark the connection dead when it actually fails, not for any error.

20 years agoPlease find the patch for the other bug pointed out by Scot. (Thanks to
Dave Page [Wed, 31 Aug 2005 07:31:44 +0000 (07:31 +0000)]
Please find the patch for the other bug pointed out by Scot. (Thanks to
Sivakumar)

"Another difference is the "state" that is returned from SQLGetDiagRec
when a connection is lost during a query.  This used to return 08S01.
It now returns HY000."

20 years agoBloody line ends. Grrr.
Dave Page [Tue, 30 Aug 2005 14:57:50 +0000 (14:57 +0000)]
Bloody line ends. Grrr.

20 years agoFix line ends.
Dave Page [Tue, 30 Aug 2005 11:27:07 +0000 (11:27 +0000)]
Fix line ends.

20 years agoTest commit - ignore
Dave Page [Tue, 30 Aug 2005 10:28:32 +0000 (10:28 +0000)]
Test commit - ignore

20 years agoFix for making the SQLGetConnectAttr API work with SQL_ATTR_CONNECTION_DEAD attribute.
Anoop Kumar [Tue, 30 Aug 2005 09:19:50 +0000 (09:19 +0000)]
Fix for making the SQLGetConnectAttr API work with SQL_ATTR_CONNECTION_DEAD attribute.

20 years agoAllow SSL modes to be translated [Hiroshi Saito]
Dave Page [Tue, 30 Aug 2005 08:37:06 +0000 (08:37 +0000)]
Allow SSL modes to be translated [Hiroshi Saito]

20 years agoDon't install docs by default, as most likely only developers/sysadmins will need...
Dave Page [Sun, 28 Aug 2005 19:43:47 +0000 (19:43 +0000)]
Don't install docs by default, as most likely only developers/sysadmins will need them.

20 years agoUpdate installer:
Dave Page [Sat, 27 Aug 2005 23:19:32 +0000 (23:19 +0000)]
Update installer:
- Install in configurable directories.
- Add documentation, with a shortcut from the start menu.
- Update the banner bitmap.

20 years agoWix got finickity about short filenames.
Dave Page [Sat, 27 Aug 2005 22:16:46 +0000 (22:16 +0000)]
Wix got finickity about short filenames.

20 years agoAdd FAQ.
Dave Page [Sat, 27 Aug 2005 22:00:54 +0000 (22:00 +0000)]
Add FAQ.

20 years agoFurther documentation updates
Dave Page [Sat, 27 Aug 2005 20:14:55 +0000 (20:14 +0000)]
Further documentation updates

20 years agoMove docs into the source tree.
Dave Page [Sat, 27 Aug 2005 19:44:47 +0000 (19:44 +0000)]
Move docs into the source tree.

20 years agoFixed the SQLExecDirec bug which returned SQL_SUCCESS instead of SQL_NO_DATA when...
Anoop Kumar [Wed, 24 Aug 2005 06:09:52 +0000 (06:09 +0000)]
Fixed the SQLExecDirec bug which returned SQL_SUCCESS instead of SQL_NO_DATA when no row got affected in UPDATE/DELETE. (Thanks to Sivakumar)

20 years agoFix SQLRowCount [Anoop Kumar]
Dave Page [Fri, 12 Aug 2005 09:47:55 +0000 (09:47 +0000)]
Fix SQLRowCount [Anoop Kumar]

20 years agoOops, missed this commit
Dave Page [Fri, 12 Aug 2005 09:19:42 +0000 (09:19 +0000)]
Oops, missed this commit

20 years agoFurther column length tweaks
Dave Page [Thu, 11 Aug 2005 15:35:16 +0000 (15:35 +0000)]
Further column length tweaks

20 years agoImprove field length setup. Use the correct values for varchar and char, and SQL_NO_T...
Dave Page [Thu, 11 Aug 2005 14:08:28 +0000 (14:08 +0000)]
Improve field length setup. Use the correct values for varchar and char, and SQL_NO_TOTAL for bytea and text.

20 years agoContrary to what SQLGetInfo thinks, PostgreSQL doesn't support catalog names.
Dave Page [Fri, 5 Aug 2005 15:19:45 +0000 (15:19 +0000)]
Contrary to what SQLGetInfo thinks, PostgreSQL doesn't support catalog names.

20 years agoPost release version number bump
Dave Page [Fri, 5 Aug 2005 12:37:20 +0000 (12:37 +0000)]
Post release version number bump

20 years agoFix default numeric precision.
Dave Page [Fri, 5 Aug 2005 12:19:48 +0000 (12:19 +0000)]
Fix default numeric precision.

20 years agoFix leak in SC_Destructor [Kelly Burkhart] - http://archives.postgresql.org/pgsql...
Dave Page [Thu, 4 Aug 2005 13:39:28 +0000 (13:39 +0000)]
Fix leak in SC_Destructor [Kelly Burkhart] - archives.postgresql.org/pgsql-odbc/2005-03/msg00091.php

20 years agoIf I bind a 32 bit integer using SQL_INTEGER/SQL_C_LONG and pass a value of -1, the...
Dave Page [Thu, 4 Aug 2005 12:26:57 +0000 (12:26 +0000)]
If I bind a 32 bit integer using SQL_INTEGER/SQL_C_LONG and pass a value of -1, the insert fails with an 'integer out of range' error. The reason this happens is the sprintf near line 2658 of convert.c. [Kelly Burkhart]

http://archives.postgresql.org/pgsql-odbc/2005-03/msg00126.php

20 years agoFix per bug ref 1187 [Scot Loach] REL-08_01_0003
Dave Page [Wed, 3 Aug 2005 08:19:28 +0000 (08:19 +0000)]
Fix per bug ref 1187 [Scot Loach]

20 years agoHandle SQL_DATE from ODBC2 apps, per bug report 1292 [ alic <NOSPAM> sokrates.hr]
Dave Page [Wed, 3 Aug 2005 08:09:33 +0000 (08:09 +0000)]
Handle SQL_DATE from ODBC2 apps, per bug report 1292 [ alic <NOSPAM> sokrates.hr]

20 years agoAdd comment about a known leak bug that needs fixing
Dave Page [Wed, 3 Aug 2005 07:27:30 +0000 (07:27 +0000)]
Add comment about a known leak bug that needs fixing

20 years agoFix bug that stopped Use Declare/Fetch working, and prevented ODBC bench running...
Dave Page [Wed, 3 Aug 2005 07:26:01 +0000 (07:26 +0000)]
Fix bug that stopped Use Declare/Fetch working, and prevented ODBC bench running in multi-thread, multi-transaction mode.

20 years agoFix some logging that was bugging me
Dave Page [Wed, 3 Aug 2005 07:24:49 +0000 (07:24 +0000)]
Fix some logging that was bugging me

20 years agoRemove commented out code.
Dave Page [Tue, 2 Aug 2005 13:31:46 +0000 (13:31 +0000)]
Remove commented out code.

20 years agoFix unicode copy & convert bug. SQLGetData with SQL_C_WCHAR now returns SQL_SUCCESS...
Dave Page [Tue, 2 Aug 2005 12:52:03 +0000 (12:52 +0000)]
Fix unicode copy & convert bug. SQLGetData with SQL_C_WCHAR now returns SQL_SUCCESS once the whole string is sent, and doesn't lose odd characters like it did.

20 years agoFix memory leak per gborg bug 1356 [pauldaugherty]
Dave Page [Mon, 1 Aug 2005 20:56:46 +0000 (20:56 +0000)]
Fix memory leak per gborg bug 1356 [pauldaugherty]

20 years agoFix SQL_MAX_IDENTIFIER_LEN per gborg bug ref: 1348
Dave Page [Mon, 1 Aug 2005 20:38:37 +0000 (20:38 +0000)]
Fix SQL_MAX_IDENTIFIER_LEN per gborg bug ref: 1348

20 years agoInclude win_unicode.c in Unix build because it contains functions that are used under...
Dave Page [Mon, 1 Aug 2005 20:17:43 +0000 (20:17 +0000)]
Include win_unicode.c in Unix build because it contains functions that are used under unix.

20 years agoJapanese GUI update from Hiroshi Saito
Dave Page [Wed, 27 Jul 2005 07:36:21 +0000 (07:36 +0000)]
Japanese GUI update from Hiroshi Saito

20 years agoGet proper error messages from the server, rather than just saying the database doesn...
Dave Page [Tue, 26 Jul 2005 09:29:09 +0000 (09:29 +0000)]
Get proper error messages from the server, rather than just saying the database doesn't exist.

20 years agoAdd SSL support.
Dave Page [Mon, 25 Jul 2005 20:38:31 +0000 (20:38 +0000)]
Add SSL support.