summaryrefslogtreecommitdiff
path: root/statement.c
AgeCommit message (Collapse)Author
2003-06-19When doing an UPDATE or DELETE via ODBC, if no records are affected then ↵Dave Page
SQLExecute should return SQL_NO_DATA_FOUND and not SQL_SUCCESS. The following patch to RH9 applies to the version in CVS (with an offset). This patch has been tested on RH9. [Tim Woodall]
2003-05-271) Corrent the handling of bookmark in SQLBulkOperations.Hiroshi Inoue
2) Correct the calculation of a global index in SC_pos_add. 3) Cleanup global/rowset/resultset index handling a little.
2003-05-121) Add a *bytea as LO* DSN option button.Hiroshi Inoue
2) Add japanese resources to psqlodbc.rc. 3) Add a dialog for the driver change.
2003-04-231) Avoid password leak in the log.Hiroshi Inoue
2) Reduce time() calls for the performance. 3) Improve the handling of per Driver resource. 4) #define HAVE_STRTOLL etc.
2002-12-20Change SQLFreeStmt(.., SQL_CLOSE) to not DEALLOCATE prepared statements.Hiroshi Inoue
2002-12-161) Separate APD and IPD more explicitly.Hiroshi Inoue
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().
2002-11-26Change CURSOR_TYPE or CONCURRENCY statement attribute toHiroshi Inoue
be reset on cursor close per bug report from Glen Parker.
2002-11-13Fix a crash bug thanks to Ryo Hattori.Hiroshi Inoue
2002-11-061) Improve the handling of dead connections mainly for connection pooling.Hiroshi Inoue
2) Change to not abort on erros(e.g. invalid client_encoding) during CC_send_settings().
2002-10-101) Change SQLDescribeCol or SQLColAttribute to return right ResultNumCols forHiroshi Inoue
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).
2002-09-231) Removed most static variables for thread safety.Hiroshi Inoue
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.
2002-08-09Change LOCK statements to start new transactionHiroshi Inoue
in auto-commit off mode.
2002-08-011) Improve the handling of the queries like (select ..) union (select ..)Hiroshi Inoue
whose first non-space character is '('. 2) Handle Insert .. () VALUES ().
2002-06-06Add *Int8 As* option.Hiroshi Inoue
2002-05-221) Support Keyset Driven driver cursors.Hiroshi Inoue
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.
2002-04-231) Fix SQLProcedures().Hiroshi Inoue
2) Handle timestamp without time zone. 3) Improve SQLForeignKeys() in multibyte mode.
2002-04-10Prevent an infinite loop of error reporting.Hiroshi Inoue
2002-04-011) Add rollback functionality to updatable cursors.Hiroshi Inoue
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.
2002-03-28[2002-03-28]Hiroshi Inoue
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.
2002-03-141) Internal improvements to handle updatable cursors(1st cut).Hiroshi Inoue
2) Fix a bug in SQLColAttribute().
2002-03-11Bug fixes for the 2002-03-08 change.Hiroshi Inoue
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.
2002-03-081) Implement SQLParamOptions().Hiroshi Inoue
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.
2002-02-18The version is now 7.01.0010.Hiroshi Inoue
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.
2001-11-05New pgindent run with fixes suggested by Tom. Patch manually reviewed,REL7_2_BETA2Bruce Momjian
initdb/regression tests pass.
2001-11-05Preparation for the parameter array handling.Hiroshi Inoue
2001-11-051) Fix a few bugs about SQLGetData()Hiroshi Inoue
reported by Mika Mantyla. 2) Timestamp precision. 3) Separate ODBC3.0 files.
2001-10-28Another pgindent run. Fixes enum indenting, and improves #endifBruce Momjian
spacing. Also adds space for one-line comments.
2001-10-25pgindent run on all C files. Java run to follow. initdb/regressionREL7_2_BETA1Bruce Momjian
tests pass.
2001-10-19Change SC_fetch() to not retrieve data in case theHiroshi Inoue
SQL_RETRIEVE_DATA option is SQL_RD_OFF. This would avoid a crash when scrolling Grid controls.
2001-09-22Provide some initial support for building the ODBC driver forPeter Eisentraut
an already installed iODBC or unixODBC driver manager. In particular, use the include files provided by the driver manager over our own, and use the odbcinst library of the driver manager rather than gpps.c. Migrate portability sections common to several files into psqlodbc.h.
2001-09-141) Improve the implementation of *Disallow Premature* forHiroshi Inoue
older versions of servers. 2) Implement SQLProcedures. Hiroshi Inoue
2001-09-08Improve declare/fetch mode a little.Hiroshi Inoue
Add a new DSN option for PREPARE hadling. Hiroshi Inoue
2001-09-071) Most driver options could be set per DSN.Hiroshi Inoue
2) Keep FE/BE protocol more precisely. 3) Improve procedure calls. 4) A trial to avoid PREMATURE execution(#ifdef'd now). Hiroshi Inoue
2001-08-24Rename config.h to pg_config.h and os.h to pg_config_os.h, fix a number ofPeter Eisentraut
places that were including the wrong files.
2001-08-21Fix a lot of compile errors on unix.Hiroshi Inoue
Fix '\\' handling for bytea type.
2001-08-181) Change all internal SQL function calls fromHiroshi Inoue
SQLxxxx() to PGAPI_xxxx(). 2) Handle an escaped date/time format as a parameter. 3) Improve the tuple allocation a little. 4) The preparation of ODBC 3.0 a little. 5) Updatable cursors(may be deprecated before long).
2001-06-27Handle Procedure calls.Hiroshi Inoue
Now the version is 7.01.0006.
2001-06-22Change SQLPrimaryKeys() so that it detects the primary keyHiroshi Inoue
other than tablename_pkey.
2001-06-20Change the driver so that large error messages are returnedHiroshi Inoue
by multiple SQLError calls.
2001-06-19Changed the error handling as follows.Hiroshi Inoue
1) ERRORs cause an SQL_ERROR and the SQLSTATE='S1000'. 2) NOTICEs cause an SQL_SUCCESS_WITH_INFO and the succeeding SQLError() returns the NOTICE message.
2001-05-25Get rid of the following size limit.Hiroshi Inoue
1) Query size limit(was 65536) for >=7.0 servers. 2) Text size limit(was 8190) for 7.1 servers.
2001-05-08Run pgindent on ODBC code only, to reformat new comments.Bruce Momjian
2001-05-08ODBC source code cleanup patch. Should match rest of PostgreSQL code better.Bruce Momjian
2001-04-23A patch to fix the following bugs.Hiroshi Inoue
1) [ODBC] Psqlodbc and Centura: here it is a patch posted by Matteo Cavalleli 2) [ODBC] pgsqODBC binding parameters II posted by Ludek Finstrle 3) Invalid Page Fault in PSQLODBC.DLL personal mail from Johann Zuschlag Hiroki Kataoka kataoka@interwiz.koganei.tokyo.jp
2001-03-27ODBC source code cleanup. Mostly alignment of #define constants.Bruce Momjian
2001-03-22pgindent run. Make it all clean.Bruce Momjian
2001-03-101)Allow the access to indexes with up to 16 keys.Hiroshi Inoue
2)Fix some memory leaks. 3)Change some bogus error messages.
2001-02-151) Change transaction boundary in autocommit off modeHiroshi Inoue
per recent discussion in pgsql-odbc. Now SELECT is a boundary but VACUUM isn't. 2) Put back the error handling behavior. When elog(ERROR) was detected the driver automatically issue "ABORT" if a transaction is in progress. 3) Driver version is 7.01.0003(Dave already set it but it was put back).
2001-02-14Back out all ODBC formatting changes, and back out removal of <6.4Bruce Momjian
protocol. I have left in Tom's SOCK_get_next_byte() fix, and the new win32.mak file addition. I have also left in the 'X' connection close fix.
2001-02-11Source alignment cleanups.Bruce Momjian