psqlodbc.git
22 years agoChange the macro ATOI64U to mean strtoull under unix(my fault).
Hiroshi Inoue [Mon, 24 Feb 2003 01:06:32 +0000 (01:06 +0000)]
Change the macro ATOI64U to mean strtoull under unix(my fault).

22 years ago1) Handle SQL_C_CHAR under Unicode driver.
Hiroshi Inoue [Tue, 11 Feb 2003 16:57:50 +0000 (16:57 +0000)]
1) Handle SQL_C_CHAR under Unicode driver.
2) Improve ? SQLSpecialColumns for views.

22 years agoAdd extra 2 digits to the precision of floating numbers.
Hiroshi Inoue [Tue, 11 Feb 2003 08:27:29 +0000 (08:27 +0000)]
Add extra 2 digits to the precision of floating numbers.

22 years agoFix a bug in parse_statement reported by Ocke Janssen <Ocke.Janssen@sun.com>.
Hiroshi Inoue [Tue, 11 Feb 2003 00:38:38 +0000 (00:38 +0000)]
Fix a bug in parse_statement reported by Ocke Janssen <Ocke.Janssen@sun.com>.

22 years agoIntroduce the bigint support under *nix.
Hiroshi Inoue [Tue, 11 Feb 2003 00:08:53 +0000 (00:08 +0000)]
Introduce the bigint support under *nix.

22 years agoHandle the TableType parameter of SQLTables() as case insensitive.
Hiroshi Inoue [Mon, 10 Feb 2003 15:13:45 +0000 (15:13 +0000)]
Handle the TableType parameter of SQLTables() as case insensitive.

22 years agoWhere char may contain a negative value, it should explicitly be
Hiroshi Inoue [Mon, 10 Feb 2003 04:34:49 +0000 (04:34 +0000)]
Where char may contain a negative value, it should explicitly be
declared as signed char (Oliver Elphick).

22 years agoDeprecate ODBC2.X functions for the ODBC 3 driver.
Hiroshi Inoue [Wed, 5 Feb 2003 01:21:01 +0000 (01:21 +0000)]
Deprecate ODBC2.X functions for the ODBC 3 driver.

22 years agoFix a bug about multibyte check.
Hiroshi Inoue [Mon, 3 Feb 2003 03:10:44 +0000 (03:10 +0000)]
Fix a bug about multibyte check.

22 years agoInclude the Windows file setup.c in the tarball per suggestion from Andreas Pflug
Dave Page [Mon, 27 Jan 2003 10:35:33 +0000 (10:35 +0000)]
Include the Windows file setup.c in the tarball per suggestion from Andreas Pflug

22 years agoNote that windows users shouldn't include md5.c in their projects per suggestion...
Dave Page [Mon, 27 Jan 2003 10:34:56 +0000 (10:34 +0000)]
Note that windows users shouldn't include md5.c in their projects per suggestion from Andreas Pflug

22 years agoFix foreign key sytnax bug, patch from Wes Griffin.
Bruce Momjian [Wed, 8 Jan 2003 14:56:12 +0000 (14:56 +0000)]
Fix foreign key sytnax bug, patch from Wes Griffin.

22 years agoCreate two aliases for pg_namespace, and clarify some of the alias tags.
Bruce Momjian [Fri, 3 Jan 2003 21:17:59 +0000 (21:17 +0000)]
Create two aliases for pg_namespace, and clarify some of the alias tags.

22 years agoPut back the MAX_INFO_STRING value.
Hiroshi Inoue [Fri, 3 Jan 2003 16:08:14 +0000 (16:08 +0000)]
Put back the MAX_INFO_STRING value.

22 years agoFor the ODBC driver psqlodbc.dll version 7.02.0003 there is an error in
Bruce Momjian [Thu, 2 Jan 2003 22:30:13 +0000 (22:30 +0000)]
For the ODBC driver psqlodbc.dll version 7.02.0003 there is an error in
the info.c.  In 2 places the SQL contains an alias in the FROM clause
for the pg_namespace table and then references the table in the where
clause.  The below cut from the info.c file should replace all instances
on pg_namespace. in the where clause with pn.

Additional cleanups of adding pg_namespace in FROM when referenced in
WHERE.

Jim Holliday

22 years agoSafely fix buffer overrun in PGAPI_GetInfo with strings like:
Dave Page [Thu, 2 Jan 2003 15:33:19 +0000 (15:33 +0000)]
Safely fix buffer overrun in PGAPI_GetInfo with strings like:

07.02.0005 PostgreSQL 7.3 on i386-redhat-linux-gnu, compiled by GCC i386-redhat-linux-gcc (GCC) 3.2.1 20021207 (Red Hat Linux 8.0 3.2.1-2)

See https://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=80394 for more details.

22 years agoIncrease MAX_INFO_STRING to 256 to avoid errors with long info strings such as:
Dave Page [Thu, 2 Jan 2003 11:45:41 +0000 (11:45 +0000)]
Increase MAX_INFO_STRING to 256 to avoid errors with long info strings such as:

07.02.0005 PostgreSQL 7.3 on i386-redhat-linux-gnu, compiled by GCC i386-redhat-linux-gcc (GCC) 3.2.1 20021207 (Red Hat Linux 8.0 3.2.1-2)

See https://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=80394 for more details.

22 years agoThe preparation of ODBC3 support under *nix.
Hiroshi Inoue [Tue, 31 Dec 2002 00:28:25 +0000 (00:28 +0000)]
The preparation of ODBC3 support under *nix.

22 years ago1) Removed a strange error message for the SQLPrepare(.., "", SQL_NTS)
Hiroshi Inoue [Sat, 28 Dec 2002 00:21:01 +0000 (00:21 +0000)]
1) Removed a strange error message for the SQLPrepare(.., "", SQL_NTS)
   statements.
2) Check the range of RecNumber parameter for SQLS(G)etDescField
   more strictly.
Both were pointed out by Han zhouhanok@vip.sina.com.

22 years agoChange SQLFreeStmt(.., SQL_CLOSE) to not DEALLOCATE prepared statements.
Hiroshi Inoue [Fri, 20 Dec 2002 08:30:04 +0000 (08:30 +0000)]
Change SQLFreeStmt(.., SQL_CLOSE) to not DEALLOCATE prepared statements.

22 years agoAdd a new *Server side prepare* option.
Hiroshi Inoue [Tue, 17 Dec 2002 14:38:23 +0000 (14:38 +0000)]
Add a new *Server side prepare* option.

22 years ago1) Separate APD and IPD more explicitly.
Hiroshi Inoue [Mon, 16 Dec 2002 15:01:34 +0000 (15:01 +0000)]
1) Separate APD and IPD more explicitly.
2) Add a conversion functionality between SQL_C_CHAR
   and SQL_VARBINARY.
3) The first cut of the use of server side prepare.
4) Check if a relation is a view more precisely.
5) Fix a crash bug with no parameter binding for
  prepare statements with parameter markers(bug
  report from Han).
6) Fix a bug about SQLGetDiagField(bug report from
  Han).
7) Add a missing ENTER_STMT_CS at the start of
  SQLForeignKey().

22 years agoIgnore dropped columns for 7.3 databases.
Dave Page [Fri, 6 Dec 2002 14:07:06 +0000 (14:07 +0000)]
Ignore dropped columns for 7.3 databases.

22 years agono message
Dave Page [Fri, 29 Nov 2002 13:27:30 +0000 (13:27 +0000)]
no message

22 years agoRemoved unused win32w.mak makefile
Dave Page [Fri, 29 Nov 2002 13:04:54 +0000 (13:04 +0000)]
Removed unused win32w.mak makefile

22 years agoUpdated version number for 07.02.0005
Dave Page [Fri, 29 Nov 2002 12:57:59 +0000 (12:57 +0000)]
Updated version number for 07.02.0005

22 years agoUpgrade to 7.2.0005.
Hiroshi Inoue [Wed, 27 Nov 2002 09:30:53 +0000 (09:30 +0000)]
Upgrade to 7.2.0005.

22 years agoChange CURSOR_TYPE or CONCURRENCY statement attribute to
Hiroshi Inoue [Tue, 26 Nov 2002 05:48:22 +0000 (05:48 +0000)]
Change CURSOR_TYPE or CONCURRENCY statement attribute to
be reset on cursor close per bug report from Glen Parker.

22 years agoAdded windows specific files to tarball
Dave Page [Mon, 25 Nov 2002 10:21:10 +0000 (10:21 +0000)]
Added windows specific files to tarball

22 years agoFix a bug reported by Glen Parker.
Hiroshi Inoue [Mon, 25 Nov 2002 09:47:48 +0000 (09:47 +0000)]
Fix a bug reported by Glen Parker.

22 years agoChange SQLRowCount to return SQL_SUCCESS not SQL_ERROR
Hiroshi Inoue [Mon, 25 Nov 2002 09:02:11 +0000 (09:02 +0000)]
Change SQLRowCount to return SQL_SUCCESS not SQL_ERROR
if the statement executed fine.

22 years agoUse SQL_TYPE_DATE, SQL_TYPE_TIME and SQL_TYPE_TIMESTAMP
Hiroshi Inoue [Fri, 22 Nov 2002 10:32:00 +0000 (10:32 +0000)]
Use SQL_TYPE_DATE, SQL_TYPE_TIME and SQL_TYPE_TIMESTAMP
instead of SQL_DATE, SQL_TIME and SQL_TIMESTAMP.

22 years agoChange SQLGetTypeinfo to display ODBC3.x info.
Hiroshi Inoue [Fri, 22 Nov 2002 10:27:45 +0000 (10:27 +0000)]
Change SQLGetTypeinfo to display ODBC3.x info.

23 years ago1) Fixed pretty many 'if (..);' lines(my fault sorry).
Hiroshi Inoue [Wed, 13 Nov 2002 23:42:05 +0000 (23:42 +0000)]
1) Fixed pretty many 'if (..);' lines(my fault sorry).
2) Add a few #include lines(config.h pthread,h) for *nix.
3) Supress automatic client_encoding setting in some cases.

23 years agoFix a crash bug thanks to Ryo Hattori.
Hiroshi Inoue [Wed, 13 Nov 2002 02:48:07 +0000 (02:48 +0000)]
Fix a crash bug thanks to Ryo Hattori.

23 years agoUpdated version number REL-07_02_0004
Dave Page [Tue, 12 Nov 2002 08:26:47 +0000 (08:26 +0000)]
Updated version number

23 years ago07.02.0004 Release
Dave Page [Fri, 8 Nov 2002 17:06:48 +0000 (17:06 +0000)]
07.02.0004 Release

23 years agoThread safe driver is available on some platforms.
Hiroshi Inoue [Thu, 7 Nov 2002 10:24:33 +0000 (10:24 +0000)]
Thread safe driver is available on some platforms.

23 years agoRemoved out of date Installshield settings.
Dave Page [Thu, 7 Nov 2002 08:31:10 +0000 (08:31 +0000)]
Removed out of date Installshield settings.

23 years agoAdded the installer to CVS.
Dave Page [Thu, 7 Nov 2002 08:28:29 +0000 (08:28 +0000)]
Added the installer to CVS.

23 years ago1) Change to use thread-safe functions(xxxx_r) if possible.
Hiroshi Inoue [Wed, 6 Nov 2002 09:44:55 +0000 (09:44 +0000)]
1) Change to use thread-safe functions(xxxx_r) if possible.

23 years agoBuild with multithread support by default in case ODBC 3.X.
Hiroshi Inoue [Wed, 6 Nov 2002 08:49:55 +0000 (08:49 +0000)]
Build with multithread support by default in case ODBC 3.X.

23 years ago1) Improve the handling of dead connections mainly for connection pooling.
Hiroshi Inoue [Wed, 6 Nov 2002 03:56:21 +0000 (03:56 +0000)]
1) Improve the handling of dead connections mainly for connection pooling.
2) Change to not abort on erros(e.g. invalid client_encoding) during
   CC_send_settings().

23 years ago1) Change SQLParamOptions to count errors as processed rows
Hiroshi Inoue [Wed, 30 Oct 2002 09:45:12 +0000 (09:45 +0000)]
1) Change SQLParamOptions to count errors as processed rows
   per bug report from Barry Cohen..
2) Fix a bug about date/time escape string per bug report
   from Janet BorSchowa.

23 years agoAdd multithreading on Solaris and Linux by Janet Borschowa
Hiroshi Inoue [Thu, 24 Oct 2002 09:51:07 +0000 (09:51 +0000)]
Add multithreading on Solaris and Linux by Janet Borschowa
 <borschow@roguewave.com>.

23 years agoAdd odbc.sgml.
Bruce Momjian [Mon, 21 Oct 2002 23:12:51 +0000 (23:12 +0000)]
Add odbc.sgml.

23 years ago1) Change SQLExtendedFetch to return SQL_NO_DATA_FOUND not SQL_ERROR
Hiroshi Inoue [Mon, 21 Oct 2002 08:31:00 +0000 (08:31 +0000)]
1) Change SQLExtendedFetch to return SQL_NO_DATA_FOUND not SQL_ERROR
   for non-select cursors per bug(?) report from Gabor.
2) Handle the CURS_IN_ROWSET flag properly when the 5th parameter
   of SQLExtendedFetch is NULL per bug report from Janet Borschowa.

23 years agoChange updatable cursors for 'select func()' to not return
Hiroshi Inoue [Mon, 21 Oct 2002 08:12:15 +0000 (08:12 +0000)]
Change updatable cursors for 'select func()' to not return
an error(just changing the cursor to be read-only) per bug
report from Keisaku Sasaki.

23 years agoAdded README.unix to build system.
Dave Page [Wed, 16 Oct 2002 09:02:10 +0000 (09:02 +0000)]
Added README.unix to build system.

23 years agoUpdated README.unix for new build environment.
Dave Page [Wed, 16 Oct 2002 08:57:15 +0000 (08:57 +0000)]
Updated README.unix for new build environment.

23 years agoAdded Unix build environment as supplied by Peter Eisentraut.
Dave Page [Wed, 16 Oct 2002 07:39:54 +0000 (07:39 +0000)]
Added Unix build environment as supplied by Peter Eisentraut.

23 years ago1) Change SQLDescribeCol or SQLColAttribute to return right ResultNumCols for
Hiroshi Inoue [Thu, 10 Oct 2002 06:37:54 +0000 (06:37 +0000)]
1) Change SQLDescribeCol or SQLColAttribute to return right ResultNumCols for
   keyset/static cursors.
2) Change PG_TYPE_TEXT -> PG_TYPE_VARCHAR for character columns of the
   result of catalog functions (bug report from Mike Mascari).

23 years agoChange the default precision of Timestamp type. REL-07_02_0003
Hiroshi Inoue [Thu, 3 Oct 2002 08:16:57 +0000 (08:16 +0000)]
Change the default precision of Timestamp type.

23 years agoAdded unix build instructions.
Dave Page [Thu, 3 Oct 2002 07:44:42 +0000 (07:44 +0000)]
Added unix build instructions.

23 years ago1) Removed most static variables for thread safety.
Hiroshi Inoue [Mon, 23 Sep 2002 08:08:22 +0000 (08:08 +0000)]
1) Removed most static variables for thread safety.
2) Trial implementation of the thread safe driver under
   Windows.
3)  Fix a bug about DSN options setting.
4)  Fix a bug about Driver options setting.
5) Implement SQLProcedureColumns().
6) Changed default numeric precision/scale.
7) Fix some memory leaks in Unicode driver.
8) datetime -> timestamp with time zone since 7.0.
9) Change manually started(using begin) transactions never
   be implicitly committed.

23 years agoChange NAMEDATALEN to 64 for 7.3 servers.
Hiroshi Inoue [Fri, 6 Sep 2002 05:51:45 +0000 (05:51 +0000)]
Change NAMEDATALEN to 64 for 7.3 servers.
Change max index key count to 32 for 7.3 servers.

23 years agoChange LOCK statements to start new transaction
Hiroshi Inoue [Fri, 9 Aug 2002 10:04:21 +0000 (10:04 +0000)]
Change LOCK statements to start new transaction
in auto-commit off mode.

23 years ago1) Improve the handling of the queries like (select ..) union (select ..)
Hiroshi Inoue [Thu, 1 Aug 2002 03:07:50 +0000 (03:07 +0000)]
1) Improve the handling of the queries like (select ..) union (select ..)
   whose first non-space character is '('.
2) Handle Insert .. () VALUES ().

23 years agoFix a bug about automatic client_encoding setting.
Hiroshi Inoue [Tue, 30 Jul 2002 00:48:02 +0000 (00:48 +0000)]
Fix a bug about automatic client_encoding setting.

23 years agoFix a bug about the handling of CX parameter of the connection string
Hiroshi Inoue [Fri, 26 Jul 2002 08:45:54 +0000 (08:45 +0000)]
Fix a bug about the handling of CX parameter of the connection string
reported by Sergey Smirnov.

23 years agoFix a bug about the handling of '.' in parse.c.
Hiroshi Inoue [Mon, 15 Jul 2002 02:56:39 +0000 (02:56 +0000)]
Fix a bug about the handling of '.' in parse.c.

23 years agoAn improvement of User Interface(Setup dialog) by Dave Page.
Hiroshi Inoue [Fri, 12 Jul 2002 02:02:26 +0000 (02:02 +0000)]
An improvement of User Interface(Setup dialog) by Dave Page.

23 years ago1) Fix a memory leak in use declare/fetch mode.
Hiroshi Inoue [Fri, 12 Jul 2002 01:41:25 +0000 (01:41 +0000)]
1) Fix a memory leak in use declare/fetch mode.
2) Change default build mode to multibyte(Windows).

23 years agoMake NAMEDATALEN changeable at compile time.
Hiroshi Inoue [Thu, 11 Jul 2002 01:52:46 +0000 (01:52 +0000)]
Make NAMEDATALEN changeable at compile time.

23 years agoFix a bug reported by Zhou Han.
Hiroshi Inoue [Fri, 5 Jul 2002 01:31:41 +0000 (01:31 +0000)]
Fix a bug reported by Zhou Han.

23 years ago1) prevent setting of KSQO on 7.3+ servers(Thanks to Dave Page).
Hiroshi Inoue [Fri, 28 Jun 2002 02:44:15 +0000 (02:44 +0000)]
1) prevent setting of KSQO on 7.3+ servers(Thanks to Dave Page).
2) Allow LF->CR/LF conversion under UNICODE driver.

23 years ago1) Add support for GB18030.
Hiroshi Inoue [Tue, 25 Jun 2002 01:54:19 +0000 (01:54 +0000)]
1) Add support for GB18030.
2) Fix a bug about the handling of large objects.

23 years agoUpdate copyright to 2002.
Bruce Momjian [Thu, 20 Jun 2002 20:29:54 +0000 (20:29 +0000)]
Update copyright to 2002.

23 years agoAdd LOCALTIME and LOCALTIMESTAMP functions per SQL99 standard.
Thomas G. Lockhart [Sat, 15 Jun 2002 03:00:09 +0000 (03:00 +0000)]
Add LOCALTIME and LOCALTIMESTAMP functions per SQL99 standard.
Remove ODBC-compatible empty parentheses from calls to SQL99 functions
 for which these parentheses do not match the standard.
Update the ODBC driver to ensure compatibility with the ODBC standard
 for these functions (e.g. CURRENT_TIMESTAMP, CURRENT_USER, etc).
Include a new appendix in the User's Guide which lists the labeled features
 for SQL99 (the labeled features replaced the "basic", "intermediate",
 and "advanced" categories from SQL92). features.sgml does not yet split
 this list into "supported" and "unsupported" lists.

23 years ago1) Fix a bug *double error message*.
Hiroshi Inoue [Wed, 12 Jun 2002 02:27:44 +0000 (02:27 +0000)]
1) Fix a bug *double error message*.
2) Fix a bug *passowrd prompt in case of md5 authentication*.
3) Improve the DSN setup dialog.

23 years agoAdd missing win_setup.h.
Hiroshi Inoue [Thu, 6 Jun 2002 09:47:25 +0000 (09:47 +0000)]
Add missing win_setup.h.

23 years agoAdd *Int8 As* option.
Hiroshi Inoue [Thu, 6 Jun 2002 04:50:47 +0000 (04:50 +0000)]
Add *Int8 As* option.

23 years ago1) Support Keyset Driven driver cursors.
Hiroshi Inoue [Wed, 22 May 2002 05:51:03 +0000 (05:51 +0000)]
1) Support Keyset Driven driver cursors.
2) Supprt ARD precision/scale and SQL_C_NUEMRIC.
3) Minimal implementation of SQLGetDiagField().
4) SQLRowCount() reports the result of SQLSetPos and SQLBulkOperation.
5) int8 -> SQL_NUMERIC for Microsoft Jet.
6) Support isolation level change.
7) ODBC3.0 SQLSTATE code.
8) Append mode log files.

23 years agoAdd a file for version control.
Hiroshi Inoue [Thu, 9 May 2002 04:10:22 +0000 (04:10 +0000)]
Add a file for version control.

23 years agoFix for the following items about escape sequence
Hiroshi Inoue [Thu, 25 Apr 2002 02:50:08 +0000 (02:50 +0000)]
Fix for the following items about escape sequence

   by Marcelo Aceto <aceto@newinf.com.br> .

1) Wrong translations of embedded escape sequences inside outer join escape
sequences.
2) Wrong translation of parameter markers inside outer joins and function
escape sequences.
3) Bad concatenation of date, time, timestamp constants with next word in
statement:

23 years agoSorry for the package, but the following patch need to be applied to get
Bruce Momjian [Wed, 24 Apr 2002 01:56:20 +0000 (01:56 +0000)]
Sorry for the package, but the following patch need to be applied to get
the new verion compiled on SCO Openserver 5.0.5 and Unixware 7.1.1

Nicolas Bazin

23 years ago1) Fix SQLProcedures().
Hiroshi Inoue [Tue, 23 Apr 2002 04:14:13 +0000 (04:14 +0000)]
1) Fix SQLProcedures().
2) Handle timestamp without time zone.
3) Improve SQLForeignKeys() in multibyte mode.

23 years ago1) Fix a bug about reporting varchar info thanks to Aceto.
Hiroshi Inoue [Mon, 15 Apr 2002 02:46:00 +0000 (02:46 +0000)]
1) Fix a bug about reporting varchar info thanks to Aceto.
2) Introcuced 3 drivers.
3) The version is now 7.02.0001.

23 years ago1) Fix a bug in declare/fetch mode.
Hiroshi Inoue [Fri, 12 Apr 2002 08:03:12 +0000 (08:03 +0000)]
1) Fix a bug in declare/fetch mode.
2) Suppress some error logs for the request to other drivers.

23 years agoPrevent an infinite loop of error reporting.
Hiroshi Inoue [Wed, 10 Apr 2002 08:18:54 +0000 (08:18 +0000)]
Prevent an infinite loop of error reporting.

23 years agoLet psqlodbc30 be compilable without /D DRIVER_CURSOR_IMPLEMENT.
Hiroshi Inoue [Tue, 9 Apr 2002 03:58:33 +0000 (03:58 +0000)]
Let psqlodbc30 be compilable without /D DRIVER_CURSOR_IMPLEMENT.

23 years agoFix a bug in SQLError().
Hiroshi Inoue [Thu, 4 Apr 2002 23:29:16 +0000 (23:29 +0000)]
Fix a bug in SQLError().

23 years agoFix a bug in multibyte_strchr().
Hiroshi Inoue [Thu, 4 Apr 2002 01:36:17 +0000 (01:36 +0000)]
Fix a bug in multibyte_strchr().

23 years agoFix compiler warnings.
Hiroshi Inoue [Tue, 2 Apr 2002 10:57:25 +0000 (10:57 +0000)]
Fix compiler warnings.

23 years ago[HACKERS] Proposed patch for ODBC driver w/ C-a-n-c-e-l
Hiroshi Inoue [Tue, 2 Apr 2002 10:50:50 +0000 (10:50 +0000)]
[HACKERS] Proposed patch for ODBC driver w/ C-a-n-c-e-l
    From: Bradley McLean <brad@bradm.net>

Patch against 7,2 submitted for comment.

This seems to work just fine; Now, when our users submit a 2 hour
query with four million row sorts by accident, then cancel it 30 seconds
later, it doesn't bog down the server ...

23 years ago1) Add rollback functionality to updatable cursors.
Hiroshi Inoue [Mon, 1 Apr 2002 03:01:15 +0000 (03:01 +0000)]
1) Add rollback functionality to updatable cursors.
2) Implement some options for SQLGetDescField().
3) Handle *Inifinity* timestamp for SQL_C_CHAR type output.
4) Separate Unicode conversions from common implementations.
5) Improve internal parse_statement() function.

23 years agoFix ODBC warnings about missing parens and pg_ismb not used (added
Bruce Momjian [Fri, 29 Mar 2002 07:48:56 +0000 (07:48 +0000)]
Fix ODBC warnings about missing parens and pg_ismb not used (added
#ifdef NOT_USED).

23 years ago[2002-03-28]
Hiroshi Inoue [Thu, 28 Mar 2002 08:08:07 +0000 (08:08 +0000)]
[2002-03-28]
1) Prepare to separate 4 kinds of Descriptor handles.
2) Detect the transaction status more naturally.
3) Improve Parse Statement functionality for the use
   of updatable cursors.
4) Improve updatable cursors.
5) Implement SQLGetDescField() and improve SQLColAttribute().
6) etc.

23 years agoFix for ODBC compile warnings.
Bruce Momjian [Mon, 25 Mar 2002 01:53:55 +0000 (01:53 +0000)]
Fix for ODBC compile warnings.

23 years ago1) Internal improvements to handle updatable cursors(1st cut).
Hiroshi Inoue [Thu, 14 Mar 2002 05:42:04 +0000 (05:42 +0000)]
1) Internal improvements to handle updatable cursors(1st cut).
2) Fix a bug in SQLColAttribute().

23 years agoBug fixes for the 2002-03-08 change.
Hiroshi Inoue [Mon, 11 Mar 2002 10:25:57 +0000 (10:25 +0000)]
Bug fixes for the 2002-03-08 change.
1) Put back the error message for SQLError().
2) Change Disallow premature to handle the SELECTed
   result.
3) Put back the behavior of AUTUCOMMIT mode change.
4) Fix SQLColumns for ODBC3.0.

5) Improve the handling of variable bookmark in ODBC3.0.
6) Enable Recognize Unique Index Button.

23 years agoRemove compile errors.
Hiroshi Inoue [Fri, 8 Mar 2002 09:50:39 +0000 (09:50 +0000)]
Remove compile errors.

23 years ago1) Implement SQLParamOptions().
Hiroshi Inoue [Fri, 8 Mar 2002 08:52:55 +0000 (08:52 +0000)]
1) Implement SQLParamOptions().
2) Handle Multiple results and implement SQLMoreResult().
3) Improve multibyte handling thanks to Eiji Tokuya.
4) Add new options.
   LF <-> CR/LF converion.
   TRUE is -1 (for VB).
5) Introduce unicode(UCS-2) support.
6) Reduce the length of connection strings.
7) Improve SQLError, SQLGetDiagRec(ODBC 3.0).
8) Implement SQLTablePrivileges().
9) Miscellaneous changes for ODBC 3.0 support.

23 years agoChange made to elog:
Bruce Momjian [Wed, 6 Mar 2002 06:10:43 +0000 (06:10 +0000)]
Change made to elog:

o  Change all current CVS messages of NOTICE to WARNING.  We were going
to do this just before 7.3 beta but it has to be done now, as you will
see below.

o Change current INFO messages that should be controlled by
client_min_messages to NOTICE.

o Force remaining INFO messages, like from EXPLAIN, VACUUM VERBOSE, etc.
to always go to the client.

o Remove INFO from the client_min_messages options and add NOTICE.

Seems we do need three non-ERROR elog levels to handle the various
behaviors we need for these messages.

Regression passed.

23 years ago> Tatsuo Ishii wrote:
Bruce Momjian [Tue, 5 Mar 2002 05:52:50 +0000 (05:52 +0000)]
> Tatsuo Ishii wrote:
> > > > It was made to cope with encoding such as an Asian bloc in 7.2Beta2.
> > > >
> > > > Added ServerEncoding
> > > >         Korean (JOHAB), Thai (WIN874),
> > > >         Vietnamese (TCVN), Arabic (WIN1256)
> > > >
> > > > Added ClientEncoding
> > > >         Simplified Chinese (GBK), Korean (UHC)
> > > >
> > > >
> > > >
> http://www.sankyo-unyu.co.jp/Pool/postgresql-7.2b2.newencoding.diff.tar.gz
> > > > (608K)
> > >
> > > Looks good.  I need some people to review this for me.
> >
> > For me they look good too. The only missing part is a
> > documentation. I will ask him to write it up. If he couldn't, I will
> > do it for him.
> > > The diff is 3mb
> > > but appears to address only additions to multibyte.  I have attached a
> > > list of files it modifies.  Also, look at the sizes of the mb/
> > > directory.  It is getting large:
> > >
> > >   4       ./CVS
> > >   6       ./Unicode/CVS
> > >   3433    ./Unicode
> > >   6197    .
> >
> > Yes. We definitely need the on-the-fly encoding addition capability:
> > i.e. CREATE CHRACTER SET in the future...
> > --
> > Tatsuo Ishii
> >
> >

Address chainge.

http://www.sankyo-unyu.co.jp/Pool/postgresql-7.2.newencoding.diff.gz

Add PsqlODBC and document ...etc patch.

Eiji Tokuya

23 years agoAdd files for Unicode support.
Hiroshi Inoue [Fri, 1 Mar 2002 07:18:34 +0000 (07:18 +0000)]
Add files for Unicode support.

23 years agoImprove the handling of ODBC escape(a request from Marcelo Aceto).
Hiroshi Inoue [Wed, 27 Feb 2002 01:43:24 +0000 (01:43 +0000)]
Improve the handling of ODBC escape(a request from Marcelo Aceto).
Change SQLGetFunctions() to reply not yet implemented ODBC 3.0
functions precisely.

23 years agoRemove compile warnings in multibute mode.
Hiroshi Inoue [Mon, 18 Feb 2002 05:54:50 +0000 (05:54 +0000)]
Remove compile warnings in multibute mode.

23 years agoThe version is now 7.01.0010.
Hiroshi Inoue [Mon, 18 Feb 2002 03:16:11 +0000 (03:16 +0000)]
The version is now 7.01.0010.
1) Handle parameter array.
2) Allow re-use of the connection handle after SQLDisconnect.
3) Reject NULL if no indicator specified.
4) Improve the handling of '_' in table name.
5) Unify internal begin/commit/abort operations.
6) Change SQLTables() to return null not "" for the
   table_owner.
7) Fix a bug about parameter handling reported by Benoit Menendez.
8) Add cast in handling ODBC date/time escape sequences.
9) Fix a bug about cache_size handing in declare/fetch mode.

[ODBC3.0 related]
10) Improve the handling of descriptor handles(ODBC3.0).
11) Improve the type handling of some types for ODBC3.0.

[Thanks to Marcelo Aceto for his useful patches]
12) Allow nested ODBC escape.
13) Allow changing autocommit on/off inside the transaction
    block.
14) Improve the handling of ODBC scalar functions.

23 years agoSeparate info30.c from info.c.
Hiroshi Inoue [Mon, 18 Feb 2002 02:15:04 +0000 (02:15 +0000)]
Separate info30.c from info.c.