Hiroshi Inoue [Fri, 19 Oct 2001 05:39:14 +0000 (05:39 +0000)]
Change SC_fetch() to not retrieve data in case the
SQL_RETRIEVE_DATA option is SQL_RD_OFF. This would
avoid a crash when scrolling Grid controls.
Thomas G. Lockhart [Thu, 18 Oct 2001 17:30:16 +0000 (17:30 +0000)]
Accept an INTERVAL argument for SET TIME ZONE per SQL99.
Modified the parser and the SET handlers to use full Node structures
rather than simply a character string argument.
Implement INTERVAL() YEAR TO MONTH (etc) syntax per SQL99.
Does not yet accept the goofy string format that goes along with, but
this should be fairly straight forward to fix now as a bug or later
as a feature.
Implement precision for the INTERVAL() type.
Use the typmod mechanism for both of INTERVAL features.
Fix the INTERVAL syntax in the parser:
opt_interval was in the wrong place.
INTERVAL is now a reserved word, otherwise we get reduce/reduce errors.
Implement an explicit date_part() function for TIMETZ.
Should fix coersion problem with INTERVAL reported by Peter E.
Fix up some error messages for date/time types.
Use all caps for type names within message.
Fix recently introduced side-effect bug disabling 'epoch' as a recognized
field for date_part() etc. Reported by Peter E. (??)
Bump catalog version number.
Rename "microseconds" current transaction time field
from ...Msec to ...Usec. Duh!
date/time regression tests updated for reference platform, but a few
changes will be necessary for others.
Peter Eisentraut [Sat, 13 Oct 2001 19:16:32 +0000 (19:16 +0000)]
Fix logic in insert() function.
Hiroshi Inoue [Fri, 12 Oct 2001 09:41:49 +0000 (09:41 +0000)]
Update the version of psqlodbc driver.
Hiroshi Inoue [Fri, 12 Oct 2001 01:08:51 +0000 (01:08 +0000)]
Fix the bug reported by Chris Lee.
Peter Eisentraut [Tue, 9 Oct 2001 22:32:33 +0000 (22:32 +0000)]
Allow optional () after current_user, session_user, user, current_time,
current_timestamp, current_date for ODBC compatibility.
Add more functions to odbc.sql catalog extension, use new CREATE OR
REPLACE FUNCTION.
Document iODBC/unixODBC build options.
Tom Lane [Sun, 30 Sep 2001 21:48:58 +0000 (21:48 +0000)]
Fix sloppiness about static vs non-static declaration of functions.
Some compilers are pickier about this than gcc is.
Hiroshi Inoue [Sat, 29 Sep 2001 02:48:04 +0000 (02:48 +0000)]
Fix the bug about boolean type handling reported by
Kristis Markis.
Hiroshi Inoue [Mon, 24 Sep 2001 00:05:59 +0000 (00:05 +0000)]
1) Fix compile errors on Windows.
2) Change *Common* --> *Default*.
Peter Eisentraut [Sun, 23 Sep 2001 13:32:24 +0000 (13:32 +0000)]
Don't refer to odbcinst.ini by absolute path. SQLGetPrivateProfileString
handles this.
Don't install our own odbcinst.ini. That's the driver manager's business.
Peter Eisentraut [Sat, 22 Sep 2001 22:54:33 +0000 (22:54 +0000)]
Provide some initial support for building the ODBC driver for
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.
Hiroshi Inoue [Fri, 21 Sep 2001 07:51:52 +0000 (07:51 +0000)]
1) Avoid an overflow of connection string for Access(Microsoft Jet).
2) Change to retry lower version in case of "Unsupported frontend
procotol".
Hiroshi Inoue [Fri, 14 Sep 2001 06:46:45 +0000 (06:46 +0000)]
Change an *if condition*.
Hiroshi Inoue
Hiroshi Inoue [Fri, 14 Sep 2001 06:30:37 +0000 (06:30 +0000)]
1) Improve the implementation of *Disallow Premature* for
older versions of servers.
2) Implement SQLProcedures.
Hiroshi Inoue
Hiroshi Inoue [Fri, 14 Sep 2001 01:50:33 +0000 (01:50 +0000)]
Fix a coversation error with pre 6.4 versions.
Hiroshi Inoue
Bruce Momjian [Thu, 13 Sep 2001 22:39:29 +0000 (22:39 +0000)]
Add missing paren to ODBC compiles.
Hiroshi Inoue [Thu, 13 Sep 2001 00:27:11 +0000 (00:27 +0000)]
1) Not export ODBC 3.0 functions.
2) (Maybe) fix a bug reported by Mika Muntila.
Peter Eisentraut [Tue, 11 Sep 2001 23:27:10 +0000 (23:27 +0000)]
Link ODBC driver with -lnsl and -lsocket, for Solaris.
reported by Bob Deblier (bob@virtualunlimited.com)
Hiroshi Inoue [Tue, 11 Sep 2001 06:39:20 +0000 (06:39 +0000)]
Fix some multibyte related bugs.
Psqlodbc is 7.01.0007 now.
Hiroshi Inoue
Hiroshi Inoue [Mon, 10 Sep 2001 10:13:30 +0000 (10:13 +0000)]
Change dialog windows.
Hiroshi Inoue [Mon, 10 Sep 2001 08:53:27 +0000 (08:53 +0000)]
1) Fix SQLForeignKeys() in multibyte mode.
2) Fix a bug with NUMERIC scale in case of Parse
statement option.
3) Remove a no longer needed loop in CC_send_query().
Hiroshi Inoue
Hiroshi Inoue [Sat, 8 Sep 2001 16:20:16 +0000 (16:20 +0000)]
Improve declare/fetch mode a little.
Add a new DSN option for PREPARE hadling.
Hiroshi Inoue
Bruce Momjian [Sat, 8 Sep 2001 02:48:53 +0000 (02:48 +0000)]
Move updateCommon() into Win32 block because it is only used there.
Hiroshi Inoue [Sat, 8 Sep 2001 02:28:41 +0000 (02:28 +0000)]
Resolve compile errors on unix.
Rename psqlodbc.def -> psqlodbc_win32.def.
Improve internal *declare cursor* handling
a little.
Hiroshi Inoue
Hiroshi Inoue [Fri, 7 Sep 2001 06:02:24 +0000 (06:02 +0000)]
1) Most driver options could be set per DSN.
2) Keep FE/BE protocol more precisely.
3) Improve procedure calls.
4) A trial to avoid PREMATURE execution(#ifdef'd now).
Hiroshi Inoue
Tatsuo Ishii [Thu, 6 Sep 2001 05:01:38 +0000 (05:01 +0000)]
Fix Karel's patch. Suggested by Eiji Tokuya
Tatsuo Ishii [Thu, 6 Sep 2001 04:57:30 +0000 (04:57 +0000)]
Commit Karel's patch.
-------------------------------------------------------------------
Subject: Re: [PATCHES] encoding names
From: Karel Zak <zakkr@zf.jcu.cz>
To: Peter Eisentraut <peter_e@gmx.net>
Cc: pgsql-patches <pgsql-patches@postgresql.org>
Date: Fri, 31 Aug 2001 17:24:38 +0200
On Thu, Aug 30, 2001 at 01:30:40AM +0200, Peter Eisentraut wrote:
> > - convert encoding 'name' to 'id'
>
> I thought we decided not to add functions returning "new" names until we
> know exactly what the new names should be, and pending schema
Ok, the patch not to add functions.
> better
>
> ...(): encoding name too long
Fixed.
I found new bug in command/variable.c in parse_client_encoding(), nobody
probably never see this error:
if (pg_set_client_encoding(encoding))
{
elog(ERROR, "Conversion between %s and %s is not supported",
value, GetDatabaseEncodingName());
}
because pg_set_client_encoding() returns -1 for error and 0 as true.
It's fixed too.
IMHO it can be apply.
Karel
PS:
* following files are renamed:
src/utils/mb/Unicode/KOI8_to_utf8.map -->
src/utils/mb/Unicode/koi8r_to_utf8.map
src/utils/mb/Unicode/WIN_to_utf8.map -->
src/utils/mb/Unicode/win1251_to_utf8.map
src/utils/mb/Unicode/utf8_to_KOI8.map -->
src/utils/mb/Unicode/utf8_to_koi8r.map
src/utils/mb/Unicode/utf8_to_WIN.map -->
src/utils/mb/Unicode/utf8_to_win1251.map
* new file:
src/utils/mb/encname.c
* removed file:
src/utils/mb/common.c
--
Karel Zak <zakkr@zf.jcu.cz>
http://home.zf.jcu.cz/~zakkr/
C, PostgreSQL, PHP, WWW, http://docs.linux.cz, http://mape.jcu.cz
Hiroshi Inoue [Tue, 28 Aug 2001 05:52:13 +0000 (05:52 +0000)]
Fix a wrong error handling.
Peter Eisentraut [Mon, 27 Aug 2001 00:38:55 +0000 (00:38 +0000)]
Do not install the odbc header files, per discussion on odbc list.
Hiroshi Inoue [Mon, 27 Aug 2001 00:18:03 +0000 (00:18 +0000)]
Fix a complie error on Windows platform.
Peter Eisentraut [Fri, 24 Aug 2001 14:07:50 +0000 (14:07 +0000)]
Rename config.h to pg_config.h and os.h to pg_config_os.h, fix a number of
places that were including the wrong files.
Hiroshi Inoue [Tue, 21 Aug 2001 05:21:09 +0000 (05:21 +0000)]
Fix a lot of compile errors on unix.
Fix '\\' handling for bytea type.
Bruce Momjian [Tue, 21 Aug 2001 00:33:28 +0000 (00:33 +0000)]
Add SCM_CREDS to get owner of unix-domain socket on BSD-like systems.
Hiroshi Inoue [Sat, 18 Aug 2001 04:30:47 +0000 (04:30 +0000)]
1) Change all internal SQL function calls from
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).
Bruce Momjian [Fri, 17 Aug 2001 02:59:20 +0000 (02:59 +0000)]
Add 4-byte MD5 salt.
Bruce Momjian [Wed, 15 Aug 2001 18:42:16 +0000 (18:42 +0000)]
Use MD5 for wire protocol encryption for >= 7.2 client/server.
Allow pg_shadow to be MD5 encrypted.
Add ENCRYPTED/UNENCRYPTED option to CREATE/ALTER user.
Add password_encryption postgresql.conf option.
Update wire protocol version to 2.1.
Hiroshi Inoue [Fri, 10 Aug 2001 01:24:15 +0000 (01:24 +0000)]
Add new files for the preparation.
Bruce Momjian [Sat, 4 Aug 2001 19:33:49 +0000 (19:33 +0000)]
> 1) When a row is retrieved, and then a SQL_FETCH_FIRST is issued, the
check
> in convert.c
> does not consider the fact that the value in the field has been altered to
> be a '1' if the
> backend handed it a 't'. The net result being that the first row on any
> subsequent queries
> has all it's boolean set to 0.
Aidan Mountford
Hiroshi Inoue [Wed, 27 Jun 2001 07:38:07 +0000 (07:38 +0000)]
Handle Procedure calls.
Now the version is 7.01.0006.
Hiroshi Inoue [Fri, 22 Jun 2001 05:59:43 +0000 (05:59 +0000)]
Change SQLPrimaryKeys() so that it detects the primary key
other than tablename_pkey.
Hiroshi Inoue [Wed, 20 Jun 2001 07:06:40 +0000 (07:06 +0000)]
Change the driver so that large error messages are returned
by multiple SQLError calls.
Hiroshi Inoue [Tue, 19 Jun 2001 03:17:12 +0000 (03:17 +0000)]
Corrected the check for *message truncated* for the future use.
Hiroshi Inoue [Tue, 19 Jun 2001 02:17:06 +0000 (02:17 +0000)]
Changed the error handling as follows.
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.
Hiroshi Inoue [Mon, 18 Jun 2001 02:16:09 +0000 (02:16 +0000)]
Fix *escape* handling in copy_statement_with_parameters(was my fault).
Bruce Momjian [Tue, 12 Jun 2001 21:51:27 +0000 (21:51 +0000)]
Fix compile error caused by patch application.
Bruce Momjian [Tue, 12 Jun 2001 15:14:47 +0000 (15:14 +0000)]
I installed postgres 7.1 with --enable-odbc. I then installed
tclodbc (http://sourceforge.net/projects/tclodbc) and libiodbc-2.50.3
(http://www.iodbc.org/dist/libiodbc-2.50.3.tar.gz). I could not
get either to work... postgres would not find the global odbcinst.ini
file. I traced this to src/interfaces/odbc/gpps.c -- here are the
many things I think are wrong:
Run tclodbc and do a ``database db <DSNname>'' where ``DSNname'' is
one of the DSN's in /usr/local/etc/odbcinst.ini (or wherever the
global ini file is installed.) The result is always the error
message that ``one of server,port,database,etc. are missing''.
Run libiodbc-2.50.3/samples/odbctest <DSNname>. The command fails
to connect to the database and just exits.
Dave Bodenstab
Bruce Momjian [Wed, 30 May 2001 20:52:34 +0000 (20:52 +0000)]
Remove OLD_FILE_NAMING code. No longer used.
Hiroshi Inoue [Fri, 25 May 2001 08:12:32 +0000 (08:12 +0000)]
Get rid of the following size limit.
1) Query size limit(was 65536) for >=7.0 servers.
2) Text size limit(was 8190) for 7.1 servers.
Hiroshi Inoue [Thu, 17 May 2001 02:56:37 +0000 (02:56 +0000)]
1) Decrease the size of some buffers.
2) Repair broken SQLStatistics().
Bruce Momjian [Wed, 16 May 2001 22:36:03 +0000 (22:36 +0000)]
Add missing paren.
Bruce Momjian [Wed, 16 May 2001 17:47:27 +0000 (17:47 +0000)]
Fix for HASH for index lookups in ODBC.
Bruce Momjian [Mon, 14 May 2001 21:53:16 +0000 (21:53 +0000)]
Remove columns pg_index.haskeytype and pg_index.indisclustered. Not used.
Bruce Momjian [Fri, 11 May 2001 01:46:33 +0000 (01:46 +0000)]
Stamp CVS as 7.2. Update all interface version numbers. This is the
time to do it, not during beta because people are using this stuff in
production sometimes.
Bruce Momjian [Tue, 8 May 2001 17:12:36 +0000 (17:12 +0000)]
Run pgindent on ODBC code only, to reformat new comments.
Bruce Momjian [Tue, 8 May 2001 17:06:18 +0000 (17:06 +0000)]
ODBC source code cleanup patch. Should match rest of PostgreSQL code better.
Bruce Momjian [Thu, 3 May 2001 21:38:45 +0000 (21:38 +0000)]
BTW it does not add encodign it just patches existing one (KOI8) to
support two - KOI8-R and KOI8-U (latter is superset of the former if
not to take to the account pseudographics)
Andy Rysin
Tom Lane [Wed, 2 May 2001 14:23:40 +0000 (14:23 +0000)]
Previous commit mistakenly converted all newlines to DOS style (CR/LF).
Convert back to Unix style --- it seems some versions of nmake insist
on this.
Hiroshi Inoue [Tue, 1 May 2001 00:47:06 +0000 (00:47 +0000)]
1) fix bugs reported by Andrea Aime.
2) fix a bug reported by Jan Wieck.
psqlodbc is 7.01.0005 now.
Hiroshi Inoue [Mon, 23 Apr 2001 01:41:06 +0000 (01:41 +0000)]
1) Decrease the size of needlessly large buffers. For example, it
resolved the stack over flow errors reported by Johann Zuschlag.
2) Support {oj syntax for 71. servers.
Hiroshi Inoue [Mon, 23 Apr 2001 01:00:49 +0000 (01:00 +0000)]
A patch to fix the following bugs.
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
Hiroshi Inoue [Tue, 17 Apr 2001 07:30:53 +0000 (07:30 +0000)]
The renewal of README thanks to Dave Page.
Hiroshi Inoue [Fri, 6 Apr 2001 15:31:28 +0000 (15:31 +0000)]
Sorry my previous change was a mistake.
Hiroshi Inoue [Fri, 6 Apr 2001 09:23:44 +0000 (09:23 +0000)]
1) Fit the precision of floating point to that of server side
(fix by Hiroki kataoka).
2) Ensure the definition of atof()(#include stdlib.h).
(suggestion by Masaaki Sakaida).
Bruce Momjian [Tue, 27 Mar 2001 04:00:55 +0000 (04:00 +0000)]
ODBC source code cleanup. Mostly alignment of #define constants.
Hiroshi Inoue [Mon, 26 Mar 2001 09:34:17 +0000 (09:34 +0000)]
Add multibyte support
Tom Lane [Sun, 25 Mar 2001 19:30:28 +0000 (19:30 +0000)]
Fix unportable assumptions about alignment of local char[n] variables.
Bruce Momjian [Fri, 23 Mar 2001 04:49:58 +0000 (04:49 +0000)]
Fix comments that were mis-wrapped, for Tom Lane.
Bruce Momjian [Thu, 22 Mar 2001 06:16:21 +0000 (06:16 +0000)]
Remove dashes in comments that don't need them, rewrap with pgindent.
Bruce Momjian [Thu, 22 Mar 2001 04:01:38 +0000 (04:01 +0000)]
pgindent run. Make it all clean.
Hiroshi Inoue [Wed, 21 Mar 2001 16:26:17 +0000 (16:26 +0000)]
The attached patch fixes win32.mak which got broken by the Multibyte mod
:-(, and tidies it up a little as well.
Regards, Dave.
Hiroshi Inoue [Wed, 21 Mar 2001 09:35:25 +0000 (09:35 +0000)]
a fix from Eiji Tokuya.
Hiroshi Inoue [Fri, 16 Mar 2001 13:03:04 +0000 (13:03 +0000)]
Oops I forgot to add new files for multibyte support.
Sorry Eiji.
Hiroshi Inoue [Fri, 16 Mar 2001 01:17:23 +0000 (01:17 +0000)]
Add multibyte support.
Provide an extenisible scheme of encoding conversion.
As the first step, SJIS and BIG5 are supported.
From now on multibyte people would be happy to use
this psqlodbc driver.
Eiji Tokuya e-tokuya@mail.sankyo-unyu.co.jp
Hiroshi Inoue [Wed, 14 Mar 2001 09:10:04 +0000 (09:10 +0000)]
Fix some memory leaks.
Hiroshi Inoue [Tue, 13 Mar 2001 09:03:24 +0000 (09:03 +0000)]
The attached file contains the registry settings required to install the
ODBC driver on Windows 9X/ME/NT/2K when using the later versions of the
driver that don't have the Installshield installation:
1) Install psqlodbc.dll in to C:\Windows\System or C:\Winnt\System32
2) Add the registry settings in the attached file using regedit.
A useful addition to src/interfaces/odbc perhaps?
Regards, Dave.
Tom Lane [Sat, 10 Mar 2001 23:12:28 +0000 (23:12 +0000)]
Provide a hack to let initialization happen on platforms for which
psqlodbc.c's constructor-making techniques do not work.
Tom Lane [Sat, 10 Mar 2001 22:30:57 +0000 (22:30 +0000)]
Do not accept values from sections following the specified section.
Hiroshi Inoue [Sat, 10 Mar 2001 03:34:57 +0000 (03:34 +0000)]
1)Allow the access to indexes with up to 16 keys.
2)Fix some memory leaks.
3)Change some bogus error messages.
Hiroshi Inoue [Thu, 22 Feb 2001 03:39:30 +0000 (03:39 +0000)]
Fix the bug report [ODBC] select from a table having more than 32 fields:
reported by Matteo Cavalleri.
Great thanks to Tom for his accurate analysis.
Tom Lane [Tue, 20 Feb 2001 19:39:24 +0000 (19:39 +0000)]
Remove unportable #warning directive.
Peter Eisentraut [Tue, 20 Feb 2001 19:20:29 +0000 (19:20 +0000)]
Make sure -L and -I's for our source tree are always before system include
or library directories on the command line.
Tom Lane [Fri, 16 Feb 2001 03:49:40 +0000 (03:49 +0000)]
ichar() has been renamed to chr(), so fix translation table.
Hiroshi Inoue [Fri, 16 Feb 2001 03:10:09 +0000 (03:10 +0000)]
Add casting for numeric/float4/float8 type value
automatically to compensate the lack of automatic
conversion functionality of PostgreSQL server.
For example if there's a numeric type binding
1.2567 --> 1.2567::numeric.
I hope this change would enable the use of numeric
type in MS-Access etc.
Thanks Hiroki Kataoka for his checking my code.
Hiroshi Inoue [Thu, 15 Feb 2001 05:32:00 +0000 (05:32 +0000)]
1) Change transaction boundary in autocommit off mode
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).
Bruce Momjian [Wed, 14 Feb 2001 06:10:31 +0000 (06:10 +0000)]
Add 7.X to dialog box.
Bruce Momjian [Wed, 14 Feb 2001 05:45:46 +0000 (05:45 +0000)]
Back out all ODBC formatting changes, and back out removal of <6.4
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.
Bruce Momjian [Mon, 12 Feb 2001 22:50:06 +0000 (22:50 +0000)]
Attached is a makefile for the ODBC driver for use under win32. It has been
tested only with MS VC++ 6.0SP4 using nmake.
Dave Page
Bruce Momjian [Mon, 12 Feb 2001 21:45:24 +0000 (21:45 +0000)]
New MS resource file, pgindented.
Bruce Momjian [Mon, 12 Feb 2001 17:54:02 +0000 (17:54 +0000)]
Update ODBC resource MS-generated file.
Bruce Momjian [Mon, 12 Feb 2001 14:17:06 +0000 (14:17 +0000)]
Change more // comments.
Bruce Momjian [Mon, 12 Feb 2001 12:59:22 +0000 (12:59 +0000)]
Replace // comments from file for MS products.
Tom Lane [Sun, 11 Feb 2001 23:46:40 +0000 (23:46 +0000)]
SOCK_get_next_byte should not return garbage after error/EOF. Return
zero bytes instead.
Bruce Momjian [Sun, 11 Feb 2001 23:34:08 +0000 (23:34 +0000)]
Remove unneeded shutdown() call, per Tom Lane.
Bruce Momjian [Sun, 11 Feb 2001 13:58:12 +0000 (13:58 +0000)]
More cleanups.
Bruce Momjian [Sun, 11 Feb 2001 13:53:42 +0000 (13:53 +0000)]
Include file alignment fixes.
Bruce Momjian [Sun, 11 Feb 2001 13:15:28 +0000 (13:15 +0000)]
Move X packet before shutdown().
Bruce Momjian [Sun, 11 Feb 2001 05:58:41 +0000 (05:58 +0000)]
Source alignment cleanups.
Bruce Momjian [Sun, 11 Feb 2001 05:13:52 +0000 (05:13 +0000)]
More cleanup.
Bruce Momjian [Sun, 11 Feb 2001 05:04:47 +0000 (05:04 +0000)]
More cleanup.
Bruce Momjian [Sun, 11 Feb 2001 04:56:58 +0000 (04:56 +0000)]
Cleanup of source.