~ubuntu-branches/ubuntu/oneiric/psqlodbc/oneiric : revision 5

1

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

2

<html>

3

<head>

4

5

<title>psqlODBC release notes</title>

6

</HEAD>

7

8

9

10

<h1>psqlODBC release notes</h1>

11

<hr>

12

<h2>psqlODBC 08.01.0200 Release</h2>

13

psqlODBC 08.01.0200 contains only documentation changes over the 08.01.0108

14

development build.

15

16

<li>Notes: psqlODBC 08.01.0108</li>

17

1) fix most warnings during build in x86_64 environment

18

2) fixed point of failure on x86_64 boxes

19

3) fixed autocommit = off behaviour with starting transactions when needed

20

4) quick hack againist access violation with Disallow premature -

21

this rarely used feature is still broken, but should no longer crash

22

5) report correct SQLSTATE in SQLGetDiagField and SQLGetDiagRec

23

24

<li>Notes: psqlODBC 08.01.0107</li>

25

1) fix next problem with calling implicit rollback in bad time

26

2) detecting transaction commands into if branch which mean backend

27

successfuly done the command. add support for "start transaction"

28

3) fix bug when mylog output can't be created

29

4) fix problem with SQLSetPos

30

5) fix problem with column length in CC_mapping

31

6) fix - typelen could be less then zero not only -1

32

33

<li>Notes: psqlODBC 08.01.0106</li>

34

1) fix problem with getting long text in unicode driver

35

2) fix sqlstate iin case of error in statement

36

3) doesn't call rollback in autocommit off or in manual transaction

37

4) remove obsolete parameter protocol

38

39

<li>Notes: psqlODBC 08.01.0105</li>

40

Changes:

41

1) fix problem with rollback aborted queries

42

2) SQLColumns or SQLColAttribute may return bad answer when Show system tables is turned off

43

3) adds support for ; delimited options in ConfigDSN

44

4) fixes problem with binding parameters and SQLCancel without SQLFreeStmt

45

46

<li>Notes: psqlODBC 08.01.0104</li>

47

Changes:

48

1) add commit after set basic options in SQLDriverConnect when autocommit is turned off

49

2) driver doesn't fail when there isn't bind enough parameters

50

3) collattributes doesn't work since switch to libpq.

51

There is still problem with select '' as xx from table

52

4) SQLTables after SQLExecDirect has problem with GetData for all rows

53

5) grow MAXKEYLEN for SQLConfigDataSource

54

6) repair behaviour of more queries in one statement

55

56

<li>Notes: psqlODBC 08.01.0103</li>

57

Changes:

58

1) RowCount problem in SELECT

59

2) Server side prepare - but only first run in allocated statement

60

(http://pgfoundry.org/tracker/index.php?func=detail&aid=1000460&group_id=1000125&atid=538)

61

3) Table names repeated in BDE with usedeclarefetch=1

62

4) Binding parameters are now freed in SQLCancel

63

5) Skip fetching data for commands

64

65

<li>Notes: psqlODBC 08.01.0102</li>

66

Changes:

67

1) Server side prepare now works correctly.

68

2) A bug in SQLTables that shows up in Borland SQL Explorer in

69

3) Declare/Fetch mode has been fixed.

70

4) A number of inconsistent internal APIs have been cleaned up. These

71

issues only showed up on some OS's.

72

5) Correct value returned by SQLGetInfo for

73

SQL_CATALOG_LOCATION/SQL_QUALIFIER_LOCATION. This prevented use of the

74

driver in Visual Studio 2005.

75

76

The last four numbers will represent the build. If the last 2 digits are

77

both zero, a stable version is indicated. If the last two digits are

78

non-zero, it is a development snapshot.

79

So, starting with the next stable release, we will have:

80

08.01.0200 - Stable

81

08.01.0201 - Development

82

...

83

...

84

08.01.0299 - Development

85

08.01.0300 - Stable

86

Of course, we won't necessarily have 99 snaphosts between stable releases!

87

88

<li>Notes: psqlODBC 08.01.0101</li>

89

Changes:

90

This release fixes a serious problem in non-declare/fetch mode where

91

recordsets over the configured declare/fetch cache size were returned

92

incorrectly. It is advised that all users of v08.01.0100 upgrade as soon

93

as possible.

94

95

<h2>psqlODBC 08.01.0100 Release</h2>

96

This release represents a major change to the driver over previous versions;

97

in particular, the network code has been replaced with the PostgreSQL libpq

98

library. This allows us to more easily take advantage of updates and new

99

features that might be introduced to the PostgreSQL wire protocol, and also

100

allowed us to upgrade straight away to the version 3 protocol which was

101

previously unsupported. We were also able to add SSL support, as well as

102

Kerberos authentication support.

103

104

>From this release, two versions of the driver are provided for Windows,

105

'PostgreSQL ANSI' which supports single and multibyte applications through

106

the ANSI ODBC API, and 'PostgreSQL Unicode' which provides Unicode support

107

through the Unicode ODBC API. On Unix systems, the driver type may be

108

selected via a configure option.

109

110

psqlODBC may be downloaded from http://www.postgresql.org/ftp/odbc/versions/

111

in source, Windows Installer, merge module, and basic zip file formats.

112

113

Please post any bug reports to the pgsql-odbc@postgresql.org mailing list.

114

115

I'd like to take this opportunity to thank all those involved with the

116

development, testing and bug fixing of the updated driver.

117

PostgreSQL Core Team

118

119

<li>Notes: psqlODBC 08.00.0102</li>

120

This is a bug fix release

121

of the pre-libpq version of the driver, specifically to fix a bug

122

affecting Unix users

123

(http://gborg.postgresql.org/project/psqlodbc/bugs/bugupdate.php?1176)

124

125

<h2>psqlODBC 08.00.0100 Release</h2>

126

The driver is available in source form, as well as a dll, merge module

127

and msi installer for Windows.

128

129

Regards, Dave.

130

131

<li>Notes: psqlODBC 08.00.0005</li>

132

This version

133

contains a some recent fixes, and is packaged in a new installer built

134

entirely using open source tools (specifically, the Wix toolkit).

135

136

<li>Notes: psqlODBC 08.00.0002</li>

137

This version of the driver is a minor update

138

with a fix to the string sizing code in SQLGetInfo, and removal of the

139

need for tables to be in the search path or public schema for them to be

140

returned by SQLTables.

141

142

<li>Notes: psqlODBC 08.00.0001</li>

143

The purpose of this version is to try to get something stable, with

144

proper schema/without OID support ready for the 8.0 release

145

(particularly the win32 release). To that end, this release is mainly a

146

quick cleanup of the following:

147

148

- GUI cleanup. Dialogues should behave better now and not have unlabeled

149

buttons or move around the screen in strange ways.

150

151

- Updateable Cursor support. This is largely experimental and is (I

152

believe) the cause of a least a couple of stability issues in the recent

153

snapshots. In this release it is marked 'experimental' on the setup

154

dialogue (only in English, if anyone can do the Japanese version, please

155

send a patch) and turned off by default.

156

157

I'd appreciate it if ppl could test it a little with Updateable Cursors

158

*turned off* and report any bugs.

159

160

<h2>psqlODBC 07.05.0001</h2>

161

This is version 07.05.0001. For those that don't know or don't recall

162

how the versioning works, the major and minor number track the latest

163

release of PostgreSQL that the driver is expected to work with. The

164

revision number is a bit more complex. The first two digits are the

165

version number, where even numbers are development versions, and odd are

166

release. The last two digits are the build number.

167

168

In other words, this driver is build 01 of development version 00, and

169

is expected to work with PostgreSQL 7.5dev. :-) The leading zeros are an

170

ODBC thing...

171

172

<h2>psqlODBC 07.03.0100 Release</h2>

173

I'm pleased to announce the long awaited new version of psqlODBC. This

174

release represents a major change in the packaging and distribution of

175

psqlODBC. In particular the following points should be noted:

176

177

1) The build number will now be used to indicate both the release number

178

(first 2 digits), and snapshot build number (last 2 digits). this

179

release is 0100, or release 1, snapshot 0. The first development

180

snapshot will become 0101, the second 0102 and so on. The next official

181

release should be 07.03.0200.

182

183

2) With this release, the ODBC 3 driver is now the default. The

184

filenames, driver names and their capabilities are as follows:

185

186

psqlodbc.dll PostgreSQL ODBC3.0 Level

187

driver

188

psqlodbc25.dll PostgreSQL Legacy ODBC2.5 Level

189

driver

190

psqlodbc30w.dll PostgreSQL Unicode (Beta) Beta quality ODBC3.0

191

level driver with Unicode support

192

193

3) The 3 drivers are no longer self contained. psqlodbc.dll is used as

194

the setup dll for all three drivers, hence no matter how you

195

redistribute or install the drivers, you should always include this

196

file.

197

198

In addition, this driver fixes an annoying problem with recent builds of

199

PostgreSQL on Redhat systems that have a particularly long compiler

200

version string that caused a buffer overflow resulting in a GPF on

201

Windows upon connection to the database.

202

The driver is released under the LGPL, and can be downloaded from the

203

Downloads page on the website at

204

http://gborg.postgresql.org/project/psqlodbc/projdisplay.php

205

206

<h2>=== gborg.postgresql.org(This is the past history.) ===</h2>

207

1.33 by hinoue Annotate

208

Thu Feb 5 09:11:44 2004 (2 weeks, 3 days ago)

209

Changed since 1.32: +3 -3 [Select for Diff]

210

Diffs to version 1.32 (long / unified)

211

Diffs ignoring whitespace to version 1.32 (long / unified)

212

[7.3.0208]

213

1) Change catalog functions to search 'public' schema if a user

214

tries to search the user named schema and finds no record to

215

return.

216

2) Set the statement status to STMT_FINISHED(not STMT_PREPARED)

217

if the pre execution causes an error.

218

3) Adjust null terminator for SQL_C_WCHAR type.

219

4) Change getCharColumnSize to return max size when the

220

statement has no result.

221

5) Cache the number of parameters for statements.

222

223

1.32 by hinoue Annotate

224

Tue Jan 6 09:58:22 2004 (46 hours, 12 minutes ago)

225

Changed since 1.31: +3 -3 [Select for Diff]

226

Diffs to version 1.31 (long / unified)

227

Diffs ignoring whitespace to version 1.31 (long / unified)

228

1) Correct the handling of SQL_C_ULONG (for *nix).

229

2) Prevent plan deallocation errors when the transaction

230

is in abort status.

231

3) Avoid a connection failure when notice message arrives.

232

4) Improve the handling of mutex(critical section).

233

5) Correct the cursor open check.

234

6) Change the Unicode driver to set the NULL terminator

235

of SQL_C_WCHAR type data properly.

236

7) Add some m(re)alloc error check.

237

8) Add proper cleanup steps for some functions.

238

9) Return proper min & max scale for timestamp data type.

239

10) Return proper scale for timestamp data fields.

240

11) Fix the bug that .009 numeric generates .9 output. (George A.J)

241

242

1.31 by hinoue Annotate

243

Tue Dec 9 05:01:38 2003 (44 hours, 22 minutes ago)

244

Changed since 1.30: +3 -3 [Select for Diff]

245

Diffs to version 1.30 (long / unified)

246

Diffs ignoring whitespace to version 1.30 (long / unified)

247

[7.3.0205]

248

(for *nix)

249

1. Detect -lsocket for some platforms.

250

2. Handle unix domain sockets.

251

3. EINTR safety for send/recv.

252

4. Set TCP_NDEALY option for inet connections.

253

<1-4: thanks to Hartmut Raschick>

254

5. Use recursive mutex if possible.

255

6. Add descriptor.c to Makefile.

256

(for Windows)

257

7. Automatic setting of client encoding for latin1(9).

258

(common)

259

8. Avoid those notorious core dumps when logging on hitting

260

"null" data...

261

<8: thanls to Hartmut Raschick>

262

9. Removed a static varible for thread-safety.

263

10. Improve the performance of keyset-driven fetch operation.

264

11. Map (var)char type to SQL type more properly.

265

12. Change create_params for NUMERIC type to (precison, scale).

266

13. Add type cast to remove some compiler warnings.

267

268

1.30 by hinoue

269

Wed Nov 12 05:15:21 2003 (8 days, 1 hour ago)

270

Changed since 1.29: +3 -3 [Select for Diff]

271

Diffs to version 1.29 (long / unified)

272

Diffs ignoring whitespace to version 1.29 (long / unified)

273

[7.03.0204]

274

1) Clear statements' cursors on commit/rollback.

275

2) Change SQLColumns, SQLTablePrivileges to take show_system_tables

276

option into account.

277

3) When an ODBC 2.x application working with an ODBC 3.x driver

278

1.calls SQLExecDirect, SQLExecute, or SQLParamData, and a searched

279

2.update or delete statement was executed but did not affect any

280

3.rows at the data source, the ODBC 3.x driver should return

281

4.SQL_SUCCESS. When an ODBC 3.x application working with an ODBC

282

5.3.x driver calls SQLExecDirect, SQLExecute, or SQLParamData

283

6.with the same result, the ODBC 3.x driver should return SQL_NO_DATA.

284

285

1.29 by hinoue

286

Mon Nov 10 02:10:07 2003 (10 hours, 1 minute ago)

287

Changed since 1.28: +3 -3 [Select for Diff]

288

Diffs to version 1.28 (long / unified)

289

Diffs ignoring whitespace to version 1.28 (long / unified)

290

[7.03.0203]

291

1) Add conversion from text to SQL_C_BINARY(bug report from Brad Wilson).

292

2) Change SQLColumns, SQLTables etc to initialize the statement handle

293

properly(bug report from Yutaka Tanida).

294

3) Improve the handling of mutex under *nix(bug report from Steve Wampler).

295

296

1.28 by hinoue

297

Wed Nov 5 20:35:02 2003 (4 days, 15 hours ago)

298

Changed since 1.27: +3 -3 [Select for Diff]

299

Diffs to version 1.27 (long / unified)

300

Diffs ignoring whitespace to version 1.27 (long / unified)

301

[7.03.0202]

302

1) Improve SQLColAttributes(SQL_COLUMN_DISPLAY_SIZE) (bug report from Benjamin Riefenstahl).

303

2) Correct EN_set_odbc3 macro (bug report from tomas@nocrew.org(Tomas Sk��e)).

304

305

1.27 by hinoue

306

Sat Oct 25 00:19:23 2003 (2 weeks, 2 days ago)

307

Changed since 1.26: +3 -3 [Select for Diff]

308

Diffs to version 1.26 (long / unified)

309

Diffs ignoring whitespace to version 1.26 (long / unified)

310

[7.03.0201]

311

1) Revise the handling of descriptors and implement SQLCopyDesc.

312

2) Handle data_at_execution columns for SQLSetPos or SQLBulkOperations.

313

314

1.26 by dpage

315

Wed Oct 22 09:07:25 2003 (2 weeks, 5 days ago)

316

CVS Tags: REL-07_03_0200

317

Changed since 1.25: +3 -3 [Select for Diff]

318

Diffs to version 1.25 (long / unified)

319

Diffs ignoring whitespace to version 1.25 (long / unified)

320

Version number bump.

321

322

1.25 by hinoue

323

Sun Oct 19 22:37:42 2003 (3 weeks ago)

324

Changed since 1.24: +3 -3 [Select for Diff]

325

Diffs to version 1.24 (long / unified)

326

Diffs ignoring whitespace to version 1.24 (long / unified)

327

[7.03.0116]

328

1. Fix a memory leak in case of updatable KEYSET_DRIVEN cursors.

329

2. Change SQLMoreResults to initialize the cursor position.

330

3. Hopefully, SQLDescribeCol() returns a more appropriate

331

error code(SQLSTATE).

332

333

1.24 by hinoue

334

Fri Sep 19 05:25:17 2003 (7 weeks, 3 days ago)

335

Changed since 1.23: +3 -3 [Select for Diff]

336

Diffs to version 1.23 (long / unified)

337

Diffs ignoring whitespace to version 1.23 (long / unified)

338

1) Correct the return info for SQLGetInfo(.., SQL_CURSOR_COMMIT

339

(ROLLBACK)_BEHAVIOR) call.

340

2) Explictly reject the SQLBrowseConnect call.

341

342

1.23 by hinoue

343

Mon Sep 15 04:25:03 2003 (8 weeks ago)

344

Changed since 1.22: +3 -3 [Select for Diff]

345

Diffs to version 1.22 (long / unified)

346

Diffs ignoring whitespace to version 1.22 (long / unified)

347

1. Serialize the connection use for communication(multi-thread).

348

2. Let escape strings case-insensitive.

349

350

1.22 by hinoue

351

Tue Sep 2 07:25:53 2003 (2 months, 1 week ago)

352

Changed since 1.21: +1 -1 [Select for Diff]

353

Diffs to version 1.21 (long / unified)

354

Diffs ignoring whitespace to version 1.21 (long / unified)

355

Fix a bug when handling data_at_execution parameter array

356

reported by Jol Valentine <jolv@genaware.com>.

357

358

1.21 by hinoue

359

Wed Aug 27 06:17:53 2003 (2 months, 2 weeks ago)

360

Changed since 1.20: +3 -3 [Select for Diff]

361

Diffs to version 1.20 (long / unified)

362

Diffs ignoring whitespace to version 1.20 (long / unified)

363

1) Fix a bug on SQLSetStmtAttr(.., SQL_CONCURRENCY) reported by Shachar Shemesh.

364

2) Apply a patch to changes the storage type of the debug "func" variables

365

to be stored in the constant area of the program(Shachar Shemesh).

366

3) Correct the column size in case of bytea as LO.

367

368

1.20 by hinoue

369

Wed Jul 30 21:57:50 2003 (3 months, 1 week ago)

370

Changed since 1.19: +3 -3 [Select for Diff]

371

Diffs to version 1.19 (long / unified)

372

Diffs ignoring whitespace to version 1.19 (long / unified)

373

1) Distinguish the rowset size for SQLFetch(Scroll) from that for

374

SQLExtendedFetch.

375

2) Implement SQLGetDiagFieldW() for the Unicode driver.

376

377

1.19 by hinoue

378

Fri Jul 11 06:47:17 2003 (4 months ago)

379

Changed since 1.18: +3 -3 [Select for Diff]

380

Diffs to version 1.18 (long / unified)

381

Diffs ignoring whitespace to version 1.18 (long / unified)

382

Improve SQLGetDiagField so that an MFC appliaction reports

383

error messages properly(bug report from Silvio Scarpati).

384

385

1.18 by hinoue

386

Wed Jul 9 04:09:11 2003 (4 months ago)

387

Changed since 1.17: +3 -3 [Select for Diff]

388

Diffs to version 1.17 (long / unified)

389

Diffs ignoring whitespace to version 1.17 (long / unified)

390

Add quotes around table names to use ::regclass in parse.c .

391

392

1.17 by hinoue

393

Sun Jun 29 23:51:24 2003 (4 months, 1 week ago)

394

Changed since 1.16: +3 -3 [Select for Diff]

395

Diffs to version 1.16 (long / unified)

396

Diffs ignoring whitespace to version 1.16 (long / unified)

397

Change SQLGetFunctions to contain ODBC3 APIs.

398

399

1.16 by hinoue

400

Thu May 29 22:30:33 2003 (5 months, 1 week ago)

401

Changed since 1.15: +3 -3 [Select for Diff]

402

Diffs to version 1.15 (long / unified)

403

Diffs ignoring whitespace to version 1.15 (long / unified)

404

1) Improve the SQL_C_VARBOOKMARK type handling.

405

2) Cleanup copy_and_convert_field() a little.

406

3) Set an error number and an error message for SQLAllocHandle(

407

SQL_HANDLE_DESC).

408

409

1.15 by hinoue

410

Tue May 27 22:26:37 2003 (5 months, 2 weeks ago)

411

Changed since 1.14: +3 -3 [Select for Diff]

412

Diffs to version 1.14 (long / unified)

413

Diffs ignoring whitespace to version 1.14 (long / unified)

414

Fix a bug about a bookmark handling in SQLBulkOperaitons(SQL_ADD,..)

415

416

1.14 by hinoue

417

Tue May 27 19:23:41 2003 (5 months, 2 weeks ago)

418

Changed since 1.13: +3 -3 [Select for Diff]

419

Diffs to version 1.13 (long / unified)

420

Diffs ignoring whitespace to version 1.13 (long / unified)

421

Remove date cast(::date) from the conversion of {d escape before

422

7.3 servers. 7.2 servers are poor in implicit cast from date ->

423

timestamp without time zone.

424

425

1.13 by hinoue

426

Tue May 27 01:20:09 2003 (5 months, 2 weeks ago)

427

Changed since 1.12: +3 -3 [Select for Diff]

428

Diffs to version 1.12 (long / unified)

429

Diffs ignoring whitespace to version 1.12 (long / unified)

430

1) Corrent the handling of bookmark in SQLBulkOperations.

431

2) Correct the calculation of a global index in SC_pos_add.

432

3) Cleanup global/rowset/resultset index handling a little.

433

434

1.12 by hinoue

435

Sun May 25 20:47:50 2003 (5 months, 2 weeks ago)

436

Changed since 1.11: +3 -3 [Select for Diff]

437

Diffs to version 1.11 (long / unified)

438

Diffs ignoring whitespace to version 1.11 (long / unified)

439

Correct a handling of offset in SQLBulkOperations.

440

441

1.11 by hinoue

442

Tue May 20 10:11:22 2003 (5 months, 3 weeks ago)

443

Changed since 1.10: +4 -4 [Select for Diff]

444

Diffs to version 1.10 (long / unified)

445

Diffs ignoring whitespace to version 1.10 (long / unified)

446

Fix a crash bug in SQLDriverConnect().

447

448

1.10 by hinoue

449

Tue May 20 06:39:28 2003 (5 months, 3 weeks ago)

450

Changed since 1.9: +3 -3 [Select for Diff]

451

Diffs to version 1.9 (long / unified)

452

Diffs ignoring whitespace to version 1.9 (long / unified)

453

The previous change wasn't in time of 7.3.0100.

454

It belongs to 7.03.0101.

455

456

1.9 by hinoue

457

Mon May 19 06:12:09 2003 (5 months, 3 weeks ago)

458

Changed since 1.8: +1 -1 [Select for Diff]

459

Diffs to version 1.8 (long / unified)

460

Diffs ignoring whitespace to version 1.8 (long / unified)

461

1) Revert a *int8 as* DSN option to *numeric* for MS Jet.

462

2) Add a SQL_CA2_SENSITIVITY_ADDTIONS mask to the reply for

463

SQLGetInfo(.., SQL_ATTR_KEYSET_DRIVEN_CURSOR_ATTRIBUTES2)

464

which would make a little OpenOffice happy.

465

3) Fix a bug in SQLGetInfo(.., SQL_ATTR_ROW_NUMBER) for keyset_driven

466

cursors.

467

468

1.8 by dpage

469

Thu May 15 04:24:40 2003 (5 months, 3 weeks ago)

470

CVS Tags: REL-07_03_0100

471

Changed since 1.7: +3 -3 [Select for Diff]

472

Diffs to version 1.7 (long / unified)

473

Diffs ignoring whitespace to version 1.7 (long / unified)

474

Updates for 07.03.0100

475

476

1.7 by dpage

477

Thu May 15 03:38:16 2003 (5 months, 3 weeks ago)

478

Changed since 1.6: +3 -3 [Select for Diff]

479

Diffs to version 1.6 (long / unified)

480

Diffs ignoring whitespace to version 1.6 (long / unified)

481

Updates for 07.03.0001

482

483

1.6 by hinoue

484

Mon May 12 11:44:08 2003 (5 months, 4 weeks ago)

485

Changed since 1.5: +3 -3 [Select for Diff]

486

Diffs to version 1.5 (long / unified)

487

Diffs ignoring whitespace to version 1.5 (long / unified)

488

1) Add a *bytea as LO* DSN option button.

489

2) Add japanese resources to psqlodbc.rc.

490

3) Add a dialog for the driver change.

491

492

1.5 by hinoue

493

Wed Apr 23 05:49:47 2003 (6 months, 2 weeks ago)

494

Changed since 1.4: +3 -3 [Select for Diff]

495

Diffs to version 1.4 (long / unified)

496

Diffs ignoring whitespace to version 1.4 (long / unified)

497

1) Avoid password leak in the log.

498

2) Reduce time() calls for the performance.

499

3) Improve the handling of per Driver resource.

500

4) #define HAVE_STRTOLL

501

etc.

502

503

1.4 by hinoue

504

Wed Nov 27 04:30:53 2002 (11 months, 1 week ago)

505

CVS Tags: REL-07_02_0005

506

Changed since 1.3: +3 -3 [Select for Diff]

507

Diffs to version 1.3 (long / unified)

508

Diffs ignoring whitespace to version 1.3 (long / unified)

509

Upgrade to 7.2.0005.

510

511

1.3 by hinoue

512

Thu Oct 10 02:37:54 2002 (13 months ago)

513

CVS Tags: REL-07_02_0004

514

Changed since 1.2: +3 -3 [Select for Diff]

515

Diffs to version 1.2 (long / unified)

516

Diffs ignoring whitespace to version 1.2 (long / unified)

517

1) Change SQLDescribeCol or SQLColAttribute to return right ResultNumCols for

518

keyset/static cursors.

519

2) Change PG_TYPE_TEXT -> PG_TYPE_VARCHAR for character columns of the

520

result of catalog functions (bug report from Mike Mascari).

521

522

1.2 by hinoue

523

Mon Sep 23 04:08:22 2002 (13 months, 2 weeks ago)

524

CVS Tags: REL-07_02_0003

525

Changed since 1.1: +3 -3 [Select for Diff]

526

Diffs to version 1.1 (long / unified)

527

Diffs ignoring whitespace to version 1.1 (long / unified)

528

1) Removed most static variables for thread safety.

529

2) Trial implementation of the thread safe driver under

530

Windows.

531

3) Fix a bug about DSN options setting.

532

4) Fix a bug about Driver options setting.

533

5) Implement SQLProcedureColumns().

534

6) Changed default numeric precision/scale.

535

7) Fix some memory leaks in Unicode driver.

536

8) datetime -> timestamp with time zone since 7.0.

537

9) Change manually started(using begin) transactions never

538

be implicitly committed.

539

540

1.1 by inoue

541

Thu May 9 00:10:22 2002 (18 months ago)

542

[Select for Diff]

543

Add a file for version control.

544

545

546

</body>

547

</html>

1

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

2

<html>

3

<head>

4

5

<title>psqlODBC release notes</title>

6

</HEAD>

7

8

9

10

<h1>psqlODBC release notes</h1>

11

<hr>

12

<h2>psqlODBC 08.03.0200 Release </h2>

13

Changes:

14

1.) Fix a bug in socket which uses a socket variable.

15

2.) Support column alias without "as" so that links from the SQLServer work.

16

3.) Take ';' into account when the driver adds "for read only" clause.

17

4.) Use the E'.. ' notation not only in '=' expressions but also in LIKE expressions.

18

5.) Change to return milliseconds parts for timestamp fields.

19

6.) Change to return a specific sqlstate in case of multiple parameters.

20

7.) Fix bug of the selection not using SSL.

21

22

<li>Notes: psqlODBC 08.03.0100</li>

23

Changes:

24

1.) Correct the flow of trial of multi protocols and fix related bugs about handling of connection errors.

25

2.) Use SSPI service for SSL support when libpq is unavailable.

26

3.) Fix a bug in copy_and_convert_field() when fetching bookmark columns. This bug could occur in case no suitable?

27

lo type is found.

28

4.) Improve the parse statement operation so that it detect srf in (from clause).

29

5.) Correct the COLUMN_LENGTH return value of SQLColumns() for varchar/bpchar type columns (Unicode driver).

30

6.) Change to not return database name if case of MS Query.

31

7.) The first cut to use Windows SSPI. The trial to use Schannel service for SSL support.

32

8.) Be more careful about <for locking clause> in UseDeclareFetch mode. "for read only" clause for read only queries

33

for 8.3 or later servers for safety.

34

35

<li>Notes: psqlODBC 08.02.0500</li>

36

Changes:

37

1.) Correct the format of Bind message under 64bit environment.

38

2.) Fixed build of without OpenSSL.

39

40

<li>Notes: psqlODBC 08.02.0403</li>

41

Changes:

42

1.) Support SQLColAttribute for MS specific SQL_CA_SS_COLUMN_KEY. Some MS applications use this.

43

2.) Improve the check of updatability of queries by checking if they have multiple tables.

44

3.) Reduce the round trip overhead in FE/BE communications(especially in useDeclareFetch mode).

45

4.) Fix a bug in ResolveOneParam() pointed out by Rainer Bauer.

46

5.) Add a flag which lets SQLTables() show only accessible tables.

47

6.) The unicode driver now can handle utf-16 surrogate pairs.

48

49

<li>Notes: psqlODBC 08.02.0402</li>

50

Changes:

51

1.) Fix some bugs in case without MSDTC support.

52

2.) Refine the realloc handling.

53

3.) Put back the @@IDENTITY implementation so as not to use lastval().

54

4.) Change SQLColumns() to return correct column length in the Unicode driver.

55

5.) Remove the connection count limitation.

56

6.) Fix Protocol=7.4--1 notation (should be Protocol=7.4).

57

7.) Fix a typo in socket.c (bug report from Rainer bauer).

58

8.) Add CC_set_autocommit to psqlodbc(a).def files.

59

9.) Handle Standard_conforming_strings.

60

10.) Handle standard_conforming_strings also in case via libpq.

61

11.) Fix a bug which doesn't free connection list properly.

62

12.) Fix DelayLoadDLL was made explicit of psqlodbc.proj file.

63

64

<li>Notes: psqlODBC 08.02.0401</li>

65

Changes:

66

1.) Fix a bug which checking join is confused by CR+LF.

67

2.) Handle AUTOCOMMIT mode more carefully in a distributed transaction so as not to issue COMMIT unexpectedly.

68

3.) Allow the UNIX domain configuration (the same as libpq).

69

4.) Fixed the automake/autoconf scripts.(by Peter Eisentraut)

70

71

<li>Notes: psqlODBC 08.02.0400</li>

72

Changes:

73

1.) Fixed control binding of SetField problem.

74

2.) Fixed pgenlist.h losts to the release package.

75

76

<li>Notes: psqlODBC 08.02.0300</li>

77

Changes:

78

1.) Allow non-admin or Vista users to create log fils in the home

79

directory.

80

2.) Fix an index over bug which causes a crash or an unexpected result.

81

82

<li>Notes: psqlODBC 08.02.0205</li>

83

Changes:

84

1.) Append DETAIL messages to GetDiag...() messages.

85

2.) Use SQL_SUCCEEDED macros so as to simplify the code.

86

3.) Use lastval() function to replace IDENTITY on 8.1 or later servers.

87

4.) Remove WSAStartup() and WSACleanup() from DllMain.

88

5.) Load libpq from the driver's folder.

89

6.) Use QR_get_value_backend_int/_text() funcs instead of QR_get_value_backend_row().

90

7.) Improve the implemetation of SQLSetPos(.., SQL_ADD/SQL_UPDATE) using the 8.2 new feature INSERT/UPDATE .. returning.

91

8.) Seaparate DTC code as a Delayload DLL.

92

93

<li>Notes: psqlODBC 08.02.0204</li>

94

Changes:

95

1.) Configure the combination of time.h and sys/time.h.

96

2.) Treat the tables in information_schema as system tables.

97

3.) Correct the precision of SQL_NUMERIC_STRUCT.

98

4.) Change the default max varchar size from 254 to 255.

99

5.) Reset the fields information properly in case of SQLMoreResults.

100

6.) Implement SQLDescribeParam() also in case of multi-command queries.

101

7.) Handle dollar-quotes more properly.

102

8.) Provide a make option to link dynamic multithread library.

103

9.) Set the default nullablity to TRUE.

104

10.) Parse command delimiters(;) more correctly.

105

11.) Use QR_get_value_backend_text() or QR_get_value_backend_int()

106

12.) instead of QR_get_value_backend_row().

107

13.) Apply Parse statement or disallow premature properly.

108

14.) Reset current_schema cache in case 'set search_path ..' command is issued.

109

110

<li>Notes: psqlODBC 08.02.0203</li>

111

Changes:

112

1) Fix a bug which forgets unnamed plans too early especially when handling large objects.

113

2) Don't treat charcters whose value >= 128 as alphanumeric in case of conversion of binary data to bytea.

114

3) Change ConfigDSN() so that it takes the options in Setup Dialog page 1 into account.

115

4) Simplify the memory management of statements'columns info so as to prevent memory leaks or a crash in parse_statement etc.

116

5) SQLTables("", SQL_ALL_SCHEMAS. "", ..) now returns a list of valid schemas.

117

6) SQLTables("", "", "", SQL_ALL_TABLE_TYPES) now returns a list of valid table types.

118

7) SQLGetInfo SQL_DATABASE_NAME now returns the database name.

119

8) Improve the automatic setting mechanism of the client_encoding for Windows code page 125x (ANSI drivers only).

120

121

<li>Notes: psqlODBC 08.02.0202</li>

122

Changes:

123

1) Change to use NULL indicator instead of the length buffer in SQLFetch.

124

2) Fix long -> serial conversion error in MS Access.

125

126

<li>Notes: psqlODBC 08.02.0201</li>

127

Changes:

128

1) Ditinguish the indicaitor and the octet_length field of APD clcearly.

129

2) Handle @@IDENTITY more generally.

130

3) Take outer join into account so as to evaluate nullability.

131

4) Fix a bug about Keyset-driven cursors.

132

133

<li>Notes: psqlODBC 08.02.0200</li>

134

Changes:

135

1) Fix some bugs or warnings on 64 bit OS.

136

2) Avoid backend crash caused by Execute Requests for committed holdable cursors.

137

138

<li>Notes: psqlODBC 08.02.0105</li>

139

Changes:

140

1) SQLStatistics now returns indices based on expression also.

141

2) Add a TEST button on the setup dialog.

142

143

<li>Notes: psqlODBC 08.02.0104</li>

144

Changes:

145

1) Take 64bit mode into account for the format parameter of (s(n))printf, sscanf etc.

146

2) getpid() instead of _getpid()

147

3) SQLGetInfo(SQL_NULL_COLLATION) now returns SQL_NC_HIGH instead of SQL_NC_END

148

4) Remove the function SQLParamOptions from ODBC3.0.

149

150

<li>Notes: psqlODBC 08.02.0103</li>

151

Changes:

152

1) Improve the handling of connection error messages.

153

2) Add an option to convert empty strings to NULL.

154

3) Handle domain type as the basetype.

155

4) Fake MSS in case of not only SQLExecute but also SQLParamData.

156

5) Prevent SQLColumns from displaying system columns.

157

6) Unload delayLoaded libraries on dll detach (not on disconnect time).

158

7) Fix a SQLGetDiagField crash bug.

159

8) Fix a insertion count bug.

160

9) Take win98 cases into account a little.

161

162

<li>Notes: psqlODBC 08.02.0102</li>

163

Changes:

164

1) Compensate a loss of report of being Jet when using MS Access.

165

2) Add NULL <-> "" date converion function for FOXPRO and

166

revise parse/describe/execute mechanism.

167

3) Miscellaneous type changes for 64 bit drivers.

168

169

<li>Notes: psqlODBC 08.02.0101</li>

170

Changes:

171

1) Delayload import XOLEHLP.dll so that the driver can be loaded

172

without the existence of the dll.

173

2) Fix a simple password authentication bug.

174

3) Fix a buffer overrun bug which prevented the connection phase

175

from retrying another version appropriately.

176

4) Handle multi-addresses of a specified host properly.

177

5) Refine the socket handling(connect, recv, send).

178

6) Display more appropriate error messages in the connection phase.

179

180

<li>Notes: psqlODBC 08.02.0100</li>

181

Changes:

182

1) Return to Unicode/ANSI driver distribution as some users still find one works better than the other for them.

183

2) Improve connection error message in case of invalid protocol characters.

184

3) Initial value has set MSDTC=no of VC6 (Support of MSDTC is only VC7 and VC8)

185

4) Addition which is a driver name in a resource (Unicode or ANSI)

186

187

<li>Notes: psqlODBC 08.02.0007</li>

188

Changes:

189

1) Fix some SQLPrimaryKey, SQLForeignKey bugs.

190

Fill PK_NAME or FK_NAME columns.

191

Return right update_rule values.

192

Remove duplicates.

193

2) Handle SQL_ALL_SCHEMAS parameter in SQLTables.

194

3) Handle unaligned indicator/length buffers more properly.

195

4) Fix a bug in ProcedureColumns in case of set returning functions.

196

5) Fix a buffer overrun in handle_notice_message (Bart Samuel)

197

6) Fix a output parameters problem (Bart Samuel)

198

7) Hold the connection lock while a rollbackable statement running.

199

8) Add Extra Opts option to the DSN option setupdialog.

200

201

<li>Notes: psqlODBC 08.02.0006</li>

202

Changes:

203

1) Add an option to fake Microsoft SQL Server which would improve SERIAL type handling.

204

2) Add support for LOGIN_TIMEOUT.

205

3) Improve Statement error handling about the reference of Connection error.

206

4) Improve the handling BIGINT type in the OSs without having strtoll().

207

5) Support ODBC CONVERT scalar functions in some cases.

208

6) Close qlog, mylog files on detach dll.

209

7) Improve comunication performance in case of the driver's original socket.

210

8) Fix send a close

211

9) Support of IPV6.

212

213

8.2.0003-8.2.0005 was skipped by the situation.

214

215

<li>Notes: psqlODBC 08.02.0002</li>

216

Changes:

217

1) SQL injections via ODBC catalog function calls.

218

2) Fix SQLNumParams problem related to literal or dollar quote.

219

3) Call libpq in case of Kerberos authentication.

220

4) Add E' before literal for after 8.1 severs.

221

5) Return the correct error message in case of no password.

222

6) Take E'...' literal expression into account.

223

7) Fix an SQL_C_WCHAR -> numeric type conversion problem.

224

8) Refine the handling of io or output parameters.

225

9) Refine the dollar quote handling.

226

10) Fix the client_encoding mismatch problem.

227

11) Fix for SQLStatistics returns UNKNOWN instead of real column names.

228

229

<li>Notes: psqlODBC 08.02.0001</li>

230

Changes:

231

1) updated CVS tip to the REL-07_03_ENHANCED branch

232

2) updated the installer for the single driver distribution

233

3) standardised various filenames that were previously based on build types

234

4) standardised the build on ODBC version 3.51

235

<hr>

236

237

Releases from this point onwards are based on the REL-07_03_ENHANCED code branch

238

of psqlODBC - please see

239

<a href="http://archives.postgresql.org/pgsql-odbc/2006-02/msg00131.php">http://archives.postgresql.org/pgsql-odbc/2006-02/msg00131.php</a>

240

for further details.

241

242

The following changes are based on the 07.03 codebase

243

244

<pre>

245

[7.3.0261]

246

247

1.Handle the converion from text-like field to SQL_C_BINARY more properly.

248

2.Make buffer extension in SQLPutData more effective.

249

3.Reply SQL_CONVERT_xxxx correctly for SQLGetInfo request.

250

4.Reply DBMS_NAME, DBMS_VERSION correctly for SQLGetInfo request.

251

5.Not call show max_identifier_length in PG 7.4.

252

6.Change adjustLikePattern() to take literal quote(') into account.

253

7.Fix a bug in memory debug routine.

254

8.Change the multibyte encoding list to match that of the current

255

offical driver.

256

9.Change SC_clear_error() to call CC_clear_error() also.

257

10.Change the length values returned when they are unknown for

258

SQLDescribeCol or SQLColAttribute requests.

259

260

[7.3.0261]

261

262

1.Fix the handling of *too small buffer* in the Unicode version.

263

2.Fix the behavior of DiscardStatementSvp which resets the status too early.

264

3.Fix the bug in PGAPI_ParamData which fails to count the number

265

of parameters.

266

4.Allow blanks in password.

267

5.Add an option to force abbreviation of connection string.

268

6.Fix the handling of "PROTOCOL=x.x-x" in the connction string.

269

7.Fix the loadlib module of *nix.

270

271

[7.3.0260]

272

273

1. Change delay load import library mechanism(libpq,openssl)

274

2. Compile Optimization correspondence.

275

3. SQLForeignKeys ResultSet accuracy correspondence.

276

277

[7.3.0258]

278

279

1. bug fix: SQLBulkOperations rollback option.

280

There was a case where a rollback was not published in SQLBulkOperations

281

as option specification at the time of error generating.

282

283

[7.3.0257]

284

285

1. Fault correction of the division SQLGetData to SQL_C_WCHAR.

286

287

[7.3.0256]

288

289

1. SQLSetPos does not position to current-row to renewal of unblock cursor.

290

(Data is unacquirable by SQLGetData etc.)

291

292

[7.3.0255]

293

294

1. bug fix: leak of a return value clearance

295

2. Correspondence Windows English Dialog.

296

3. Changes into the libpq link method.

297

298

[7.3.0254]

299

300

1. Setting menu of SSLMODE is added.

301

2. Correspondence to domain type lo (an approvement is still required).

302

3. bug fix: LIBPQ version cancellation request transmitting correspondence.

303

4. Correction of the exclusive control between threads of SQLCancel

304

305

[7.3.0253]

306

307

1. Compilation of escape usage.

308

(preliminaries corresponding to a literal-escape abolition schedule)

309

2. Correspondence of libpq and openssl.

310

3. SQLProcedureColumns()RESULT_COLS row is outputted.

311

4. bug fix: server-side prepare the number check of parameters.

312

5. bug fix: parameter bind without a parameter marker is disregarded.

313

6. bug fix: Retrying without carrying out a select operation to EWOULDBLOCK of socket/SSL-read.

314

7. Abolition of abolition in manual_result mode, TupleList, and TupleNode employment

315

316

[7.3.0252]

317

318

1. Bug fix: Multi-byte employment by a table name etc.

319

2. The text (varchar/char) type key assignation was enabled by MS-Access.

320

321

[7.3.0251]

322

323

1. Suppression of SQLColumnPrivilege support

324

It rejects using information_schema.column_privileges.

325

2. Binary mode is used for a bytea type parameter value setup.

326

(Performs by the sequence of SQLPrepare->SQLExecute by server_side_prepare employment)

327

3. Coexistence of LO type and bytea type.

328

When the parameter of LongVarBinary exists not by SQLPrepare->SQLExecute but by

329

SQLExecDirect at the time of direct dispatching, the Parse/Describe function of

330

a protocol 3 is used, the model in saver of LongVarBinary is acquired beforehand,

331

and a bytea type and LO type are recognized.

332

333

[Feature of Driver7.3.025x]

334

335

1. Correspondence protocol 3

336

Options, such as client encoding, are set up by the start-up packet.

337

This makes the most of the mechanism of Parse/Bind/Execute.

338

.The outfit of SQLDescribeParam

339

.PREPARE/EXECUTE is changed from the command base to the protocol base.

340

.FETCH command is changed to an Execute request as it has come out.

341

.Moreover, bytea and lo type coexistence is possible.

342

.Others...

343

344

2. Enhancement in declare/fetch mode (7.4 or later)

345

Even if a certain renewal occurs on the way by holdable cursor exploitation,

346

a commitment is possible in comfort.

347

Moreover, the static update cursor was supported.

348

(Only for SQLSetPos correspondence, SQLBulkOperation are un-supporting)

349

Bug fix of the cursor which can be updated.

350

351

3. Rollback support of a syntactical unit at the time of an error.(8.0 or later)

352

Can choose from three Transaction module,Statement module,Nothing.

353

These can be specified by data source setup.

354

355

4. Output parameter support (8.1 or later)

356

Corresponded to the output parameter of the function introduced by 8.1.

357

(Only the return value of a function was supported before.)

358

</pre>

359

<hr>

360

<h2>psqlODBC 08.01.0200 Release</h2>

361

psqlODBC 08.01.0200 contains only documentation changes over the 08.01.0108

362

development build.

363

364

<li>Notes: psqlODBC 08.01.0108</li>

365

1) fix most warnings during build in x86_64 environment

366

2) fixed point of failure on x86_64 boxes

367

3) fixed autocommit = off behaviour with starting transactions when needed

368

4) quick hack againist access violation with Disallow premature -

369

this rarely used feature is still broken, but should no longer crash

370

5) report correct SQLSTATE in SQLGetDiagField and SQLGetDiagRec

371

372

<li>Notes: psqlODBC 08.01.0107</li>

373

1) fix next problem with calling implicit rollback in bad time

374

2) detecting transaction commands into if branch which mean backend

375

successfuly done the command. add support for "start transaction"

376

3) fix bug when mylog output can't be created

377

4) fix problem with SQLSetPos

378

5) fix problem with column length in CC_mapping

379

6) fix - typelen could be less then zero not only -1

380

381

<li>Notes: psqlODBC 08.01.0106</li>

382

1) fix problem with getting long text in unicode driver

383

2) fix sqlstate iin case of error in statement

384

3) doesn't call rollback in autocommit off or in manual transaction

385

4) remove obsolete parameter protocol

386

387

<li>Notes: psqlODBC 08.01.0105</li>

388

Changes:

389

1) fix problem with rollback aborted queries

390

2) SQLColumns or SQLColAttribute may return bad answer when Show system tables is turned off

391

3) adds support for ; delimited options in ConfigDSN

392

4) fixes problem with binding parameters and SQLCancel without SQLFreeStmt

393

394

<li>Notes: psqlODBC 08.01.0104</li>

395

Changes:

396

1) add commit after set basic options in SQLDriverConnect when autocommit is turned off

397

2) driver doesn't fail when there isn't bind enough parameters

398

3) collattributes doesn't work since switch to libpq.

399

There is still problem with select '' as xx from table

400

4) SQLTables after SQLExecDirect has problem with GetData for all rows

401

5) grow MAXKEYLEN for SQLConfigDataSource

402

6) repair behaviour of more queries in one statement

403

404

<li>Notes: psqlODBC 08.01.0103</li>

405

Changes:

406

1) RowCount problem in SELECT

407

2) Server side prepare - but only first run in allocated statement

408

(http://pgfoundry.org/tracker/index.php?func=detail&aid=1000460&group_id=1000125&atid=538)

409

3) Table names repeated in BDE with usedeclarefetch=1

410

4) Binding parameters are now freed in SQLCancel

411

5) Skip fetching data for commands

412

413

<li>Notes: psqlODBC 08.01.0102</li>

414

Changes:

415

1) Server side prepare now works correctly.

416

2) A bug in SQLTables that shows up in Borland SQL Explorer in

417

3) Declare/Fetch mode has been fixed.

418

4) A number of inconsistent internal APIs have been cleaned up. These

419

issues only showed up on some OS's.

420

5) Correct value returned by SQLGetInfo for

421

SQL_CATALOG_LOCATION/SQL_QUALIFIER_LOCATION. This prevented use of the

422

driver in Visual Studio 2005.

423

424

The last four numbers will represent the build. If the last 2 digits are

425

both zero, a stable version is indicated. If the last two digits are

426

non-zero, it is a development snapshot.

427

So, starting with the next stable release, we will have:

428

08.01.0200 - Stable

429

08.01.0201 - Development

430

...

431

...

432

08.01.0299 - Development

433

08.01.0300 - Stable

434

Of course, we won't necessarily have 99 snaphosts between stable releases!

435

436

<li>Notes: psqlODBC 08.01.0101</li>

437

Changes:

438

This release fixes a serious problem in non-declare/fetch mode where

439

recordsets over the configured declare/fetch cache size were returned

440

incorrectly. It is advised that all users of v08.01.0100 upgrade as soon

441

as possible.

442

443

<h2>psqlODBC 08.01.0100 Release</h2>

444

This release represents a major change to the driver over previous versions;

445

in particular, the network code has been replaced with the PostgreSQL libpq

446

library. This allows us to more easily take advantage of updates and new

447

features that might be introduced to the PostgreSQL wire protocol, and also

448

allowed us to upgrade straight away to the version 3 protocol which was

449

previously unsupported. We were also able to add SSL support, as well as

450

Kerberos authentication support.

451

452

>From this release, two versions of the driver are provided for Windows,

453

'PostgreSQL ANSI' which supports single and multibyte applications through

454

the ANSI ODBC API, and 'PostgreSQL Unicode' which provides Unicode support

455

through the Unicode ODBC API. On Unix systems, the driver type may be

456

selected via a configure option.

457

458

psqlODBC may be downloaded from http://www.postgresql.org/ftp/odbc/versions/

459

in source, Windows Installer, merge module, and basic zip file formats.

460

461

Please post any bug reports to the pgsql-odbc@postgresql.org mailing list.

462

463

I'd like to take this opportunity to thank all those involved with the

464

development, testing and bug fixing of the updated driver.

465

PostgreSQL Core Team

466

467

<li>Notes: psqlODBC 08.00.0102</li>

468

This is a bug fix release

469

of the pre-libpq version of the driver, specifically to fix a bug

470

affecting Unix users

471

(http://gborg.postgresql.org/project/psqlodbc/bugs/bugupdate.php?1176)

472

473

<h2>psqlODBC 08.00.0100 Release</h2>

474

The driver is available in source form, as well as a dll, merge module

475

and msi installer for Windows.

476

477

Regards, Dave.

478

479

<li>Notes: psqlODBC 08.00.0005</li>

480

This version

481

contains a some recent fixes, and is packaged in a new installer built

482

entirely using open source tools (specifically, the Wix toolkit).

483

484

<li>Notes: psqlODBC 08.00.0002</li>

485

This version of the driver is a minor update

486

with a fix to the string sizing code in SQLGetInfo, and removal of the

487

need for tables to be in the search path or public schema for them to be

488

returned by SQLTables.

489

490

<li>Notes: psqlODBC 08.00.0001</li>

491

The purpose of this version is to try to get something stable, with

492

proper schema/without OID support ready for the 8.0 release

493

(particularly the win32 release). To that end, this release is mainly a

494

quick cleanup of the following:

495

496

- GUI cleanup. Dialogues should behave better now and not have unlabeled

497

buttons or move around the screen in strange ways.

498

499

- Updateable Cursor support. This is largely experimental and is (I

500

believe) the cause of a least a couple of stability issues in the recent

501

snapshots. In this release it is marked 'experimental' on the setup

502

dialogue (only in English, if anyone can do the Japanese version, please

503

send a patch) and turned off by default.

504

505

I'd appreciate it if ppl could test it a little with Updateable Cursors

506

*turned off* and report any bugs.

507

508

<h2>psqlODBC 07.05.0001</h2>

509

This is version 07.05.0001. For those that don't know or don't recall

510

how the versioning works, the major and minor number track the latest

511

release of PostgreSQL that the driver is expected to work with. The

512

revision number is a bit more complex. The first two digits are the

513

version number, where even numbers are development versions, and odd are

514

release. The last two digits are the build number.

515

516

In other words, this driver is build 01 of development version 00, and

517

is expected to work with PostgreSQL 7.5dev. :-) The leading zeros are an

518

ODBC thing...

519

520

<h2>psqlODBC 07.03.0100 Release</h2>

521

I'm pleased to announce the long awaited new version of psqlODBC. This

522

release represents a major change in the packaging and distribution of

523

psqlODBC. In particular the following points should be noted:

524

525

1) The build number will now be used to indicate both the release number

526

(first 2 digits), and snapshot build number (last 2 digits). this

527

release is 0100, or release 1, snapshot 0. The first development

528

snapshot will become 0101, the second 0102 and so on. The next official

529

release should be 07.03.0200.

530

531

2) With this release, the ODBC 3 driver is now the default. The

532

filenames, driver names and their capabilities are as follows:

533

534

psqlodbc.dll PostgreSQL ODBC3.0 Level

535

driver

536

psqlodbc25.dll PostgreSQL Legacy ODBC2.5 Level

537

driver

538

psqlodbc30w.dll PostgreSQL Unicode (Beta) Beta quality ODBC3.0

539

level driver with Unicode support

540

541

3) The 3 drivers are no longer self contained. psqlodbc.dll is used as

542

the setup dll for all three drivers, hence no matter how you

543

redistribute or install the drivers, you should always include this

544

file.

545

546

In addition, this driver fixes an annoying problem with recent builds of

547

PostgreSQL on Redhat systems that have a particularly long compiler

548

version string that caused a buffer overflow resulting in a GPF on

549

Windows upon connection to the database.

550

The driver is released under the LGPL, and can be downloaded from the

551

Downloads page on the website at

552

http://gborg.postgresql.org/project/psqlodbc/projdisplay.php

553

554

<h2>=== gborg.postgresql.org(This is the past history.) ===</h2>

555

1.33 by hinoue Annotate

556

Thu Feb 5 09:11:44 2004 (2 weeks, 3 days ago)

557

Changed since 1.32: +3 -3 [Select for Diff]

558

Diffs to version 1.32 (long / unified)

559

Diffs ignoring whitespace to version 1.32 (long / unified)

560

[7.3.0208]

561

1) Change catalog functions to search 'public' schema if a user

562

tries to search the user named schema and finds no record to

563

return.

564

2) Set the statement status to STMT_FINISHED(not STMT_PREPARED)

565

if the pre execution causes an error.

566

3) Adjust null terminator for SQL_C_WCHAR type.

567

4) Change getCharColumnSize to return max size when the

568

statement has no result.

569

5) Cache the number of parameters for statements.

570

571

1.32 by hinoue Annotate

572

Tue Jan 6 09:58:22 2004 (46 hours, 12 minutes ago)

573

Changed since 1.31: +3 -3 [Select for Diff]

574

Diffs to version 1.31 (long / unified)

575

Diffs ignoring whitespace to version 1.31 (long / unified)

576

1) Correct the handling of SQL_C_ULONG (for *nix).

577

2) Prevent plan deallocation errors when the transaction

578

is in abort status.

579

3) Avoid a connection failure when notice message arrives.

580

4) Improve the handling of mutex(critical section).

581

5) Correct the cursor open check.

582

6) Change the Unicode driver to set the NULL terminator

583

of SQL_C_WCHAR type data properly.

584

7) Add some m(re)alloc error check.

585

8) Add proper cleanup steps for some functions.

586

9) Return proper min & max scale for timestamp data type.

587

10) Return proper scale for timestamp data fields.

588

11) Fix the bug that .009 numeric generates .9 output. (George A.J)

589

590

1.31 by hinoue Annotate

591

Tue Dec 9 05:01:38 2003 (44 hours, 22 minutes ago)

592

Changed since 1.30: +3 -3 [Select for Diff]

593

Diffs to version 1.30 (long / unified)

594

Diffs ignoring whitespace to version 1.30 (long / unified)

595

[7.3.0205]

596

(for *nix)

597

1. Detect -lsocket for some platforms.

598

2. Handle unix domain sockets.

599

3. EINTR safety for send/recv.

600

4. Set TCP_NDEALY option for inet connections.

601

<1-4: thanks to Hartmut Raschick>

602

5. Use recursive mutex if possible.

603

6. Add descriptor.c to Makefile.

604

(for Windows)

605

7. Automatic setting of client encoding for latin1(9).

606

(common)

607

8. Avoid those notorious core dumps when logging on hitting

608

"null" data...

609

<8: thanls to Hartmut Raschick>

610

9. Removed a static varible for thread-safety.

611

10. Improve the performance of keyset-driven fetch operation.

612

11. Map (var)char type to SQL type more properly.

613

12. Change create_params for NUMERIC type to (precison, scale).

614

13. Add type cast to remove some compiler warnings.

615

616

1.30 by hinoue

617

Wed Nov 12 05:15:21 2003 (8 days, 1 hour ago)

618

Changed since 1.29: +3 -3 [Select for Diff]

619

Diffs to version 1.29 (long / unified)

620

Diffs ignoring whitespace to version 1.29 (long / unified)

621

[7.03.0204]

622

1) Clear statements' cursors on commit/rollback.

623

2) Change SQLColumns, SQLTablePrivileges to take show_system_tables

624

option into account.

625

3) When an ODBC 2.x application working with an ODBC 3.x driver

626

1.calls SQLExecDirect, SQLExecute, or SQLParamData, and a searched

627

2.update or delete statement was executed but did not affect any

628

3.rows at the data source, the ODBC 3.x driver should return

629

4.SQL_SUCCESS. When an ODBC 3.x application working with an ODBC

630

5.3.x driver calls SQLExecDirect, SQLExecute, or SQLParamData

631

6.with the same result, the ODBC 3.x driver should return SQL_NO_DATA.

632

633

1.29 by hinoue

634

Mon Nov 10 02:10:07 2003 (10 hours, 1 minute ago)

635

Changed since 1.28: +3 -3 [Select for Diff]

636

Diffs to version 1.28 (long / unified)

637

Diffs ignoring whitespace to version 1.28 (long / unified)

638

[7.03.0203]

639

1) Add conversion from text to SQL_C_BINARY(bug report from Brad Wilson).

640

2) Change SQLColumns, SQLTables etc to initialize the statement handle

641

properly(bug report from Yutaka Tanida).

642

3) Improve the handling of mutex under *nix(bug report from Steve Wampler).

643

644

1.28 by hinoue

645

Wed Nov 5 20:35:02 2003 (4 days, 15 hours ago)

646

Changed since 1.27: +3 -3 [Select for Diff]

647

Diffs to version 1.27 (long / unified)

648

Diffs ignoring whitespace to version 1.27 (long / unified)

649

[7.03.0202]

650

1) Improve SQLColAttributes(SQL_COLUMN_DISPLAY_SIZE) (bug report from Benjamin Riefenstahl).

651

2) Correct EN_set_odbc3 macro (bug report from tomas@nocrew.org(Tomas Sk��e)).

652

653

1.27 by hinoue

654

Sat Oct 25 00:19:23 2003 (2 weeks, 2 days ago)

655

Changed since 1.26: +3 -3 [Select for Diff]

656

Diffs to version 1.26 (long / unified)

657

Diffs ignoring whitespace to version 1.26 (long / unified)

658

[7.03.0201]

659

1) Revise the handling of descriptors and implement SQLCopyDesc.

660

2) Handle data_at_execution columns for SQLSetPos or SQLBulkOperations.

661

662

1.26 by dpage

663

Wed Oct 22 09:07:25 2003 (2 weeks, 5 days ago)

664

CVS Tags: REL-07_03_0200

665

Changed since 1.25: +3 -3 [Select for Diff]

666

Diffs to version 1.25 (long / unified)

667

Diffs ignoring whitespace to version 1.25 (long / unified)

668

Version number bump.

669

670

1.25 by hinoue

671

Sun Oct 19 22:37:42 2003 (3 weeks ago)

672

Changed since 1.24: +3 -3 [Select for Diff]

673

Diffs to version 1.24 (long / unified)

674

Diffs ignoring whitespace to version 1.24 (long / unified)

675

[7.03.0116]

676

1. Fix a memory leak in case of updatable KEYSET_DRIVEN cursors.

677

2. Change SQLMoreResults to initialize the cursor position.

678

3. Hopefully, SQLDescribeCol() returns a more appropriate

679

error code(SQLSTATE).

680

681

1.24 by hinoue

682

Fri Sep 19 05:25:17 2003 (7 weeks, 3 days ago)

683

Changed since 1.23: +3 -3 [Select for Diff]

684

Diffs to version 1.23 (long / unified)

685

Diffs ignoring whitespace to version 1.23 (long / unified)

686

1) Correct the return info for SQLGetInfo(.., SQL_CURSOR_COMMIT

687

(ROLLBACK)_BEHAVIOR) call.

688

2) Explictly reject the SQLBrowseConnect call.

689

690

1.23 by hinoue

691

Mon Sep 15 04:25:03 2003 (8 weeks ago)

692

Changed since 1.22: +3 -3 [Select for Diff]

693

Diffs to version 1.22 (long / unified)

694

Diffs ignoring whitespace to version 1.22 (long / unified)

695

1. Serialize the connection use for communication(multi-thread).

696

2. Let escape strings case-insensitive.

697

698

1.22 by hinoue

699

Tue Sep 2 07:25:53 2003 (2 months, 1 week ago)

700

Changed since 1.21: +1 -1 [Select for Diff]

701

Diffs to version 1.21 (long / unified)

702

Diffs ignoring whitespace to version 1.21 (long / unified)

703

Fix a bug when handling data_at_execution parameter array

704

reported by Jol Valentine <jolv@genaware.com>.

705

706

1.21 by hinoue

707

Wed Aug 27 06:17:53 2003 (2 months, 2 weeks ago)

708

Changed since 1.20: +3 -3 [Select for Diff]

709

Diffs to version 1.20 (long / unified)

710

Diffs ignoring whitespace to version 1.20 (long / unified)

711

1) Fix a bug on SQLSetStmtAttr(.., SQL_CONCURRENCY) reported by Shachar Shemesh.

712

2) Apply a patch to changes the storage type of the debug "func" variables

713

to be stored in the constant area of the program(Shachar Shemesh).

714

3) Correct the column size in case of bytea as LO.

715

716

1.20 by hinoue

717

Wed Jul 30 21:57:50 2003 (3 months, 1 week ago)

718

Changed since 1.19: +3 -3 [Select for Diff]

719

Diffs to version 1.19 (long / unified)

720

Diffs ignoring whitespace to version 1.19 (long / unified)

721

1) Distinguish the rowset size for SQLFetch(Scroll) from that for

722

SQLExtendedFetch.

723

2) Implement SQLGetDiagFieldW() for the Unicode driver.

724

725

1.19 by hinoue

726

Fri Jul 11 06:47:17 2003 (4 months ago)

727

Changed since 1.18: +3 -3 [Select for Diff]

728

Diffs to version 1.18 (long / unified)

729

Diffs ignoring whitespace to version 1.18 (long / unified)

730

Improve SQLGetDiagField so that an MFC appliaction reports

731

error messages properly(bug report from Silvio Scarpati).

732

733

1.18 by hinoue

734

Wed Jul 9 04:09:11 2003 (4 months ago)

735

Changed since 1.17: +3 -3 [Select for Diff]

736

Diffs to version 1.17 (long / unified)

737

Diffs ignoring whitespace to version 1.17 (long / unified)

738

Add quotes around table names to use ::regclass in parse.c .

739

740

1.17 by hinoue

741

Sun Jun 29 23:51:24 2003 (4 months, 1 week ago)

742

Changed since 1.16: +3 -3 [Select for Diff]

743

Diffs to version 1.16 (long / unified)

744

Diffs ignoring whitespace to version 1.16 (long / unified)

745

Change SQLGetFunctions to contain ODBC3 APIs.

746

747

1.16 by hinoue

748

Thu May 29 22:30:33 2003 (5 months, 1 week ago)

749

Changed since 1.15: +3 -3 [Select for Diff]

750

Diffs to version 1.15 (long / unified)

751

Diffs ignoring whitespace to version 1.15 (long / unified)

752

1) Improve the SQL_C_VARBOOKMARK type handling.

753

2) Cleanup copy_and_convert_field() a little.

754

3) Set an error number and an error message for SQLAllocHandle(

755

SQL_HANDLE_DESC).

756

757

1.15 by hinoue

758

Tue May 27 22:26:37 2003 (5 months, 2 weeks ago)

759

Changed since 1.14: +3 -3 [Select for Diff]

760

Diffs to version 1.14 (long / unified)

761

Diffs ignoring whitespace to version 1.14 (long / unified)

762

Fix a bug about a bookmark handling in SQLBulkOperaitons(SQL_ADD,..)

763

764

1.14 by hinoue

765

Tue May 27 19:23:41 2003 (5 months, 2 weeks ago)

766

Changed since 1.13: +3 -3 [Select for Diff]

767

Diffs to version 1.13 (long / unified)

768

Diffs ignoring whitespace to version 1.13 (long / unified)

769

Remove date cast(::date) from the conversion of {d escape before

770

7.3 servers. 7.2 servers are poor in implicit cast from date ->

771

timestamp without time zone.

772

773

1.13 by hinoue

774

Tue May 27 01:20:09 2003 (5 months, 2 weeks ago)

775

Changed since 1.12: +3 -3 [Select for Diff]

776

Diffs to version 1.12 (long / unified)

777

Diffs ignoring whitespace to version 1.12 (long / unified)

778

1) Corrent the handling of bookmark in SQLBulkOperations.

779

2) Correct the calculation of a global index in SC_pos_add.

780

3) Cleanup global/rowset/resultset index handling a little.

781

782

1.12 by hinoue

783

Sun May 25 20:47:50 2003 (5 months, 2 weeks ago)

784

Changed since 1.11: +3 -3 [Select for Diff]

785

Diffs to version 1.11 (long / unified)

786

Diffs ignoring whitespace to version 1.11 (long / unified)

787

Correct a handling of offset in SQLBulkOperations.

788

789

1.11 by hinoue

790

Tue May 20 10:11:22 2003 (5 months, 3 weeks ago)

791

Changed since 1.10: +4 -4 [Select for Diff]

792

Diffs to version 1.10 (long / unified)

793

Diffs ignoring whitespace to version 1.10 (long / unified)

794

Fix a crash bug in SQLDriverConnect().

795

796

1.10 by hinoue

797

Tue May 20 06:39:28 2003 (5 months, 3 weeks ago)

798

Changed since 1.9: +3 -3 [Select for Diff]

799

Diffs to version 1.9 (long / unified)

800

Diffs ignoring whitespace to version 1.9 (long / unified)

801

The previous change wasn't in time of 7.3.0100.

802

It belongs to 7.03.0101.

803

804

1.9 by hinoue

805

Mon May 19 06:12:09 2003 (5 months, 3 weeks ago)

806

Changed since 1.8: +1 -1 [Select for Diff]

807

Diffs to version 1.8 (long / unified)

808

Diffs ignoring whitespace to version 1.8 (long / unified)

809

1) Revert a *int8 as* DSN option to *numeric* for MS Jet.

810

2) Add a SQL_CA2_SENSITIVITY_ADDTIONS mask to the reply for

811

SQLGetInfo(.., SQL_ATTR_KEYSET_DRIVEN_CURSOR_ATTRIBUTES2)

812

which would make a little OpenOffice happy.

813

3) Fix a bug in SQLGetInfo(.., SQL_ATTR_ROW_NUMBER) for keyset_driven

814

cursors.

815

816

1.8 by dpage

817

Thu May 15 04:24:40 2003 (5 months, 3 weeks ago)

818

CVS Tags: REL-07_03_0100

819

Changed since 1.7: +3 -3 [Select for Diff]

820

Diffs to version 1.7 (long / unified)

821

Diffs ignoring whitespace to version 1.7 (long / unified)

822

Updates for 07.03.0100

823

824

1.7 by dpage

825

Thu May 15 03:38:16 2003 (5 months, 3 weeks ago)

826

Changed since 1.6: +3 -3 [Select for Diff]

827

Diffs to version 1.6 (long / unified)

828

Diffs ignoring whitespace to version 1.6 (long / unified)

829

Updates for 07.03.0001

830

831

1.6 by hinoue

832

Mon May 12 11:44:08 2003 (5 months, 4 weeks ago)

833

Changed since 1.5: +3 -3 [Select for Diff]

834

Diffs to version 1.5 (long / unified)

835

Diffs ignoring whitespace to version 1.5 (long / unified)

836

1) Add a *bytea as LO* DSN option button.

837

2) Add japanese resources to psqlodbc.rc.

838

3) Add a dialog for the driver change.

839

840

1.5 by hinoue

841

Wed Apr 23 05:49:47 2003 (6 months, 2 weeks ago)

842

Changed since 1.4: +3 -3 [Select for Diff]

843

Diffs to version 1.4 (long / unified)

844

Diffs ignoring whitespace to version 1.4 (long / unified)

845

1) Avoid password leak in the log.

846

2) Reduce time() calls for the performance.

847

3) Improve the handling of per Driver resource.

848

4) #define HAVE_STRTOLL

849

etc.

850

851

1.4 by hinoue

852

Wed Nov 27 04:30:53 2002 (11 months, 1 week ago)

853

CVS Tags: REL-07_02_0005

854

Changed since 1.3: +3 -3 [Select for Diff]

855

Diffs to version 1.3 (long / unified)

856

Diffs ignoring whitespace to version 1.3 (long / unified)

857

Upgrade to 7.2.0005.

858

859

1.3 by hinoue

860

Thu Oct 10 02:37:54 2002 (13 months ago)

861

CVS Tags: REL-07_02_0004

862

Changed since 1.2: +3 -3 [Select for Diff]

863

Diffs to version 1.2 (long / unified)

864

Diffs ignoring whitespace to version 1.2 (long / unified)

865

1) Change SQLDescribeCol or SQLColAttribute to return right ResultNumCols for

866

keyset/static cursors.

867

2) Change PG_TYPE_TEXT -> PG_TYPE_VARCHAR for character columns of the

868

result of catalog functions (bug report from Mike Mascari).

869

870

1.2 by hinoue

871

Mon Sep 23 04:08:22 2002 (13 months, 2 weeks ago)

872

CVS Tags: REL-07_02_0003

873

Changed since 1.1: +3 -3 [Select for Diff]

874

Diffs to version 1.1 (long / unified)

875

Diffs ignoring whitespace to version 1.1 (long / unified)

876

1) Removed most static variables for thread safety.

877

2) Trial implementation of the thread safe driver under

878

Windows.

879

3) Fix a bug about DSN options setting.

880

4) Fix a bug about Driver options setting.

881

5) Implement SQLProcedureColumns().

882

6) Changed default numeric precision/scale.

883

7) Fix some memory leaks in Unicode driver.

884

8) datetime -> timestamp with time zone since 7.0.

885

9) Change manually started(using begin) transactions never

886

be implicitly committed.

887

888

1.1 by inoue

889

Thu May 9 00:10:22 2002 (18 months ago)

890

[Select for Diff]

891

Add a file for version control.

892

893

894

</body>

895

</html>