Hiroshi Inoue [Sun, 18 May 2003 00:39:25 +0000 (00:39 +0000)]
Fix a bug in SQLForeignKeys().
Dave Page [Thu, 15 May 2003 16:06:21 +0000 (16:06 +0000)]
Updates for 07.03.0100
Dave Page [Thu, 15 May 2003 15:53:13 +0000 (15:53 +0000)]
Include correct .def and .mak files.
Hiroshi Inoue [Thu, 15 May 2003 14:33:51 +0000 (14:33 +0000)]
Change .mak files.
Hiroshi Inoue [Thu, 15 May 2003 14:14:46 +0000 (14:14 +0000)]
Change the .def and .mak files.
Dave Page [Thu, 15 May 2003 09:00:54 +0000 (09:00 +0000)]
Updates for 07.03.0100
Dave Page [Thu, 15 May 2003 08:45:43 +0000 (08:45 +0000)]
Use the default driver for the setup.
Dave Page [Thu, 15 May 2003 08:39:04 +0000 (08:39 +0000)]
Updates for 07.03.0100
Dave Page [Thu, 15 May 2003 08:24:40 +0000 (08:24 +0000)]
Updates for 07.03.0100
Dave Page [Thu, 15 May 2003 08:00:24 +0000 (08:00 +0000)]
Updates for 07.03.0001
Dave Page [Thu, 15 May 2003 07:38:16 +0000 (07:38 +0000)]
Updates for 07.03.0001
Hiroshi Inoue [Wed, 14 May 2003 23:45:54 +0000 (23:45 +0000)]
Fix compilation errors for the ODBC2.50 driver.
Dave Page [Wed, 14 May 2003 18:38:27 +0000 (18:38 +0000)]
Updates for 07.03.0001
Dave Page [Wed, 14 May 2003 18:32:58 +0000 (18:32 +0000)]
Updates for 07.03.0001
Dave Page [Wed, 14 May 2003 18:16:16 +0000 (18:16 +0000)]
Update registry files to promote the ODBC3 driver to the default, and demote the 2.5 to legacy status.
Hiroshi Inoue [Wed, 14 May 2003 01:32:32 +0000 (01:32 +0000)]
Add a Manage(DSN) button to the English config dialog thanks to
Hiroshi Saito.
Hiroshi Inoue [Tue, 13 May 2003 01:38:39 +0000 (01:38 +0000)]
Change some japanese resource settings thanks to Hiroshi Saito.
Hiroshi Inoue [Mon, 12 May 2003 15:44:08 +0000 (15:44 +0000)]
1) Add a *bytea as LO* DSN option button.
2) Add japanese resources to psqlodbc.rc.
3) Add a dialog for the driver change.
Hiroshi Inoue [Wed, 23 Apr 2003 09:49:47 +0000 (09:49 +0000)]
1) Avoid password leak in the log.
2) Reduce time() calls for the performance.
3) Improve the handling of per Driver resource.
4) #define HAVE_STRTOLL
etc.
Bruce Momjian [Mon, 24 Mar 2003 19:15:26 +0000 (19:15 +0000)]
Add pg_catalog schema prefix to most queries that access system tables.
Hiroshi Inoue [Mon, 24 Feb 2003 01:06:32 +0000 (01:06 +0000)]
Change the macro ATOI64U to mean strtoull under unix(my fault).
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.
Hiroshi Inoue [Tue, 11 Feb 2003 08:27:29 +0000 (08:27 +0000)]
Add extra 2 digits to the precision of floating numbers.
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>.
Hiroshi Inoue [Tue, 11 Feb 2003 00:08:53 +0000 (00:08 +0000)]
Introduce the bigint support under *nix.
Hiroshi Inoue [Mon, 10 Feb 2003 15:13:45 +0000 (15:13 +0000)]
Handle the TableType parameter of SQLTables() as case insensitive.
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).
Hiroshi Inoue [Wed, 5 Feb 2003 01:21:01 +0000 (01:21 +0000)]
Deprecate ODBC2.X functions for the ODBC 3 driver.
Hiroshi Inoue [Mon, 3 Feb 2003 03:10:44 +0000 (03:10 +0000)]
Fix a bug about multibyte check.
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
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
Bruce Momjian [Wed, 8 Jan 2003 14:56:12 +0000 (14:56 +0000)]
Fix foreign key sytnax bug, patch from Wes Griffin.
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.
Hiroshi Inoue [Fri, 3 Jan 2003 16:08:14 +0000 (16:08 +0000)]
Put back the MAX_INFO_STRING value.
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
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.
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.
Hiroshi Inoue [Tue, 31 Dec 2002 00:28:25 +0000 (00:28 +0000)]
The preparation of ODBC3 support under *nix.
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.
Hiroshi Inoue [Fri, 20 Dec 2002 08:30:04 +0000 (08:30 +0000)]
Change SQLFreeStmt(.., SQL_CLOSE) to not DEALLOCATE prepared statements.
Hiroshi Inoue [Tue, 17 Dec 2002 14:38:23 +0000 (14:38 +0000)]
Add a new *Server side prepare* option.
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().
Dave Page [Fri, 6 Dec 2002 14:07:06 +0000 (14:07 +0000)]
Ignore dropped columns for 7.3 databases.
Dave Page [Fri, 29 Nov 2002 13:27:30 +0000 (13:27 +0000)]
no message
Dave Page [Fri, 29 Nov 2002 13:04:54 +0000 (13:04 +0000)]
Removed unused win32w.mak makefile
Dave Page [Fri, 29 Nov 2002 12:57:59 +0000 (12:57 +0000)]
Updated version number for 07.02.0005
Hiroshi Inoue [Wed, 27 Nov 2002 09:30:53 +0000 (09:30 +0000)]
Upgrade to 7.2.0005.
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.
Dave Page [Mon, 25 Nov 2002 10:21:10 +0000 (10:21 +0000)]
Added windows specific files to tarball
Hiroshi Inoue [Mon, 25 Nov 2002 09:47:48 +0000 (09:47 +0000)]
Fix a bug reported by Glen Parker.
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.
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.
Hiroshi Inoue [Fri, 22 Nov 2002 10:27:45 +0000 (10:27 +0000)]
Change SQLGetTypeinfo to display ODBC3.x info.
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.
Hiroshi Inoue [Wed, 13 Nov 2002 02:48:07 +0000 (02:48 +0000)]
Fix a crash bug thanks to Ryo Hattori.
Dave Page [Tue, 12 Nov 2002 08:26:47 +0000 (08:26 +0000)]
Updated version number
Dave Page [Fri, 8 Nov 2002 17:06:48 +0000 (17:06 +0000)]
07.02.0004 Release
Hiroshi Inoue [Thu, 7 Nov 2002 10:24:33 +0000 (10:24 +0000)]
Thread safe driver is available on some platforms.
Dave Page [Thu, 7 Nov 2002 08:31:10 +0000 (08:31 +0000)]
Removed out of date Installshield settings.
Dave Page [Thu, 7 Nov 2002 08:28:29 +0000 (08:28 +0000)]
Added the installer to CVS.
Hiroshi Inoue [Wed, 6 Nov 2002 09:44:55 +0000 (09:44 +0000)]
1) Change to use thread-safe functions(xxxx_r) if possible.
Hiroshi Inoue [Wed, 6 Nov 2002 08:49:55 +0000 (08:49 +0000)]
Build with multithread support by default in case ODBC 3.X.
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().
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.
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>.
Bruce Momjian [Mon, 21 Oct 2002 23:12:51 +0000 (23:12 +0000)]
Add odbc.sgml.
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.
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.
Dave Page [Wed, 16 Oct 2002 09:02:10 +0000 (09:02 +0000)]
Added README.unix to build system.
Dave Page [Wed, 16 Oct 2002 08:57:15 +0000 (08:57 +0000)]
Updated README.unix for new build environment.
Dave Page [Wed, 16 Oct 2002 07:39:54 +0000 (07:39 +0000)]
Added Unix build environment as supplied by Peter Eisentraut.
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).
Hiroshi Inoue [Thu, 3 Oct 2002 08:16:57 +0000 (08:16 +0000)]
Change the default precision of Timestamp type.
Dave Page [Thu, 3 Oct 2002 07:44:42 +0000 (07:44 +0000)]
Added unix build instructions.
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.
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.
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.
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 ().
Hiroshi Inoue [Tue, 30 Jul 2002 00:48:02 +0000 (00:48 +0000)]
Fix a bug about automatic client_encoding setting.
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.
Hiroshi Inoue [Mon, 15 Jul 2002 02:56:39 +0000 (02:56 +0000)]
Fix a bug about the handling of '.' in parse.c.
Hiroshi Inoue [Fri, 12 Jul 2002 02:02:26 +0000 (02:02 +0000)]
An improvement of User Interface(Setup dialog) by Dave Page.
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).
Hiroshi Inoue [Thu, 11 Jul 2002 01:52:46 +0000 (01:52 +0000)]
Make NAMEDATALEN changeable at compile time.
Hiroshi Inoue [Fri, 5 Jul 2002 01:31:41 +0000 (01:31 +0000)]
Fix a bug reported by Zhou Han.
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.
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.
Bruce Momjian [Thu, 20 Jun 2002 20:29:54 +0000 (20:29 +0000)]
Update copyright to 2002.
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.
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.
Hiroshi Inoue [Thu, 6 Jun 2002 09:47:25 +0000 (09:47 +0000)]
Add missing win_setup.h.
Hiroshi Inoue [Thu, 6 Jun 2002 04:50:47 +0000 (04:50 +0000)]
Add *Int8 As* option.
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.
Hiroshi Inoue [Thu, 9 May 2002 04:10:22 +0000 (04:10 +0000)]
Add a file for version control.
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:
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
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.
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.
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.
Hiroshi Inoue [Wed, 10 Apr 2002 08:18:54 +0000 (08:18 +0000)]
Prevent an infinite loop of error reporting.