1 2008-11-05 Francisco Figueiredo Jr. <francisco@npgsql.org>
3 Undone update as it breaks the svn tree.
5 2008-11-05 Francisco Figueiredo Jr. <francisco@npgsql.org>
7 Updated Npgsql to Npgsql2 2.0.1. Now Npgsql requires .Net 2.0 or above
9 2008-05-05 Francisco Figueiredo Jr. <francisco@npgsql.org>
11 Fixed problems when notification thread throws exception. Not is
12 correctly thrown. See http://pgfoundry.org/forum/message.php?msg_id=1003387 for discussion about that. Thanks Josh Cooley for patch.
15 2007-11-15 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
16 *Npgsql/NpgsqlCommand.cs: [#1010187] Problem with parsing parameters and "<" or ">" operator with Prepare().
17 [#1010186] Thread safety problem when Parsing command text.
18 Thanks Hubert FONGARNAND for patches!
20 2007-11-09 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
22 *NpgsqlTypes/NpgsqlTypesHelper.cs: This is a single line patch version for handling Standard conforming strings parameter in postgresql.conf. You only need this version instead of 1.0 is you are using this setting or is planning to use it. Also, starting with 8.4 postgresql version, this parameter will be default to on in postgresql.conf. Today it is off.
23 More info can be obtained on this link: http://pgfoundry.org/tracker/index.php?func=detail&aid=1009624&group_id=1000140&atid=592
24 Thanks Laurenz Albe & Erich Lerch for their patch!
27 2006-11-01 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
29 *Npgsql/NpgsqlCommand.cs: [#1000765] InvalidCastException for ByteA
30 Parameter when command.Prepare() Thanks Hubert Fongarnand for patch!
32 2006-10-20 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
34 *Npgsql/NpgsqlCommand.resx,
35 Npgsql/NpgsqlConnection.cs,
36 Npgsql/NpgsqlCommand.cs,
37 Npgsql/NpgsqlState.cs,
38 Npgsql/NpgsqlConnectorPool.cs,
39 Npgsql/NpgsqlCommandBuilder.cs,
40 Npgsql/NpgsqlDataReader.cs,
41 NpgsqlTypes/LargeObjectManager.cs,
42 NpgsqlTypes/NpgsqlDbType.cs,
43 NpgsqlTypes/LargeObject.cs,
44 NpgsqlTypes/NpgsqlTypesHelper.cs,
45 NpgsqlTypes/FastPath.cs: Updated to 1.0 final version.
49 2006-09-06 Kornél Pál <kornelpal@gmail.com>
51 * Test/TestConfiguration.cs: Moved from build/common.
52 * Npgsql/Npgsql_test.dll.sources: Added TestConfiguration.cs.
54 2006-08-16 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
57 * Npgsql/NpgsqlParameter.cs
58 Npgsql/NpgsqlConnectionString.cs
59 Npgsql/NpgsqlState.resx
60 Npgsql/NpgsqlConnection.cs
61 Npgsql/NpgsqlSchema.cs
62 Npgsql/NpgsqlClosedState.cs
63 Npgsql/NpgsqlCommand.cs
64 Npgsql/NpgsqlConnectorPool.cs
65 Npgsql/NpgsqlConnector.cs
66 Npgsql/NpgsqlTransaction.resx
67 Npgsql/NpgsqlRowDescription.cs
68 Npgsql/NpgsqlCommandBuilder.cs
69 Npgsql/NpgsqlDataReader.cs
70 Npgsql/NpgsqlException.cs
71 Npgsql/NpgsqlMediator.cs
72 Npgsql/NpgsqlReadyState.cs
73 NpgsqlTypes/NpgsqlDbType.cs
74 NpgsqlTypes/NpgsqlTypeConverters.cs
75 NpgsqlTypes/NpgsqlTypesHelper.cs: Updated to RC3 version.
80 2006-04-27 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
82 * Npgsql_test.dll.sources,
84 Npgsql/NpgsqlError.cs,
85 Npgsql/NpgsqlCommandBuilder.resx,
86 Npgsql/NpgsqlConnectedState.cs,
88 Npgsql/NpgsqlTransaction.cs,
89 Npgsql/NpgsqlConnectionString.cs,
90 Npgsql/NpgsqlConnection.cs,
91 Npgsql/NpgsqlClosedState.cs,
92 Npgsql/NpgsqlState.cs,
93 Npgsql/NpgsqlAsciiRow.cs,
94 Npgsql/NpgsqlConnector.cs,
95 Npgsql/NpgsqlParameterCollection.cs,
96 Npgsql/NpgsqlCancelRequest.cs,
97 Npgsql/NpgsqlCommandBuilder.cs,
98 Npgsql/NpgsqlException.cs,
99 Npgsql/NpgsqlMediator.cs,
100 Npgsql/NpgsqlReadyState.cs,
103 Npgsql.dll.resources,
104 NpgsqlTypes/NpgsqlDbType.cs,
105 NpgsqlTypes/NpgsqlTypeConverters.cs,
106 NpgsqlTypes/NpgsqlTypes.cs,
107 NpgsqlTypes/NpgsqlTypesHelper.cs,
108 Makefile: Updated to RC1 version.
111 Thu Feb 23 10:29:13 CET 2006 Paolo Molaro <lupus@ximian.com>
113 * Npgsql/NpgsqlCommand.cs: return count for fetch and move, too,
114 patch from Federico Di Gregorio <fog@initd.org>.
117 2006-01-05 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
119 * PGUtil.cs: [#1000517] ServerVersion operator overload. Fixed. Thanks Otto for heads up.
122 2006-01-01 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
124 * NpgsqlCommand.cs: [#1000497] Dot in parameter name causes exception. Added performance patch for GetClearCommandText() thanks Bryan Mayland.
125 * NpgsqlParameterCollection.cs: Added performance patch for GetClearCommandText() thanks Bryan Mayland.
126 * [#1000454] Getting identifier of an inserted row. Added property LastInsertedOID to NpgsqlCommand. This property only works when using a single insert command and the table was created with oids else it returns 0.
128 2005-12-29 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
130 * NpgsqlCommand.cs: [#1000500] Fixed problem when parsing parameter names with NpgsqlCommand.Prepare(), [#1000497] Fixed problem with dot in parameter names.
132 2005-12-25 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
134 * NpgsqlTransaction.cs: [#1000491] Fixed transaction isolation level setting. Thanks Ottó Havasvölgyi for heads up.
135 * NpgsqlTransaction.cs.resx: Removed unused key.
137 2005-12-14 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
145 NpgsqlTypesHelper.cs: [#1000458] Enormous memory increase (and application crash) with large BYTEA parameter. Added binary support. Thanks Hubert FONGARNAND for patch. Improved network performance by removing some Stream.Flush() calls.
148 2005-12-13 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
151 * NpgsqlClosedState.cs: Added a performance improvement fix. Npgsql now use a buffered stream for all server interactions.
153 2005-12-12 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
155 * Npgsql/NpgsqlCommand.cs: [bugzilla 76961] Fixed problem with ExecuteReader when using SchemaOnly and SingleRow behavior at same time. Thanks Kamil Skalski for feedback.
157 2005-12-09 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
159 Npgsql/NpgsqlError.cs,
160 Npgsql/NpgsqlParameter.cs,
161 Npgsql/NpgsqlConnectionString.cs,
162 Npgsql/NpgsqlConnection.cs,
163 Npgsql/NpgsqlSchema.cs,
164 Npgsql/NpgsqlClosedState.cs,
165 Npgsql/NpgsqlCommand.cs,
166 Npgsql/NpgsqlState.cs,
167 Npgsql/NpgsqlAsciiRow.cs,
168 Npgsql/NpgsqlConnectorPool.cs,
169 Npgsql/NpgsqlConnector.cs,
170 Npgsql/NpgsqlQuery.cs,
171 Npgsql/NpgsqlRowDescription.cs,
172 Npgsql/NpgsqlCommandBuilder.cs,
173 Npgsql/NpgsqlDataReader.cs,
174 Npgsql/NpgsqlException.cs,
175 Npgsql/NpgsqlMediator.cs,
176 Npgsql/NpgsqlReadyState.cs,
177 Npgsql/NpgsqlEventLog.cs,
178 Npgsql.dll.resources,
179 NpgsqlTypes/NpgsqlTypeConverters.cs,
180 NpgsqlTypes/NpgsqlTypesHelper.cs,
181 Makefile: Updated to 1.0beta1
184 2005-08-27 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
185 * NpgsqlParameter.cs: Applied patch to fix a NullReferenceException when using Design Time support. Thanks Josh Cooley ( jbnpgsql at tuxinthebox dot net ) for patch.
186 * NpgsqlDataReader.cs: Updated ProviderType metadata from NpgsqlDataReader.GetResultsetSchema to be the string for the type rather than the oid. Fixed ColumnSize, NumericPrecision, NumericScale, BaseColumnName, AllowDBNull, and IsAliased. Also integrated patch from (rlp at bamafolks dot com), gborg 751. Thanks Josh Cooley (jbnpgsql at tuxinthebox dot net) for patches!
187 * NpgsqlConnection.cs,
188 NpgsqlSchema.cs: Josh Cooley (jbnpgsql at tuxinthebox dot net) improved Metadata support in Npgsql. Added support for the following collections through NpgsqlConnection.GetSchema() methods: MetaDataCollections, Restrictions, Databases, Tables, Columns, Views and Users. Also added support for restrictions when getting info about these collections.
189 * NpgsqlCommand.cs: Fixed problem with stored procedure command texts which finished with a ";". Npgsql was adding incorrectly a trailing "()" when calling this command text.
191 NpgsqlTypesHelper.cs: Added refcursor parameter support. Now, refcursors can be passed as arguments for functions. Thanks Jon Asher for heads up and tests.
192 * Npgsql.dll.sources: Added helper metadata class. Thanks Josh Cooley (jbnpgsql at tuxinthebox dot net).
193 * NpgsqlDataAdapter: Updated constructor documentation.
194 * NpgsqlConnectorPool: Fixed concurrent problem when using MinPoolSize > 1. Thanks Josh Cooley (jbnpgsql at tuxinthebox dot net) for patch.
195 * NpgsqlParameterCollection.cs: Fixed problems with parameters with "@" prefix. They weren't correctly recognized. Thanks Pejvan Beigui ( pejvan at gmail dot com) for heads up.
196 * NpgsqlCommandBuilder.cs: Updated documentation.
198 2005-08-21 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
200 Npgsql.dll.resources: Removed references to design time support. This is not needed when compiling Npgsql with mono.
202 2005-08-06 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
204 * NpgsqlCommand.cs: Fixed problem when using commandtype.storedprocedure with command texts which have parameters with ' or any other value which needed to be escaped. Now they are properly handled. Thanks Dalibor (dalxxx at email dot com) for heads up and tests.
207 2005-08-05 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
209 * NpgsqlConnection.cs: Fixed documentation about User Id connection string key. Thanks peyn at tlen dot pl for heads up. Fixes gborg 1388
211 2005-07-29 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
213 * NpgsqlCommand.cs: Fixed problem with query strings with newlines. Regexp used to parse parameters were removing new line bytes creating query strings with errors. Thanks Jaroslaw Kowalski (jaak at jkowalski dot net) for fix.
216 2005-07-19 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
218 * NpgsqlTypes/NpgsqlTypeConverters.cs: Gborg 1370. Fixed problems with Money type when using a culture which doesn't use dot as decimal separator. Also fixed problem where only Decimal types (i.e.: 7.4M) could be used as Money type values. Now Float values can be used too.
220 2005-07-08 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
222 * Npgsql/NpgsqlCommand.cs: Npgsql now can handle functions which return refcursor and setof refcursor. Now, results are returned as NpgsqlDataReader resultsets. There is no need to explicitly call "fetch all ..."
224 2005-07-05 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
226 * NpgsqlTypes/NpgsqlDbType.cs,
227 NpgsqlTypes/NpgsqlTypesHelper.cs,
228 Npgsql/NpgsqlParameter.cs,
229 Npgsql/NpgsqlConnectionString.cs,
230 Npgsql/NpgsqlState.resx,
231 Npgsql/NpgsqlConnection.cs,
232 Npgsql/NpgsqlClosedState.cs,
233 Npgsql/NpgsqlCommand.cs,
234 Npgsql/NpgsqlConnector.cs,
235 Npgsql/NpgsqlParameterCollection.cs,
236 Npgsql/NpgsqlDataReader.cs,
237 Npgsql/NpgsqlException.cs: Updated to Npgsql 0.7beta6 gborg code.
239 2005-02-20 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
241 * Npgsql/NpgsqlCommand.cs: Fixed a problem when using prepare commands inside a transaction. Portal wasn't being released. We use the unnamed portal now. Thanks Marcin (marcin at floryan dot neostrada dot pl) for the heads up.
243 2005-02-13 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
245 * NpgsqlTypes/NpgsqlTypesHelper.cs: gborg 1121: Fixed another culture variant representation problem when handling floating numbers. Thanks Sergey (sergey dot p dot k dot no dot spam at gmail dot com) for patch.
246 gborg 1167: Added support for writing null chars in text fields. Now they are escaped with \\0.
247 Thanks Sergey (sergey dot p dot k dot no dot spam at gmail dot com) for patch.
249 2005-02-08 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
251 * NpgsqlTypes/NpgsqlTypesHelper.cs: Fixed float precision rounding. Now all float values are sent with 15 precision scale.
252 * Npgsql/NpgsqlCommand.cs: Fixed problem when setting a new connection and a running transaction existed. Now, the transaction can be removed and later the connection can be replaced. Thanks Mike Griffin (mike.griffin at mygenerationsoftware dot com) for heads up.
254 2005-02-06 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
256 * NpgsqlTypes/NpgsqlTypeConverters.cs: Fixed datetime precision when sending values to backend. It was sending just the first 3 decimal values of time. Now it sends all the 6 digits. Thanks Martin Susil (spam at susil dot net) for heads up.
258 2005-01-29 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
260 * Npgsql/NpgsqlCommand.cs: Added support for updating output parameters when calling executereader().
261 Thanks Mike Griffin (mike dot griffin at mygenerationsoftware dot com) for heads up.
262 Fixed internal constructor to initialize Parameters collection and timeout.
264 2005-01-27 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
266 * Npgsql/NpgsqlParameter.cs,
267 Npgsql/NpgsqlConnection.cs,
268 Npgsql/NpgsqlCommand.cs,
269 Npgsql/NpgsqlParameterCollection.cs,
270 Makefile: Fixed problem when compiling Npgsql with Mono on windows with cygwin. Thanks Atsushi Enomoto(atsushi at ximian dot com) for heads up and Rafael Teixeira(monoman at gmail dot com) for fix.
272 2005-01-24 Atsushi Enomoto <atsushi@ximian.com>
274 * Makefile : quick csc build fix (tested on mcs as well).
276 2005-01-23 Francisco Figueiredo Jr. <fxjrlists@yahoo.com>
277 * NpgsqlTypes/NpgsqlTypes.cs,
279 Npgsql/NpgsqlParameter.cs,
280 Npgsql/NpgsqlConnection.cs,
281 Npgsql/NpgsqlCommand.cs,
282 Npgsql/NpgsqlParameterCollection.cs,
283 Makefile: Removed System.Drawing, System.Windows.Forms and System.Design dependency.
284 * NpgsqlTypes/NpgsqlTypesHelper.cs: Added patch for gborg 1121. Thanks regmaster (regmaster at gmx dot li) and torben (torben-spam-npsql at nehmer dot net) for patch.
286 2005-01-21 Francisco Figueiredo Jr. <fxjrlists@yahoo.com>
287 * NpgsqlTypes/NpgsqlDbType.cs,
288 NpgsqlTypes/NpgsqlTypesHelper.cs: Added support for Varchar datatype. Removed Internal data type enum. It is not supported yet.
290 Npgsql/PGUtil.resx: (WriteString) Added support for logging what string is being written to database server.
291 * Npgsql/NpgsqlCommand.cs: Added SingleRow behavior support.
292 gborg 1099. Added support for record return type functions. Thanks neri and Michel for heads up and tests.
293 Fixed record function bug when function had many parameters. Thanks Neri (neri at gborg dot postgresql dot org) for heads up.
294 * Npgsql/NpgsqlCommandBuilder.cs,
295 NpgsqlDataAdapter.cs: Applied patch to fix gborg 1095. Thanks Eric van der Gutten (ericvdg at ananzi dot co dot za).
296 * Npgsql/NpgsqlDataReader.cs: Removed type conversions for GetXXX() methods.
300 2004-12-20 Francisco Figueiredo Jr. <fxjrlists@yahoo.com>
301 * Npgsql/NpgsqlCommand.cs: gborg 1099. Added support for record return type functions. Thanks neri and Michel for heads up and tests.
302 * Npgsql/NpgsqlDataReader.cs: Removed type conversions for GetXXX() methods.
303 * Npgsql/NpgsqlCommand.cs: Added IClonable implementation. Also added strong type NpgsqlTransaction property and converted previous interface implementation to implicit interface implementation. Thanks Christopher Gersbo-Møller (cgm at knowledgelab dot sdu dot dk) for heads up.
305 2004-12-19 Francisco Figueiredo Jr. <fxjrlists@yahoo.com>
306 * Npgsql/NpgsqlCommand.cs: Fixed gborg 1088 and 1080. Thanks Neri (neri at gborg dot postgresql dot org) for help. Now mapped output parameters are correctly updated regardless their position in Parameters collection.
308 2004-12-16 Francisco Figueiredo Jr. <fxjrlists@yahoo.com>
309 * Npgsql/NpgsqlConnector.cs: Changed name of portal and prepare prefixes to be all lower case in order to not have case problems when deallocating them.
310 * Npgsql/NpgsqlCommand.cs: Fixed gborg 1082. Added support to implicit parameters when calling stored procedures.
312 2004-12-05 Francisco Figueiredo Jr. <fxjrlists@yahoo.com>
313 * Npgsql/NpgsqlConnector (IsValid): Clean mediator after get a connection from pool and test it for validity. This fix a bug which some times occured which made available this test resultset to user when it shouldn't.
315 2004-12-07 Raja R Harinath <rharinath@novell.com>
317 * Makefile (CLEAN_FILES): Add $(RESX_RES).
318 ($(the_lib)): Depend on $(OTHER_RES) too.
319 ($(RESX_RES)): Pass argument of RESGEN through
320 PLATFORM_CHANGE_SEPARATOR_CMD.
322 2004-12-05 Francisco Figueiredo Jr. <fxjrlists@yahoo.com>
324 * Npgsql/NpgsqlCommand.cs: gborg 971 & 1068: Added support for ParameterDirection.Output and ParameterDirection.InputOutput parameters. Now you can use these types of parameters to get results. Thanks Ivan (ivan-sun1 at mail dot ru) and (teste at aslls dot ss) for heads up.
326 2004-11-26 Raja R Harinath <rharinath@novell.com>
328 * Makefile (OTHER_RES): New. List of .bmp files.
329 (EXTRA_DISTFILES): Distribute them.
331 2004-11-25 Francisco Figueiredo Jr. <fxjrlists@yahoo.com>
333 Updated to 0.7beta3 release.
334 * NpgsqlBind.cs: Minor code cleanup.
335 * NpgsqlClosedState.cs: Code formatting.
336 * NpgsqlCommand.cs: Code cleanup and updating for new Plan and Portal name generation code.
337 * NpgsqlConnection.cs: Fixed contructor log message.
338 * NpgsqlConnectionString.cs: Code formatting.
339 * NpgsqlConnector.cs:
340 ReleasePlansPortals: Added method to release used plans and portals.
341 NextPortalName, NextPlanName: Added methods to handle name generation.
342 * NpgsqlConnectorPool.cs:
343 UngetPooledConnector: Added call to release plans and portals in connector.
344 * NpgsqlError.cs: New constructor which takes ProtocolVersion and String parameters.
345 * NpgsqlQuery.cs: Changed constructor to take an NpgsqlCommand instead of just the command string.
346 * NpgsqlReadyState.cs: Changed code to reflect NpgsqlQuery change.
348 ProcessBackendResponses_Ver_(2,3): Fixed handling of invalid authentication methods. Thanks Magnus Hagander (mha at sollentuna dot net) for the heads up.
349 * NpgsqlState.resx: Fixed resource key typo.
350 * NpgsqlTransaction.cs: Fixed IDisposable pattern implementation of NpgsqlTransaction. Now it doesn't incorrectly raise InvalidOperation exceptions. Thanks Ivan Radovanovic ( rivan at sezampro dot yu ) for heads up.
351 * NpgsqlDbType.cs: Code cleanup.
352 * NpgsqlTypeConverters.cs : Removed method to handle string. String quoting is handled prevously as it depends in the type of query: simple or extended.
353 * NpgsqlTypes.cs: Code cleanup.
354 * NpgsqlTypesHelper.cs:
355 (CreateAndLoadInitialTypesMapping): Removed delegate handler of String types. It's not necessary anymore.
356 (ConvertToBackend): Refactorying. Fixed gborg 1035. Thanks Magnus Hagander (mha at sollentuna dot net) for the heads up.
358 2004-11-25 Raja R Harinath <rharinath@novell.com>
360 * Makefile (EXTRA_DISTFILES): Add Npgsql.dll.resources.
362 2004-11-04 Raja R Harinath <rharinath@novell.com>
364 * Makefile (EXTRA_DISTFILES): Fix for 'make dist'.
366 2004-09-30 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
367 * NpgsqlTypes/FastPath.cs,
368 NpgsqlTypes/FastPathArg.cs,
369 NpgsqlTypes/LargeObject.cs,
370 NpgsqlTypes/LargeObjectManager.cs,
371 Npgsql.dll.sources: Added large object support. Thanks Emiliano Necciari (e dot necciari at blogic dot it) for the patch.
374 2004-09-26 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
376 * Npgsql/NpgsqlDataReader.cs:
377 GetBytes: Added a little fix for proper handling of getbytes with current Npgsql semantics in mind. For while, we just support offset value of 0 as we
378 read all the bytes field value at a time. So there is no copy when offset is not 0.
380 2004-09-25 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
382 * Npgsql/NpgsqlCommand.cs:
383 GetParseCommandText: Fixed an incorrect patch. Thanks Martin ( martijn at boland dot org) for heads up.
385 2004-09-25 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
387 * Npgsql/NpgsqlCommand.cs:
388 ReplaceParameterValue: Fixed parameter replace when next byte after parameter name is '\\r'. Thanks Ivan Radovanovic rivan at sezampro dot yu for the fix.
389 GetParseCommandText: Added a workaround to have some queries which are giving parameter type problems. Thanks Martin ( martijn at boland dot org) for bug report.
391 2004-09-23 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
393 * NpgsqlTypes/NpgsqlTypesHelper.cs:
394 ConvertToBackend: Added support for System.Enum types. Now enumerated types can be used correctly as a paramater value. Thanks Martin ( martijn at boland dot org) for the heads up.
396 2004-09-18 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
398 * Npgsql/NpgsqlCommand.cs:
399 GetClearCommandText: Fixed an infinite loop when trying to use a parameter whose name is equals to same type name.
400 i.e.: parameter name :text which would conflict with :text parameter name which was being added in the replacement string.
401 * NpgsqlTypes/NpgsqlTypeConverters.cs:
402 BasicNativeToBackendTypeConverter.ToString: Fixed handling of strings with backslashes. Now they are properly escaped.
404 2004-09-18 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
407 NpgsqlConnector.cs: Improved portal and plan name creation to use an unique number from NpgsqlConnector instead of using an static field in NpgsqlCommand. Thanks Martin ( martijn at boland dot org) for the heads up.
409 2004-09-15 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
410 * Npgsql/NpgsqlRowDescription.cs:
411 FieldIndex: Really added support for case insensitive fields index lookup. Thanks Martin ( martijn at boland dot org)
413 2004-09-14 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
415 * Npgsql/NpgsqlRowDescription.cs:
416 FieldIndex: Added support for case insensitive fields index lookup. Thanks Martin ( martijn at boland dot org)
418 2004-09-12 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
420 * NpgsqlTypes/NpgsqlTypesHelper:
421 VerifyDefaultTypesMap: Added DbType.Byte support. Thanks Martin ( martijn at boland dot org)
424 2004-09-12 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
426 * NpgsqlTypes/NpgsqlTypesHelper:
427 ConvertToBackend: Fixed code to handle null values properly when using extended query mode.
428 Fix bug 955 in gborg.
430 2004-09-11 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
432 * Npgsql/NpgsqlConnection.cs:
433 Dispose: Improved implementation. Also added warning logging for
434 NpgsqlConnection leakings.
435 Close: Fixed code to allow calling many times even when being disposed.
436 * Npgsql/NpgsqlConnection.resx:
437 Added new warning logging message for NpgsqlConnection leakings.
438 * Npgsql/NpgsqlConnector.cs:
439 IsValid: new method to check if Connector is still valid.
440 * Npgsql/NpgsqlConnectorPool.cs:
441 GetPooledConnector: Improved to check validity of Connector.
442 FixPoolCountBecauseOfConnectionDisposeFalse: new method to fix the connection pool count
443 because NpgsqlConnection leaking. This way, uses doesn't run out of connections from pool.
445 2004-09-07 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
447 * NpgsqlException.cs: Added support for deserialization of NpgsqlException.
449 * NpgsqlState.cs: Added missing handling of NoData message.
452 2004-07-02 Raja R Harinath <rharinath@novell.com>
454 * Makefile (OVERRIDE_BARE_TARGETS): Remove.
455 ($(the_lib)): Make dependency explicit.
457 2004-06-28 Raja R Harinath <rharinath@novell.com>
459 * Makefile (%.resources): Use $(RESGEN).
461 2004-06-22 Raja R Harinath <rharinath@novell.com>
463 * Makefile: Use $(PLATFORM_PATH_SEPARATOR) in MONO_PATH.
465 2004-06-21 Raja R Harinath <rharinath@novell.com>
467 * Makefile (LIBRARY_SNK): Sign with Npgsql/Npgsql.snk.
469 2004-06-18 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
470 * Synchronized files with gborg cvs up to release 0.6.
472 2004-05-29 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
473 * Npgsql/NpgsqlConnection.cs: Added workaround for redhat server versions.
474 It returns 7.3.4-RH as its server version. Thanks Jaroslaw Kowalski
475 (jaak@zd.com.pl) for the patch.
477 2004-05-24 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
478 * Npgsql/NpgsqlConnection.cs: Fixed bug when handling Unicode connections.
480 Thanks stehule@kix.fsv.cvut.cz for the patch.
482 2004-05-23 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
484 * Npgsql/NpgsqlConnection.cs: Fixed bug which prevented Npgsql to
485 connect to cvs built servers which had devel in its version string.
487 2004-05-22 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
489 Npgsql/NpgsqlCommand.cs,
490 Npgsql/NpgsqlConnection.cs,
491 Npgsql/NpgsqlDataReader.cs,
492 Npgsql/NpgsqlException.cs,
493 Npgsql/NpgsqlTransaction.cs,
494 Npgsql/Design/ConnectionStringEditor.cs,
495 Npgsql/Design/ConnectionStringEditorForm.cs,
496 Npgsql/Design/NpgsqlParameterConverter.cs,
497 Npgsql/Design/NpgsqlParametersEditor.cs,
498 NpgsqlTypes/NpgsqlTypesHelper.cs: Commit log by
499 Glen Parker (glenebob@nwlink.com): Bug #772 ("Using
500 Command and Prepare adds single quotes to strings twice")
501 is fixed :-) It was broken when running on the version 3
502 protocol (extended query support) on PostgreSQL 7.4.
503 Some of the files in Design were formatted with macintosh line
504 terminators. This was screwing up the xmldoc generator in csc,
505 so I reformatted to make it work.
506 I've added some essential xmldoc comments (<summary> tags). Much work
507 remains here, but I wanted to get a few in on common functions and
510 The .build file will now generate the Npgsql.xml file, next to the .dll
511 file. I removed the existing Npgsql.xml from CVS.
513 Thanks Glen Parker for this patch.
516 2004-05-20 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
519 NpgsqlBackEndKeyData.cs,
522 NpgsqlConnectedState.cs,
524 NpgsqlConnection.resx,
526 NpgsqlConnectorPool.cs,
529 NpgsqlMessageTypes.cs,
530 NpgsqlPasswordPacket.cs,
532 NpgsqlRowDescription.cs,
533 NpgsqlStartupPacket.cs,
536 NpgsqlTypes/NpgsqlTypesHelper.cs : - store protocol version as an enum, keep numbers as protocol specific
537 - split more protocol handlers between version 2 and version 3
538 - split MessageTypes class on ver2/ver3 and add remaining types for ver3 - removed handlers for deprecated protocol message types
539 - store BackendKeyData in its own member on Mediator
540 - Store ParameterStatus objects in a key map on Mediator
541 - Get backend version now from the Mediator if possible
542 - Rewrite parsers for server version and connection string
543 - Store server version numericially (in a new class ServerVersion)
544 - As usual, lots of code cleanup/commenting/etc.
546 Thanks very much Glen Parker (glenebob@nwlink.com) for this patch.
548 2004-05-20 Raja R Harinath <rharinath@novell.com>
550 * Makefile (%.resources): Use INTERNAL_RESGEN.
552 2004-05-13 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
554 * Npgsql/NpgsqlHashAlgorithm.cs: Changed exception type from Exception t
555 o InvalidOperationException when calling the Hash property and hash value is nul
556 l. Thanks Gonzalo Paniagua Javier <gonzalo@ximian.com> for catching that.
558 2004-05-09 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
562 NpgsqlClosedState.cs,
564 NpgsqlCommandBuilder.cs,
568 NpgsqlParameterCollection.cs,
570 NpgsqlTransaction.cs: Improved exception handling. Now Npgsql throws mor
571 e meaningful exceptions instead of throw NpgsqlException which are now exclusive
572 ly to sign server errors. Thanks Glen Parker (glenebob@nwlink.com) for the patch.
576 2004-05-05 Gonzalo Paniagua Javier <gonzalo@ximian.com>
579 * Npgsql.dll.resources: all the resources command line options are now
580 in a separate response file.
582 2004-05-04 Jaroslaw Kowalski <jaak@zd.com.pl>
583 * Npgsql/NpgsqlDataReader.cs: Fixed RecordsAffected to properly return -1 after "create table" and similar commands.
585 2004-05-01 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
587 * Npgsql/NpgsqlCommand.cs,
588 Npgsql/NpgsqlConnection.cs,
589 Npgsql/NpgsqlConnector.cs,
590 Npgsql/NpgsqlConnectorPool.cs,
591 Npgsql/NpgsqlError.cs,
592 Npgsql/NpgsqlException.cs,
593 Npgsql/NpgsqlParameterCollection.cs,
594 NpgsqlTypes/NpgsqlTypesHelper.cs: Improved exception support. Now NpgsqlException as well as NpgsqlError provide much more information. Thanks Glen Parker (glenebob@nwlink.com) for the patch.
596 2004-04-30 Todd Berman <tberman@sevenl.net>
598 * Npgsql/AssemblyInfo.cs: use the proper path to the .pub file
600 2004-04-30 Duncan Mak <duncan@ximian.com>
602 * Npgsql/AssemblyInfo.cs: Enable delay signing, using Npgsql.pub.
604 * Npgsql/Npgsql.pub: Added to CVS.
606 2004-04-21 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
607 * Npgsql/NpgsqlDataAdapter.cs: Changed RowUpdated and RowUpdating prefix to Npgsql.
608 * Npgsql/NpgsqlClosedState.cs: Removed dependency in TlsException. Carlos Guzman will change this excpetion to internal.
610 * Npgsql/NpgsqlCommand.cs
611 * Npgsql/NpgsqlCommand.resx
612 * Npgsql/NpgsqlConnection.cs
613 * Npgsql/NpgsqlConnection.resx
614 * Npgsql/NpgsqlDataAdapter.cs
615 * Npgsql/NpgsqlError.cs
616 * Npgsql/NpgsqlException.cs
617 * Npgsql/NpgsqlException.resx
618 * Npgsql/NpgsqlMediator.cs
619 * Npgsql/NpgsqlState.cs
620 * Npgsql/NpgsqlState.resx
621 * Npgsql/PGUtil.cs : Added initial error handling code improvements. Thanks Glen Parker (glenebob@nwlink.com) for the patch. NpgsqlException now gives aceess to error collection through the Errors property. This property return a collection of NpgsqlErrors objects. Also it gives access to error message, hint, severity and code. This fixes the feature request 689 in gborg.
625 2004-04-09 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
626 * Npgsql/NpgsqlDataAdapter.cs: Fixed DataAdapter to raise the RowUpdating and RowUpdated events. This also fixes some issues in gborg 710 bug. This modification may have broken CommandBuilder support. Working on that.
628 2004-03-28 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
629 * Npgsql/NpgsqlTransaction.cs: Fixed a bug where rollback was being called when disposing NpgsqlTransaction objects even when transaction was sucessfully commited. Fixes bug 725 in gborg. Thanks melkor (melkor@adinet.com.uy) for spotting that.
631 2004-03-28 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
632 * Npgsql/NpgsqlConnection.cs: Implemented IClonable interface in NpgsqlConnection class. Thanks Juliano Barbosa for pointing it out.
634 2004-03-22 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
635 * Npgsql/NpgsqlAsciiRow.cs
636 * Npgsql/NpgsqlBinaryRow.cs
637 * Npgsql/NpgsqlDataReader.cs: Fixed NpgsqlDataReader.IsDBNull(). It wasn't working for postgresql 7.4+. Thanks Glen Parker (glenebob@nwlink.com) for the patch.
640 2004-03-13 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
642 * Npgsql/NpgsqlConnection.cs:
643 * Npgsql/NpgsqlClosedState.cs: Added support for SSL callbacks points. Now, client applications can provide the callbacks. Npgsql provide a default callback implementation which always assumes the certificate is ok. This allows easy use as client don't need to provide callback to use ssl connections. This also fixes bug 705 in gborg.
644 * NpgsqlTypes/NpgsqlTypesHelper: Applied patch to correctly parse datetimes values with timezone information. Thanks Glen Parker <glenebob@nwlink.com> for the patch.
647 2004-03-06 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
649 * Npgsql/NpgsqlConnectorPool.cs: Fixed bug 706 in gborg. Now Max timeout will be working correctly. Thanks Sami Kuhmonen <feenix@iqs.fi> for the patch.
651 2004-02-29 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
652 * Npgsql/NpgsqlConnection.cs: Better handling of connection encoding. Added support for encoding and connection timeout in connection string.
653 * Npgsql/NpgsqlConnectorPool.cs: Added support for timeout and max connection pool.
655 2004-02-28 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
657 * Npgsql/NpgsqlConnector.cs: Added support for connection encoding.
658 * Npgsql/NpgsqlConnection.cs: Better handling of connection encoding.
659 * Npgsql/NpgsqlCommand.cs: Fixed an Invalid Index error when executing ExecuteScalar() method with an empty resultset. Thanks Lynn A. Roth for the fix. This fixes bug 687 in gborg.
662 2004-02-25 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
664 * Npgsql/NpgsqlDataReader.cs: Fixed a OutOfBoundsException when trying to access an element after have read all elements. Now it throws an InvalidOperationException.
666 * Npgsql/NpgsqlConnection.cs: Fixed Unicode handling. This also fixes bug 695 in gborg. Thanks Sami Kuhmonen <feenix@iqs.fi> for the patch.
669 2004-02-16 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
671 * Npgsql/NpgsqlDataReader.cs: Removed a log line which reduced the conne
672 ction startup time in 300 milliseconds.
674 2004-02-16 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
676 * NpgsqlConnection.cs: Added support for Unicode encoding. Fixes feature
677 request 534 on gborg. Thanks Ivar <ivar@lumisoft.ee> for pointing it out.
679 2004-02-16 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
681 * Npgsql/NpgsqlStartupPacket.cs: Added code to set datestyle to iso when
682 connecting using protocol 3.0 version. Thanks Sami Kuhmonen <feenix@iqs.fi> for pointing it out.
684 2004-02-14 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
686 * Npgsql/NpgsqlCommand.cs: Fixed a bug when handling queries which return no data. Thanks Morten Mertner <morten@mertner.com> for the fix.
688 2004-02-10 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
690 * NpgsqlTypes/NpgsqlTypesHelper.cs: Added support for datetime and time datatypes with timezone data. Thanks Sami Kuhmonen (sami@iqs.fi).
692 2004-01-15 Jackson Harper <jackson@ximian.com>
694 * NpgslTypes/NpgsqlTypesHelper.cs: Add StringFixedLength type.
696 2003-11-23 Pedro Martínez Juliá <yoros@wanadoo.es>
698 * Npgsql/HashAlgorithm.cs:
699 * Npgsql/NpgsqlClosedState.cs:
700 * Npgsql/NpgsqlCommand.cs:
701 * Npgsql/NpgsqlConnectedState.cs:
702 * Npgsql/NpgsqlConnection.cs:
703 * Npgsql/NpgsqlReadyState.cs:
704 * Npgsql/NpgsqlStartupState.cs:
705 * Npgsql/NpgsqlState.cs: Apply Disposable pattern, when using
706 ADO.NET we need to call Dispose after using any Component like
707 NpgsqlDataAdapter, NpgsqlConnection, etc... Change a few internal
708 methods to Properties.
710 2003-11-22 Pedro Martínez Juliá <yoros@wanadoo.es>
712 * Npgsql/NpgsqlClosedState.cs:
713 * Npgsql/NpgsqlConnectedState.cs:
714 * Npgsql/NpgsqlConnection.cs:
715 * Npgsql/NpgsqlReadyState.cs:
716 * Npgsql/NpgsqlState.cs: Changes related to the last update of SSL
717 implementation. Now we're using TcpClient for the connection and
718 Stream for the abstraction layer to SslClientStream.
720 2003-11-11 Pedro Martínez Juliá <yoros@wanadoo.es>
722 * Npgsql/NpgsqlDataReader.cs: GetSchemaTable has nothing to do with
723 CanRead because the schema can be readed with or without result
726 2003-11-10 Pedro Martínez Juliá <yoros@wanadoo.es>
728 * Npgsql/NpgsqlDataAdapter.cs: Best use "if" instead of try-catch.
730 2003-11-10 Pedro Martínez Juliá <yoros@wanadoo.es>
732 * Npgsql/NpgsqlDataAdapter.cs: Catch the exception thrown by MS.NET
733 when a mapping is not in the collection.
735 2003-11-09 Pedro Martínez Juliá <yoros@wanadoo.es>
737 * Npgsql/NpgsqlDataAdapter.cs: Do not assing the result of the
738 CommandBuilder to the local data. Local data should be null if the
739 client doesn't set them.
741 * Npgsql/NpgsqlCommandBuilder.cs: Mistake in param name fixed.
743 2003-11-09 Pedro Martínez Juliá <yoros@wanadoo.es>
745 * Makefile: Little fix for build the resources.
747 * Npgsql/NpgsqlCommandBuilder.cs: Added row version in delete
750 2003-11-08 Pedro Martínez Juliá <yoros@wanadoo.es>
752 * Npgsql/NpgsqlCommand.cs: Removed try-catch for Resource Manager
753 calls, the problem is fixed.
755 * Makefile: Fix one bug in the build of resources.
757 2003-11-08 Pedro Martínez Juliá <yoros@wanadoo.es>
759 * Npgsql/NpgsqlCommandBuilder.cs: Added the command builder.
761 * Npgsql/NpgsqlDataAdapter.cs: Added the CommandBuilder stuff. When
762 OnRowUpdating is called we create the command necesary for updating,
763 inserting or deleting any row of the DataTable/DataSet.
765 * Npgsql/NpgsqlCommand.cs: Temporary try-catch. ResMan still doesn't
766 work. This must be removed when ResMan works.
768 * Npgsql/NpgsqlParameter: No more than one call to value.GetType()
769 is more efficient for the deep if structure types.
771 2003-11-07 Pedro Martínez Juliá <yoros@wanadoo.es>
773 * Npgsql/NpgsqlDataAdapter.cs: Fixed the mistake I did in the last
774 change. The Command objects must not be created in the constructor.
775 The Commands should be in the overrided method "OnRowUpdating".
777 * Npgsql/NpgsqlCommand.cs: Added two try-catch instructions to get
778 the proper exception (not MissingManifestResourceException). It is
779 thrown in MS.NET and in MONO. (Npgsql compiled with MCS).
781 2003-11-07 Pedro Martínez Juliá <yoros@wanadoo.es>
783 * Npgsql/NpgsqlDataAdapter.cs: Create new Command classes for the
784 different Insrt / Update / Delete commands.
786 2003-10-20 Pedro Martínez Juliá <yoros@wanadoo.es>
788 * Npgsql/NpgsqlClosedState.cs:
789 * Npgsql/NpgsqlConnection.cs:
790 * Npgsql/NpgsqlConnectedState.cs:
791 * Npgsql/NpgsqlReadyState.cs:
792 * Npgsql/NpgsqlState.cs: Changed the namespace for Tls, now the
793 namespace is Mono.System.Protocol.Tls, before was
796 * Npgsql/Makefile: Change reference from System.Security.Tls to
797 Mono.Security (now Tls lives there).
799 2003-10-16 Pedro Martínez Juliá <yoros@wanadoo.es>
801 * Npgsql/NpgsqlClosedState.cs:
802 * Npgsql/NpgsqlConnectedState.cs:
803 * Npgsql/NpgsqlConnection.cs: Changed TcpClient by TlsSession
804 because now it is used TlsSession and it doesn't work without
807 2003-10-16 Pedro Martínez Juliá <yoros@wanadoo.es>
809 * Makefile: changed reference from Lib/System.Security.Tls.dll to
810 System.Security.Tls because the last will be installed before and
813 * Lib: Removed Lib directory, moved System.Security.Tls.dll to
814 Mono.Security.Tls library directory.
816 2003-10-15 Pedro Martínez Juliá <yoros@wanadoo.es>
818 * Makefile: fix building and the install objectives.
820 2003-04-26 Pedro Martínez Juliá <yoros@wanadoo.es>
822 * Npgsql/NpgsqlDataReader.cs: Change GetFloat and GetDouble. Now
823 they works as direct casting from GetValue.
825 2003-07-18 Peter Williams <peter@newton.cx>
827 * Npgsql/AssemblyInfo.cs: Don't strongname the assembly, because
828 we can't unless corlib is strongnamed too. Not a wonderful solution,
829 but I don't think this ever worked anyway.
831 2003-05-25 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
832 * Npgsql/NpgsqlDataReader.cs: Fixed an invalid index exception when
833 processing 0 rows queries.
835 2003-04-26 Pedro Martínez Juliá <yoros@wanadoo.es>
837 * Npgsql/NpgsqlDataReader.cs: Now GetDateTime works for "dd/MM/yyyy"
838 date formats. I think that it's needed support to auto-detect
839 DateTime format through PgSql server configuration.
841 2003-01-28 Daniel Morgan <danmorg@sc.rr.com>
843 * Npgsql.build: got it to work for Windows build
845 * Npgsql/Npgsql.build
847 * Npgsql/Npgsql.prjx: removed files not needed
849 2003-01-28 Daniel Morgan <danmorg@sc.rr.com>
851 * added the Npgsql (Npgsql is a .Net Data Provider for PostgreSQL)
852 from http://gborg.postgresql.org/project/npgsql/projdisplay.php
853 by adding the following files and directories to the mcs module
854 in mono-cvs.ximian.com at mcs/class:
867 Npgsql/Npgsql (directory)
868 Npgsql/AssemblyInfo.cs
869 Npgsql/NpgsqlAsciiRow.cs
870 Npgsql/NpgsqlBackEndKeyData.cs
871 Npgsql/NpgsqlClosedState.cs
872 Npgsql/NpgsqlCommand.cs
873 Npgsql/NpgsqlConnectedState.cs
874 Npgsql/NpgsqlConnection.cs
875 Npgsql/NpgsqlConnector.cs
876 Npgsql/NpgsqlConnectorPool.cs
877 Npgsql/NpgsqlDataAdapter.cs
878 Npgsql/NpgsqlDataReader.cs
879 Npgsql/NpgsqlEventLog.cs
880 Npgsql/NpgsqlException.cs
881 Npgsql/NpgsqlMediator.cs
882 Npgsql/NpgsqlMessageTypes.cs
883 Npgsql/NpgsqlParameter.cs
884 Npgsql/NpgsqlParameterCollection.cs
885 Npgsql/NpgsqlPasswordPacket.cs
886 Npgsql/NpgsqlQuery.cs
887 Npgsql/NpgsqlReadyState.cs
888 Npgsql/NpgsqlResultSet.cs
889 Npgsql/NpgsqlRowDescription.cs
890 Npgsql/NpgsqlStartupPacket.cs
891 Npgsql/NpgsqlStartupState.cs
892 Npgsql/NpgsqlState.cs
893 Npgsql/NpgsqlTransaction.cs