psqlodbc.git
24 years agoChange SC_fetch() to not retrieve data in case the
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.

24 years agoAccept an INTERVAL argument for SET TIME ZONE per SQL99.
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.

24 years agoFix logic in insert() function.
Peter Eisentraut [Sat, 13 Oct 2001 19:16:32 +0000 (19:16 +0000)]
Fix logic in insert() function.

24 years agoUpdate the version of psqlodbc driver.
Hiroshi Inoue [Fri, 12 Oct 2001 09:41:49 +0000 (09:41 +0000)]
Update the version of psqlodbc driver.

24 years agoFix the bug reported by Chris Lee.
Hiroshi Inoue [Fri, 12 Oct 2001 01:08:51 +0000 (01:08 +0000)]
Fix the bug reported by Chris Lee.

24 years agoAllow optional () after current_user, session_user, user, current_time,
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.

24 years agoFix sloppiness about static vs non-static declaration of functions.
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.

24 years agoFix the bug about boolean type handling reported by
Hiroshi Inoue [Sat, 29 Sep 2001 02:48:04 +0000 (02:48 +0000)]
Fix the bug about boolean type handling reported by
Kristis Markis.

24 years ago1) Fix compile errors on Windows.
Hiroshi Inoue [Mon, 24 Sep 2001 00:05:59 +0000 (00:05 +0000)]
1) Fix compile errors on Windows.
2) Change *Common* --> *Default*.

24 years agoDon't refer to odbcinst.ini by absolute path. SQLGetPrivateProfileString
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.

24 years agoProvide some initial support for building the ODBC driver for
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.

24 years ago1) Avoid an overflow of connection string for Access(Microsoft Jet).
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".

24 years agoChange an *if condition*.
Hiroshi Inoue [Fri, 14 Sep 2001 06:46:45 +0000 (06:46 +0000)]
Change an *if condition*.

Hiroshi Inoue

24 years ago1) Improve the implementation of *Disallow Premature* for
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

24 years agoFix a coversation error with pre 6.4 versions.
Hiroshi Inoue [Fri, 14 Sep 2001 01:50:33 +0000 (01:50 +0000)]
Fix a coversation error with pre 6.4 versions.

Hiroshi Inoue

24 years agoAdd missing paren to ODBC compiles.
Bruce Momjian [Thu, 13 Sep 2001 22:39:29 +0000 (22:39 +0000)]
Add missing paren to ODBC compiles.

24 years ago1) Not export ODBC 3.0 functions.
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.

24 years agoLink ODBC driver with -lnsl and -lsocket, for Solaris.
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)

24 years agoFix some multibyte related bugs.
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

24 years agoChange dialog windows.
Hiroshi Inoue [Mon, 10 Sep 2001 10:13:30 +0000 (10:13 +0000)]
Change dialog windows.

24 years ago1) Fix SQLForeignKeys() in multibyte mode.
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

24 years agoImprove declare/fetch mode a little.
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

24 years agoMove updateCommon() into Win32 block because it is only used there.
Bruce Momjian [Sat, 8 Sep 2001 02:48:53 +0000 (02:48 +0000)]
Move updateCommon() into Win32 block because it is only used there.

24 years agoResolve compile errors on unix.
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

24 years ago1) Most driver options could be set per DSN.
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

24 years agoFix Karel's patch. Suggested by Eiji Tokuya
Tatsuo Ishii [Thu, 6 Sep 2001 05:01:38 +0000 (05:01 +0000)]
Fix Karel's patch. Suggested by Eiji Tokuya

24 years agoCommit Karel's patch.
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

24 years agoFix a wrong error handling.
Hiroshi Inoue [Tue, 28 Aug 2001 05:52:13 +0000 (05:52 +0000)]
Fix a wrong error handling.

24 years agoDo not install the odbc header files, per discussion on odbc list.
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.

24 years agoFix a complie error on Windows platform.
Hiroshi Inoue [Mon, 27 Aug 2001 00:18:03 +0000 (00:18 +0000)]
Fix a complie error on Windows platform.

24 years agoRename config.h to pg_config.h and os.h to pg_config_os.h, fix a number of
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.

24 years agoFix a lot of compile errors on unix.
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.

24 years agoAdd SCM_CREDS to get owner of unix-domain socket on BSD-like systems.
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.

24 years ago1) Change all internal SQL function calls from
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).

24 years agoAdd 4-byte MD5 salt.
Bruce Momjian [Fri, 17 Aug 2001 02:59:20 +0000 (02:59 +0000)]
Add 4-byte MD5 salt.

24 years agoUse MD5 for wire protocol encryption for >= 7.2 client/server.
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.

24 years agoAdd new files for the preparation.
Hiroshi Inoue [Fri, 10 Aug 2001 01:24:15 +0000 (01:24 +0000)]
Add new files for the preparation.

24 years ago> 1) When a row is retrieved, and then a SQL_FETCH_FIRST is issued, the
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

24 years agoHandle Procedure calls.
Hiroshi Inoue [Wed, 27 Jun 2001 07:38:07 +0000 (07:38 +0000)]
Handle Procedure calls.
Now the version is 7.01.0006.

24 years agoChange SQLPrimaryKeys() so that it detects the primary key
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.

24 years agoChange the driver so that large error messages are returned
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.

24 years agoCorrected the check for *message truncated* for the future use.
Hiroshi Inoue [Tue, 19 Jun 2001 03:17:12 +0000 (03:17 +0000)]
Corrected the check for *message truncated* for the future use.

24 years agoChanged the error handling as follows.
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.

24 years agoFix *escape* handling in copy_statement_with_parameters(was my fault).
Hiroshi Inoue [Mon, 18 Jun 2001 02:16:09 +0000 (02:16 +0000)]
Fix *escape* handling in copy_statement_with_parameters(was my fault).

24 years agoFix compile error caused by patch application.
Bruce Momjian [Tue, 12 Jun 2001 21:51:27 +0000 (21:51 +0000)]
Fix compile error caused by patch application.

24 years agoI installed postgres 7.1 with --enable-odbc. I then installed
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

24 years agoRemove OLD_FILE_NAMING code. No longer used.
Bruce Momjian [Wed, 30 May 2001 20:52:34 +0000 (20:52 +0000)]
Remove OLD_FILE_NAMING code.  No longer used.

24 years agoGet rid of the following size limit.
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.

24 years ago1) Decrease the size of some buffers.
Hiroshi Inoue [Thu, 17 May 2001 02:56:37 +0000 (02:56 +0000)]
1) Decrease the size of some buffers.
2) Repair broken SQLStatistics().

24 years agoAdd missing paren.
Bruce Momjian [Wed, 16 May 2001 22:36:03 +0000 (22:36 +0000)]
Add missing paren.

24 years agoFix for HASH for index lookups in ODBC.
Bruce Momjian [Wed, 16 May 2001 17:47:27 +0000 (17:47 +0000)]
Fix for HASH for index lookups in ODBC.

24 years agoRemove columns pg_index.haskeytype and pg_index.indisclustered. Not used.
Bruce Momjian [Mon, 14 May 2001 21:53:16 +0000 (21:53 +0000)]
Remove columns pg_index.haskeytype and pg_index.indisclustered.  Not used.

24 years agoStamp CVS as 7.2. Update all interface version numbers. This is the
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.

24 years agoRun pgindent on ODBC code only, to reformat new comments.
Bruce Momjian [Tue, 8 May 2001 17:12:36 +0000 (17:12 +0000)]
Run pgindent on ODBC code only, to reformat new comments.

24 years agoODBC source code cleanup patch. Should match rest of PostgreSQL code better.
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.

24 years agoBTW it does not add encodign it just patches existing one (KOI8) to REL7_1_STABLE REL7_1_2
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

24 years agoPrevious commit mistakenly converted all newlines to DOS style (CR/LF).
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.

24 years ago1) fix bugs reported by Andrea Aime.
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.

24 years ago1) Decrease the size of needlessly large buffers. For example, it
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.

24 years agoA patch to fix the following bugs.
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

24 years agoThe renewal of README thanks to Dave Page.
Hiroshi Inoue [Tue, 17 Apr 2001 07:30:53 +0000 (07:30 +0000)]
The renewal of README thanks to Dave Page.

24 years agoSorry my previous change was a mistake. REL7_1
Hiroshi Inoue [Fri, 6 Apr 2001 15:31:28 +0000 (15:31 +0000)]
Sorry my previous change was a mistake.

24 years ago1) Fit the precision of floating point to that of server side
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).

24 years agoODBC source code cleanup. Mostly alignment of #define constants.
Bruce Momjian [Tue, 27 Mar 2001 04:00:55 +0000 (04:00 +0000)]
ODBC source code cleanup.  Mostly alignment of #define constants.

24 years agoAdd multibyte support
Hiroshi Inoue [Mon, 26 Mar 2001 09:34:17 +0000 (09:34 +0000)]
Add multibyte support

24 years agoFix unportable assumptions about alignment of local char[n] variables.
Tom Lane [Sun, 25 Mar 2001 19:30:28 +0000 (19:30 +0000)]
Fix unportable assumptions about alignment of local char[n] variables.

24 years agoFix comments that were mis-wrapped, for Tom Lane.
Bruce Momjian [Fri, 23 Mar 2001 04:49:58 +0000 (04:49 +0000)]
Fix comments that were mis-wrapped, for Tom Lane.

24 years agoRemove dashes in comments that don't need them, rewrap with pgindent.
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.

24 years agopgindent run. Make it all clean.
Bruce Momjian [Thu, 22 Mar 2001 04:01:38 +0000 (04:01 +0000)]
pgindent run.  Make it all clean.

24 years agoThe attached patch fixes win32.mak which got broken by the Multibyte mod
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.

24 years agoa fix from Eiji Tokuya.
Hiroshi Inoue [Wed, 21 Mar 2001 09:35:25 +0000 (09:35 +0000)]
a fix from Eiji Tokuya.

24 years agoOops I forgot to add new files for multibyte support.
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.

24 years agoAdd multibyte support.
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

24 years agoFix some memory leaks.
Hiroshi Inoue [Wed, 14 Mar 2001 09:10:04 +0000 (09:10 +0000)]
Fix some memory leaks.

24 years agoThe attached file contains the registry settings required to install the
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.

24 years agoProvide a hack to let initialization happen on platforms for which
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.

24 years agoDo not accept values from sections following the specified section.
Tom Lane [Sat, 10 Mar 2001 22:30:57 +0000 (22:30 +0000)]
Do not accept values from sections following the specified section.

24 years ago1)Allow the access to indexes with up to 16 keys.
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.

24 years agoFix the bug report [ODBC] select from a table having more than 32 fields:
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.

24 years agoRemove unportable #warning directive.
Tom Lane [Tue, 20 Feb 2001 19:39:24 +0000 (19:39 +0000)]
Remove unportable #warning directive.

24 years agoMake sure -L and -I's for our source tree are always before system include
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.

24 years agoichar() has been renamed to chr(), so fix translation table.
Tom Lane [Fri, 16 Feb 2001 03:49:40 +0000 (03:49 +0000)]
ichar() has been renamed to chr(), so fix translation table.

24 years agoAdd casting for numeric/float4/float8 type value
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.

24 years ago1) Change transaction boundary in autocommit off mode
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).

24 years agoAdd 7.X to dialog box.
Bruce Momjian [Wed, 14 Feb 2001 06:10:31 +0000 (06:10 +0000)]
Add 7.X to dialog box.

24 years agoBack out all ODBC formatting changes, and back out removal of <6.4
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.

24 years agoAttached is a makefile for the ODBC driver for use under win32. It has been
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

24 years agoNew MS resource file, pgindented.
Bruce Momjian [Mon, 12 Feb 2001 21:45:24 +0000 (21:45 +0000)]
New MS resource file, pgindented.

24 years agoUpdate ODBC resource MS-generated file.
Bruce Momjian [Mon, 12 Feb 2001 17:54:02 +0000 (17:54 +0000)]
Update ODBC resource MS-generated file.

24 years agoChange more // comments.
Bruce Momjian [Mon, 12 Feb 2001 14:17:06 +0000 (14:17 +0000)]
Change more // comments.

24 years agoReplace // comments from file for MS products.
Bruce Momjian [Mon, 12 Feb 2001 12:59:22 +0000 (12:59 +0000)]
Replace // comments from file for MS products.

24 years agoSOCK_get_next_byte should not return garbage after error/EOF. Return
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.

24 years agoRemove unneeded shutdown() call, per Tom Lane.
Bruce Momjian [Sun, 11 Feb 2001 23:34:08 +0000 (23:34 +0000)]
Remove unneeded shutdown() call, per Tom Lane.

24 years agoMore cleanups.
Bruce Momjian [Sun, 11 Feb 2001 13:58:12 +0000 (13:58 +0000)]
More cleanups.

24 years agoInclude file alignment fixes.
Bruce Momjian [Sun, 11 Feb 2001 13:53:42 +0000 (13:53 +0000)]
Include file alignment fixes.

24 years agoMove X packet before shutdown().
Bruce Momjian [Sun, 11 Feb 2001 13:15:28 +0000 (13:15 +0000)]
Move X packet before shutdown().

24 years agoSource alignment cleanups.
Bruce Momjian [Sun, 11 Feb 2001 05:58:41 +0000 (05:58 +0000)]
Source alignment cleanups.

24 years agoMore cleanup.
Bruce Momjian [Sun, 11 Feb 2001 05:13:52 +0000 (05:13 +0000)]
More cleanup.

24 years agoMore cleanup.
Bruce Momjian [Sun, 11 Feb 2001 05:04:47 +0000 (05:04 +0000)]
More cleanup.

24 years agoCleanup of source.
Bruce Momjian [Sun, 11 Feb 2001 04:56:58 +0000 (04:56 +0000)]
Cleanup of source.