1 2008-11-05 Francisco Figueiredo Jr. <francisco@npgsql.org>
3 Updated Npgsql to Npgsql2 2.0.1. Now Npgsql requires .Net 2.0 or above
5 2008-05-05 Francisco Figueiredo Jr. <francisco@npgsql.org>
7 Fixed problems when notification thread throws exception. Not is
8 correctly thrown. See http://pgfoundry.org/forum/message.php?msg_id=1003387 for discussion about that. Thanks Josh Cooley for patch.
11 2007-11-15 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
12 *Npgsql/NpgsqlCommand.cs: [#1010187] Problem with parsing parameters and "<" or ">" operator with Prepare().
13 [#1010186] Thread safety problem when Parsing command text.
14 Thanks Hubert FONGARNAND for patches!
16 2007-11-09 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
18 *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.
19 More info can be obtained on this link: http://pgfoundry.org/tracker/index.php?func=detail&aid=1009624&group_id=1000140&atid=592
20 Thanks Laurenz Albe & Erich Lerch for their patch!
23 2006-11-01 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
25 *Npgsql/NpgsqlCommand.cs: [#1000765] InvalidCastException for ByteA
26 Parameter when command.Prepare() Thanks Hubert Fongarnand for patch!
28 2006-10-20 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
30 *Npgsql/NpgsqlCommand.resx,
31 Npgsql/NpgsqlConnection.cs,
32 Npgsql/NpgsqlCommand.cs,
33 Npgsql/NpgsqlState.cs,
34 Npgsql/NpgsqlConnectorPool.cs,
35 Npgsql/NpgsqlCommandBuilder.cs,
36 Npgsql/NpgsqlDataReader.cs,
37 NpgsqlTypes/LargeObjectManager.cs,
38 NpgsqlTypes/NpgsqlDbType.cs,
39 NpgsqlTypes/LargeObject.cs,
40 NpgsqlTypes/NpgsqlTypesHelper.cs,
41 NpgsqlTypes/FastPath.cs: Updated to 1.0 final version.
45 2006-09-06 Kornél Pál <kornelpal@gmail.com>
47 * Test/TestConfiguration.cs: Moved from build/common.
48 * Npgsql/Npgsql_test.dll.sources: Added TestConfiguration.cs.
50 2006-08-16 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
53 * Npgsql/NpgsqlParameter.cs
54 Npgsql/NpgsqlConnectionString.cs
55 Npgsql/NpgsqlState.resx
56 Npgsql/NpgsqlConnection.cs
57 Npgsql/NpgsqlSchema.cs
58 Npgsql/NpgsqlClosedState.cs
59 Npgsql/NpgsqlCommand.cs
60 Npgsql/NpgsqlConnectorPool.cs
61 Npgsql/NpgsqlConnector.cs
62 Npgsql/NpgsqlTransaction.resx
63 Npgsql/NpgsqlRowDescription.cs
64 Npgsql/NpgsqlCommandBuilder.cs
65 Npgsql/NpgsqlDataReader.cs
66 Npgsql/NpgsqlException.cs
67 Npgsql/NpgsqlMediator.cs
68 Npgsql/NpgsqlReadyState.cs
69 NpgsqlTypes/NpgsqlDbType.cs
70 NpgsqlTypes/NpgsqlTypeConverters.cs
71 NpgsqlTypes/NpgsqlTypesHelper.cs: Updated to RC3 version.
76 2006-04-27 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
78 * Npgsql_test.dll.sources,
80 Npgsql/NpgsqlError.cs,
81 Npgsql/NpgsqlCommandBuilder.resx,
82 Npgsql/NpgsqlConnectedState.cs,
84 Npgsql/NpgsqlTransaction.cs,
85 Npgsql/NpgsqlConnectionString.cs,
86 Npgsql/NpgsqlConnection.cs,
87 Npgsql/NpgsqlClosedState.cs,
88 Npgsql/NpgsqlState.cs,
89 Npgsql/NpgsqlAsciiRow.cs,
90 Npgsql/NpgsqlConnector.cs,
91 Npgsql/NpgsqlParameterCollection.cs,
92 Npgsql/NpgsqlCancelRequest.cs,
93 Npgsql/NpgsqlCommandBuilder.cs,
94 Npgsql/NpgsqlException.cs,
95 Npgsql/NpgsqlMediator.cs,
96 Npgsql/NpgsqlReadyState.cs,
100 NpgsqlTypes/NpgsqlDbType.cs,
101 NpgsqlTypes/NpgsqlTypeConverters.cs,
102 NpgsqlTypes/NpgsqlTypes.cs,
103 NpgsqlTypes/NpgsqlTypesHelper.cs,
104 Makefile: Updated to RC1 version.
107 Thu Feb 23 10:29:13 CET 2006 Paolo Molaro <lupus@ximian.com>
109 * Npgsql/NpgsqlCommand.cs: return count for fetch and move, too,
110 patch from Federico Di Gregorio <fog@initd.org>.
113 2006-01-05 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
115 * PGUtil.cs: [#1000517] ServerVersion operator overload. Fixed. Thanks Otto for heads up.
118 2006-01-01 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
120 * NpgsqlCommand.cs: [#1000497] Dot in parameter name causes exception. Added performance patch for GetClearCommandText() thanks Bryan Mayland.
121 * NpgsqlParameterCollection.cs: Added performance patch for GetClearCommandText() thanks Bryan Mayland.
122 * [#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.
124 2005-12-29 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
126 * NpgsqlCommand.cs: [#1000500] Fixed problem when parsing parameter names with NpgsqlCommand.Prepare(), [#1000497] Fixed problem with dot in parameter names.
128 2005-12-25 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
130 * NpgsqlTransaction.cs: [#1000491] Fixed transaction isolation level setting. Thanks Ottó Havasvölgyi for heads up.
131 * NpgsqlTransaction.cs.resx: Removed unused key.
133 2005-12-14 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
141 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.
144 2005-12-13 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
147 * NpgsqlClosedState.cs: Added a performance improvement fix. Npgsql now use a buffered stream for all server interactions.
149 2005-12-12 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
151 * Npgsql/NpgsqlCommand.cs: [bugzilla 76961] Fixed problem with ExecuteReader when using SchemaOnly and SingleRow behavior at same time. Thanks Kamil Skalski for feedback.
153 2005-12-09 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
155 Npgsql/NpgsqlError.cs,
156 Npgsql/NpgsqlParameter.cs,
157 Npgsql/NpgsqlConnectionString.cs,
158 Npgsql/NpgsqlConnection.cs,
159 Npgsql/NpgsqlSchema.cs,
160 Npgsql/NpgsqlClosedState.cs,
161 Npgsql/NpgsqlCommand.cs,
162 Npgsql/NpgsqlState.cs,
163 Npgsql/NpgsqlAsciiRow.cs,
164 Npgsql/NpgsqlConnectorPool.cs,
165 Npgsql/NpgsqlConnector.cs,
166 Npgsql/NpgsqlQuery.cs,
167 Npgsql/NpgsqlRowDescription.cs,
168 Npgsql/NpgsqlCommandBuilder.cs,
169 Npgsql/NpgsqlDataReader.cs,
170 Npgsql/NpgsqlException.cs,
171 Npgsql/NpgsqlMediator.cs,
172 Npgsql/NpgsqlReadyState.cs,
173 Npgsql/NpgsqlEventLog.cs,
174 Npgsql.dll.resources,
175 NpgsqlTypes/NpgsqlTypeConverters.cs,
176 NpgsqlTypes/NpgsqlTypesHelper.cs,
177 Makefile: Updated to 1.0beta1
180 2005-08-27 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
181 * NpgsqlParameter.cs: Applied patch to fix a NullReferenceException when using Design Time support. Thanks Josh Cooley ( jbnpgsql at tuxinthebox dot net ) for patch.
182 * 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!
183 * NpgsqlConnection.cs,
184 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.
185 * NpgsqlCommand.cs: Fixed problem with stored procedure command texts which finished with a ";". Npgsql was adding incorrectly a trailing "()" when calling this command text.
187 NpgsqlTypesHelper.cs: Added refcursor parameter support. Now, refcursors can be passed as arguments for functions. Thanks Jon Asher for heads up and tests.
188 * Npgsql.dll.sources: Added helper metadata class. Thanks Josh Cooley (jbnpgsql at tuxinthebox dot net).
189 * NpgsqlDataAdapter: Updated constructor documentation.
190 * NpgsqlConnectorPool: Fixed concurrent problem when using MinPoolSize > 1. Thanks Josh Cooley (jbnpgsql at tuxinthebox dot net) for patch.
191 * NpgsqlParameterCollection.cs: Fixed problems with parameters with "@" prefix. They weren't correctly recognized. Thanks Pejvan Beigui ( pejvan at gmail dot com) for heads up.
192 * NpgsqlCommandBuilder.cs: Updated documentation.
194 2005-08-21 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
196 Npgsql.dll.resources: Removed references to design time support. This is not needed when compiling Npgsql with mono.
198 2005-08-06 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
200 * 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.
203 2005-08-05 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
205 * NpgsqlConnection.cs: Fixed documentation about User Id connection string key. Thanks peyn at tlen dot pl for heads up. Fixes gborg 1388
207 2005-07-29 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
209 * 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.
212 2005-07-19 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
214 * 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.
216 2005-07-08 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
218 * 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 ..."
220 2005-07-05 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
222 * NpgsqlTypes/NpgsqlDbType.cs,
223 NpgsqlTypes/NpgsqlTypesHelper.cs,
224 Npgsql/NpgsqlParameter.cs,
225 Npgsql/NpgsqlConnectionString.cs,
226 Npgsql/NpgsqlState.resx,
227 Npgsql/NpgsqlConnection.cs,
228 Npgsql/NpgsqlClosedState.cs,
229 Npgsql/NpgsqlCommand.cs,
230 Npgsql/NpgsqlConnector.cs,
231 Npgsql/NpgsqlParameterCollection.cs,
232 Npgsql/NpgsqlDataReader.cs,
233 Npgsql/NpgsqlException.cs: Updated to Npgsql 0.7beta6 gborg code.
235 2005-02-20 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
237 * 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.
239 2005-02-13 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
241 * 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.
242 gborg 1167: Added support for writing null chars in text fields. Now they are escaped with \\0.
243 Thanks Sergey (sergey dot p dot k dot no dot spam at gmail dot com) for patch.
245 2005-02-08 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
247 * NpgsqlTypes/NpgsqlTypesHelper.cs: Fixed float precision rounding. Now all float values are sent with 15 precision scale.
248 * 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.
250 2005-02-06 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
252 * 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.
254 2005-01-29 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
256 * Npgsql/NpgsqlCommand.cs: Added support for updating output parameters when calling executereader().
257 Thanks Mike Griffin (mike dot griffin at mygenerationsoftware dot com) for heads up.
258 Fixed internal constructor to initialize Parameters collection and timeout.
260 2005-01-27 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
262 * Npgsql/NpgsqlParameter.cs,
263 Npgsql/NpgsqlConnection.cs,
264 Npgsql/NpgsqlCommand.cs,
265 Npgsql/NpgsqlParameterCollection.cs,
266 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.
268 2005-01-24 Atsushi Enomoto <atsushi@ximian.com>
270 * Makefile : quick csc build fix (tested on mcs as well).
272 2005-01-23 Francisco Figueiredo Jr. <fxjrlists@yahoo.com>
273 * NpgsqlTypes/NpgsqlTypes.cs,
275 Npgsql/NpgsqlParameter.cs,
276 Npgsql/NpgsqlConnection.cs,
277 Npgsql/NpgsqlCommand.cs,
278 Npgsql/NpgsqlParameterCollection.cs,
279 Makefile: Removed System.Drawing, System.Windows.Forms and System.Design dependency.
280 * 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.
282 2005-01-21 Francisco Figueiredo Jr. <fxjrlists@yahoo.com>
283 * NpgsqlTypes/NpgsqlDbType.cs,
284 NpgsqlTypes/NpgsqlTypesHelper.cs: Added support for Varchar datatype. Removed Internal data type enum. It is not supported yet.
286 Npgsql/PGUtil.resx: (WriteString) Added support for logging what string is being written to database server.
287 * Npgsql/NpgsqlCommand.cs: Added SingleRow behavior support.
288 gborg 1099. Added support for record return type functions. Thanks neri and Michel for heads up and tests.
289 Fixed record function bug when function had many parameters. Thanks Neri (neri at gborg dot postgresql dot org) for heads up.
290 * Npgsql/NpgsqlCommandBuilder.cs,
291 NpgsqlDataAdapter.cs: Applied patch to fix gborg 1095. Thanks Eric van der Gutten (ericvdg at ananzi dot co dot za).
292 * Npgsql/NpgsqlDataReader.cs: Removed type conversions for GetXXX() methods.
296 2004-12-20 Francisco Figueiredo Jr. <fxjrlists@yahoo.com>
297 * Npgsql/NpgsqlCommand.cs: gborg 1099. Added support for record return type functions. Thanks neri and Michel for heads up and tests.
298 * Npgsql/NpgsqlDataReader.cs: Removed type conversions for GetXXX() methods.
299 * 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.
301 2004-12-19 Francisco Figueiredo Jr. <fxjrlists@yahoo.com>
302 * 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.
304 2004-12-16 Francisco Figueiredo Jr. <fxjrlists@yahoo.com>
305 * 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.
306 * Npgsql/NpgsqlCommand.cs: Fixed gborg 1082. Added support to implicit parameters when calling stored procedures.
308 2004-12-05 Francisco Figueiredo Jr. <fxjrlists@yahoo.com>
309 * 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.
311 2004-12-07 Raja R Harinath <rharinath@novell.com>
313 * Makefile (CLEAN_FILES): Add $(RESX_RES).
314 ($(the_lib)): Depend on $(OTHER_RES) too.
315 ($(RESX_RES)): Pass argument of RESGEN through
316 PLATFORM_CHANGE_SEPARATOR_CMD.
318 2004-12-05 Francisco Figueiredo Jr. <fxjrlists@yahoo.com>
320 * 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.
322 2004-11-26 Raja R Harinath <rharinath@novell.com>
324 * Makefile (OTHER_RES): New. List of .bmp files.
325 (EXTRA_DISTFILES): Distribute them.
327 2004-11-25 Francisco Figueiredo Jr. <fxjrlists@yahoo.com>
329 Updated to 0.7beta3 release.
330 * NpgsqlBind.cs: Minor code cleanup.
331 * NpgsqlClosedState.cs: Code formatting.
332 * NpgsqlCommand.cs: Code cleanup and updating for new Plan and Portal name generation code.
333 * NpgsqlConnection.cs: Fixed contructor log message.
334 * NpgsqlConnectionString.cs: Code formatting.
335 * NpgsqlConnector.cs:
336 ReleasePlansPortals: Added method to release used plans and portals.
337 NextPortalName, NextPlanName: Added methods to handle name generation.
338 * NpgsqlConnectorPool.cs:
339 UngetPooledConnector: Added call to release plans and portals in connector.
340 * NpgsqlError.cs: New constructor which takes ProtocolVersion and String parameters.
341 * NpgsqlQuery.cs: Changed constructor to take an NpgsqlCommand instead of just the command string.
342 * NpgsqlReadyState.cs: Changed code to reflect NpgsqlQuery change.
344 ProcessBackendResponses_Ver_(2,3): Fixed handling of invalid authentication methods. Thanks Magnus Hagander (mha at sollentuna dot net) for the heads up.
345 * NpgsqlState.resx: Fixed resource key typo.
346 * 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.
347 * NpgsqlDbType.cs: Code cleanup.
348 * NpgsqlTypeConverters.cs : Removed method to handle string. String quoting is handled prevously as it depends in the type of query: simple or extended.
349 * NpgsqlTypes.cs: Code cleanup.
350 * NpgsqlTypesHelper.cs:
351 (CreateAndLoadInitialTypesMapping): Removed delegate handler of String types. It's not necessary anymore.
352 (ConvertToBackend): Refactorying. Fixed gborg 1035. Thanks Magnus Hagander (mha at sollentuna dot net) for the heads up.
354 2004-11-25 Raja R Harinath <rharinath@novell.com>
356 * Makefile (EXTRA_DISTFILES): Add Npgsql.dll.resources.
358 2004-11-04 Raja R Harinath <rharinath@novell.com>
360 * Makefile (EXTRA_DISTFILES): Fix for 'make dist'.
362 2004-09-30 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
363 * NpgsqlTypes/FastPath.cs,
364 NpgsqlTypes/FastPathArg.cs,
365 NpgsqlTypes/LargeObject.cs,
366 NpgsqlTypes/LargeObjectManager.cs,
367 Npgsql.dll.sources: Added large object support. Thanks Emiliano Necciari (e dot necciari at blogic dot it) for the patch.
370 2004-09-26 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
372 * Npgsql/NpgsqlDataReader.cs:
373 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
374 read all the bytes field value at a time. So there is no copy when offset is not 0.
376 2004-09-25 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
378 * Npgsql/NpgsqlCommand.cs:
379 GetParseCommandText: Fixed an incorrect patch. Thanks Martin ( martijn at boland dot org) for heads up.
381 2004-09-25 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
383 * Npgsql/NpgsqlCommand.cs:
384 ReplaceParameterValue: Fixed parameter replace when next byte after parameter name is '\\r'. Thanks Ivan Radovanovic rivan at sezampro dot yu for the fix.
385 GetParseCommandText: Added a workaround to have some queries which are giving parameter type problems. Thanks Martin ( martijn at boland dot org) for bug report.
387 2004-09-23 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
389 * NpgsqlTypes/NpgsqlTypesHelper.cs:
390 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.
392 2004-09-18 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
394 * Npgsql/NpgsqlCommand.cs:
395 GetClearCommandText: Fixed an infinite loop when trying to use a parameter whose name is equals to same type name.
396 i.e.: parameter name :text which would conflict with :text parameter name which was being added in the replacement string.
397 * NpgsqlTypes/NpgsqlTypeConverters.cs:
398 BasicNativeToBackendTypeConverter.ToString: Fixed handling of strings with backslashes. Now they are properly escaped.
400 2004-09-18 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
403 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.
405 2004-09-15 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
406 * Npgsql/NpgsqlRowDescription.cs:
407 FieldIndex: Really added support for case insensitive fields index lookup. Thanks Martin ( martijn at boland dot org)
409 2004-09-14 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
411 * Npgsql/NpgsqlRowDescription.cs:
412 FieldIndex: Added support for case insensitive fields index lookup. Thanks Martin ( martijn at boland dot org)
414 2004-09-12 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
416 * NpgsqlTypes/NpgsqlTypesHelper:
417 VerifyDefaultTypesMap: Added DbType.Byte support. Thanks Martin ( martijn at boland dot org)
420 2004-09-12 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
422 * NpgsqlTypes/NpgsqlTypesHelper:
423 ConvertToBackend: Fixed code to handle null values properly when using extended query mode.
424 Fix bug 955 in gborg.
426 2004-09-11 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
428 * Npgsql/NpgsqlConnection.cs:
429 Dispose: Improved implementation. Also added warning logging for
430 NpgsqlConnection leakings.
431 Close: Fixed code to allow calling many times even when being disposed.
432 * Npgsql/NpgsqlConnection.resx:
433 Added new warning logging message for NpgsqlConnection leakings.
434 * Npgsql/NpgsqlConnector.cs:
435 IsValid: new method to check if Connector is still valid.
436 * Npgsql/NpgsqlConnectorPool.cs:
437 GetPooledConnector: Improved to check validity of Connector.
438 FixPoolCountBecauseOfConnectionDisposeFalse: new method to fix the connection pool count
439 because NpgsqlConnection leaking. This way, uses doesn't run out of connections from pool.
441 2004-09-07 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
443 * NpgsqlException.cs: Added support for deserialization of NpgsqlException.
445 * NpgsqlState.cs: Added missing handling of NoData message.
448 2004-07-02 Raja R Harinath <rharinath@novell.com>
450 * Makefile (OVERRIDE_BARE_TARGETS): Remove.
451 ($(the_lib)): Make dependency explicit.
453 2004-06-28 Raja R Harinath <rharinath@novell.com>
455 * Makefile (%.resources): Use $(RESGEN).
457 2004-06-22 Raja R Harinath <rharinath@novell.com>
459 * Makefile: Use $(PLATFORM_PATH_SEPARATOR) in MONO_PATH.
461 2004-06-21 Raja R Harinath <rharinath@novell.com>
463 * Makefile (LIBRARY_SNK): Sign with Npgsql/Npgsql.snk.
465 2004-06-18 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
466 * Synchronized files with gborg cvs up to release 0.6.
468 2004-05-29 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
469 * Npgsql/NpgsqlConnection.cs: Added workaround for redhat server versions.
470 It returns 7.3.4-RH as its server version. Thanks Jaroslaw Kowalski
471 (jaak@zd.com.pl) for the patch.
473 2004-05-24 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
474 * Npgsql/NpgsqlConnection.cs: Fixed bug when handling Unicode connections.
476 Thanks stehule@kix.fsv.cvut.cz for the patch.
478 2004-05-23 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
480 * Npgsql/NpgsqlConnection.cs: Fixed bug which prevented Npgsql to
481 connect to cvs built servers which had devel in its version string.
483 2004-05-22 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
485 Npgsql/NpgsqlCommand.cs,
486 Npgsql/NpgsqlConnection.cs,
487 Npgsql/NpgsqlDataReader.cs,
488 Npgsql/NpgsqlException.cs,
489 Npgsql/NpgsqlTransaction.cs,
490 Npgsql/Design/ConnectionStringEditor.cs,
491 Npgsql/Design/ConnectionStringEditorForm.cs,
492 Npgsql/Design/NpgsqlParameterConverter.cs,
493 Npgsql/Design/NpgsqlParametersEditor.cs,
494 NpgsqlTypes/NpgsqlTypesHelper.cs: Commit log by
495 Glen Parker (glenebob@nwlink.com): Bug #772 ("Using
496 Command and Prepare adds single quotes to strings twice")
497 is fixed :-) It was broken when running on the version 3
498 protocol (extended query support) on PostgreSQL 7.4.
499 Some of the files in Design were formatted with macintosh line
500 terminators. This was screwing up the xmldoc generator in csc,
501 so I reformatted to make it work.
502 I've added some essential xmldoc comments (<summary> tags). Much work
503 remains here, but I wanted to get a few in on common functions and
506 The .build file will now generate the Npgsql.xml file, next to the .dll
507 file. I removed the existing Npgsql.xml from CVS.
509 Thanks Glen Parker for this patch.
512 2004-05-20 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
515 NpgsqlBackEndKeyData.cs,
518 NpgsqlConnectedState.cs,
520 NpgsqlConnection.resx,
522 NpgsqlConnectorPool.cs,
525 NpgsqlMessageTypes.cs,
526 NpgsqlPasswordPacket.cs,
528 NpgsqlRowDescription.cs,
529 NpgsqlStartupPacket.cs,
532 NpgsqlTypes/NpgsqlTypesHelper.cs : - store protocol version as an enum, keep numbers as protocol specific
533 - split more protocol handlers between version 2 and version 3
534 - split MessageTypes class on ver2/ver3 and add remaining types for ver3 - removed handlers for deprecated protocol message types
535 - store BackendKeyData in its own member on Mediator
536 - Store ParameterStatus objects in a key map on Mediator
537 - Get backend version now from the Mediator if possible
538 - Rewrite parsers for server version and connection string
539 - Store server version numericially (in a new class ServerVersion)
540 - As usual, lots of code cleanup/commenting/etc.
542 Thanks very much Glen Parker (glenebob@nwlink.com) for this patch.
544 2004-05-20 Raja R Harinath <rharinath@novell.com>
546 * Makefile (%.resources): Use INTERNAL_RESGEN.
548 2004-05-13 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
550 * Npgsql/NpgsqlHashAlgorithm.cs: Changed exception type from Exception t
551 o InvalidOperationException when calling the Hash property and hash value is nul
552 l. Thanks Gonzalo Paniagua Javier <gonzalo@ximian.com> for catching that.
554 2004-05-09 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
558 NpgsqlClosedState.cs,
560 NpgsqlCommandBuilder.cs,
564 NpgsqlParameterCollection.cs,
566 NpgsqlTransaction.cs: Improved exception handling. Now Npgsql throws mor
567 e meaningful exceptions instead of throw NpgsqlException which are now exclusive
568 ly to sign server errors. Thanks Glen Parker (glenebob@nwlink.com) for the patch.
572 2004-05-05 Gonzalo Paniagua Javier <gonzalo@ximian.com>
575 * Npgsql.dll.resources: all the resources command line options are now
576 in a separate response file.
578 2004-05-04 Jaroslaw Kowalski <jaak@zd.com.pl>
579 * Npgsql/NpgsqlDataReader.cs: Fixed RecordsAffected to properly return -1 after "create table" and similar commands.
581 2004-05-01 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
583 * Npgsql/NpgsqlCommand.cs,
584 Npgsql/NpgsqlConnection.cs,
585 Npgsql/NpgsqlConnector.cs,
586 Npgsql/NpgsqlConnectorPool.cs,
587 Npgsql/NpgsqlError.cs,
588 Npgsql/NpgsqlException.cs,
589 Npgsql/NpgsqlParameterCollection.cs,
590 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.
592 2004-04-30 Todd Berman <tberman@sevenl.net>
594 * Npgsql/AssemblyInfo.cs: use the proper path to the .pub file
596 2004-04-30 Duncan Mak <duncan@ximian.com>
598 * Npgsql/AssemblyInfo.cs: Enable delay signing, using Npgsql.pub.
600 * Npgsql/Npgsql.pub: Added to CVS.
602 2004-04-21 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
603 * Npgsql/NpgsqlDataAdapter.cs: Changed RowUpdated and RowUpdating prefix to Npgsql.
604 * Npgsql/NpgsqlClosedState.cs: Removed dependency in TlsException. Carlos Guzman will change this excpetion to internal.
606 * Npgsql/NpgsqlCommand.cs
607 * Npgsql/NpgsqlCommand.resx
608 * Npgsql/NpgsqlConnection.cs
609 * Npgsql/NpgsqlConnection.resx
610 * Npgsql/NpgsqlDataAdapter.cs
611 * Npgsql/NpgsqlError.cs
612 * Npgsql/NpgsqlException.cs
613 * Npgsql/NpgsqlException.resx
614 * Npgsql/NpgsqlMediator.cs
615 * Npgsql/NpgsqlState.cs
616 * Npgsql/NpgsqlState.resx
617 * 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.
621 2004-04-09 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
622 * 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.
624 2004-03-28 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
625 * 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.
627 2004-03-28 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
628 * Npgsql/NpgsqlConnection.cs: Implemented IClonable interface in NpgsqlConnection class. Thanks Juliano Barbosa for pointing it out.
630 2004-03-22 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
631 * Npgsql/NpgsqlAsciiRow.cs
632 * Npgsql/NpgsqlBinaryRow.cs
633 * Npgsql/NpgsqlDataReader.cs: Fixed NpgsqlDataReader.IsDBNull(). It wasn't working for postgresql 7.4+. Thanks Glen Parker (glenebob@nwlink.com) for the patch.
636 2004-03-13 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
638 * Npgsql/NpgsqlConnection.cs:
639 * 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.
640 * NpgsqlTypes/NpgsqlTypesHelper: Applied patch to correctly parse datetimes values with timezone information. Thanks Glen Parker <glenebob@nwlink.com> for the patch.
643 2004-03-06 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
645 * Npgsql/NpgsqlConnectorPool.cs: Fixed bug 706 in gborg. Now Max timeout will be working correctly. Thanks Sami Kuhmonen <feenix@iqs.fi> for the patch.
647 2004-02-29 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
648 * Npgsql/NpgsqlConnection.cs: Better handling of connection encoding. Added support for encoding and connection timeout in connection string.
649 * Npgsql/NpgsqlConnectorPool.cs: Added support for timeout and max connection pool.
651 2004-02-28 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
653 * Npgsql/NpgsqlConnector.cs: Added support for connection encoding.
654 * Npgsql/NpgsqlConnection.cs: Better handling of connection encoding.
655 * 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.
658 2004-02-25 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
660 * Npgsql/NpgsqlDataReader.cs: Fixed a OutOfBoundsException when trying to access an element after have read all elements. Now it throws an InvalidOperationException.
662 * Npgsql/NpgsqlConnection.cs: Fixed Unicode handling. This also fixes bug 695 in gborg. Thanks Sami Kuhmonen <feenix@iqs.fi> for the patch.
665 2004-02-16 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
667 * Npgsql/NpgsqlDataReader.cs: Removed a log line which reduced the conne
668 ction startup time in 300 milliseconds.
670 2004-02-16 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
672 * NpgsqlConnection.cs: Added support for Unicode encoding. Fixes feature
673 request 534 on gborg. Thanks Ivar <ivar@lumisoft.ee> for pointing it out.
675 2004-02-16 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
677 * Npgsql/NpgsqlStartupPacket.cs: Added code to set datestyle to iso when
678 connecting using protocol 3.0 version. Thanks Sami Kuhmonen <feenix@iqs.fi> for pointing it out.
680 2004-02-14 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
682 * Npgsql/NpgsqlCommand.cs: Fixed a bug when handling queries which return no data. Thanks Morten Mertner <morten@mertner.com> for the fix.
684 2004-02-10 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
686 * NpgsqlTypes/NpgsqlTypesHelper.cs: Added support for datetime and time datatypes with timezone data. Thanks Sami Kuhmonen (sami@iqs.fi).
688 2004-01-15 Jackson Harper <jackson@ximian.com>
690 * NpgslTypes/NpgsqlTypesHelper.cs: Add StringFixedLength type.
692 2003-11-23 Pedro Martínez Juliá <yoros@wanadoo.es>
694 * Npgsql/HashAlgorithm.cs:
695 * Npgsql/NpgsqlClosedState.cs:
696 * Npgsql/NpgsqlCommand.cs:
697 * Npgsql/NpgsqlConnectedState.cs:
698 * Npgsql/NpgsqlConnection.cs:
699 * Npgsql/NpgsqlReadyState.cs:
700 * Npgsql/NpgsqlStartupState.cs:
701 * Npgsql/NpgsqlState.cs: Apply Disposable pattern, when using
702 ADO.NET we need to call Dispose after using any Component like
703 NpgsqlDataAdapter, NpgsqlConnection, etc... Change a few internal
704 methods to Properties.
706 2003-11-22 Pedro Martínez Juliá <yoros@wanadoo.es>
708 * Npgsql/NpgsqlClosedState.cs:
709 * Npgsql/NpgsqlConnectedState.cs:
710 * Npgsql/NpgsqlConnection.cs:
711 * Npgsql/NpgsqlReadyState.cs:
712 * Npgsql/NpgsqlState.cs: Changes related to the last update of SSL
713 implementation. Now we're using TcpClient for the connection and
714 Stream for the abstraction layer to SslClientStream.
716 2003-11-11 Pedro Martínez Juliá <yoros@wanadoo.es>
718 * Npgsql/NpgsqlDataReader.cs: GetSchemaTable has nothing to do with
719 CanRead because the schema can be readed with or without result
722 2003-11-10 Pedro Martínez Juliá <yoros@wanadoo.es>
724 * Npgsql/NpgsqlDataAdapter.cs: Best use "if" instead of try-catch.
726 2003-11-10 Pedro Martínez Juliá <yoros@wanadoo.es>
728 * Npgsql/NpgsqlDataAdapter.cs: Catch the exception thrown by MS.NET
729 when a mapping is not in the collection.
731 2003-11-09 Pedro Martínez Juliá <yoros@wanadoo.es>
733 * Npgsql/NpgsqlDataAdapter.cs: Do not assing the result of the
734 CommandBuilder to the local data. Local data should be null if the
735 client doesn't set them.
737 * Npgsql/NpgsqlCommandBuilder.cs: Mistake in param name fixed.
739 2003-11-09 Pedro Martínez Juliá <yoros@wanadoo.es>
741 * Makefile: Little fix for build the resources.
743 * Npgsql/NpgsqlCommandBuilder.cs: Added row version in delete
746 2003-11-08 Pedro Martínez Juliá <yoros@wanadoo.es>
748 * Npgsql/NpgsqlCommand.cs: Removed try-catch for Resource Manager
749 calls, the problem is fixed.
751 * Makefile: Fix one bug in the build of resources.
753 2003-11-08 Pedro Martínez Juliá <yoros@wanadoo.es>
755 * Npgsql/NpgsqlCommandBuilder.cs: Added the command builder.
757 * Npgsql/NpgsqlDataAdapter.cs: Added the CommandBuilder stuff. When
758 OnRowUpdating is called we create the command necesary for updating,
759 inserting or deleting any row of the DataTable/DataSet.
761 * Npgsql/NpgsqlCommand.cs: Temporary try-catch. ResMan still doesn't
762 work. This must be removed when ResMan works.
764 * Npgsql/NpgsqlParameter: No more than one call to value.GetType()
765 is more efficient for the deep if structure types.
767 2003-11-07 Pedro Martínez Juliá <yoros@wanadoo.es>
769 * Npgsql/NpgsqlDataAdapter.cs: Fixed the mistake I did in the last
770 change. The Command objects must not be created in the constructor.
771 The Commands should be in the overrided method "OnRowUpdating".
773 * Npgsql/NpgsqlCommand.cs: Added two try-catch instructions to get
774 the proper exception (not MissingManifestResourceException). It is
775 thrown in MS.NET and in MONO. (Npgsql compiled with MCS).
777 2003-11-07 Pedro Martínez Juliá <yoros@wanadoo.es>
779 * Npgsql/NpgsqlDataAdapter.cs: Create new Command classes for the
780 different Insrt / Update / Delete commands.
782 2003-10-20 Pedro Martínez Juliá <yoros@wanadoo.es>
784 * Npgsql/NpgsqlClosedState.cs:
785 * Npgsql/NpgsqlConnection.cs:
786 * Npgsql/NpgsqlConnectedState.cs:
787 * Npgsql/NpgsqlReadyState.cs:
788 * Npgsql/NpgsqlState.cs: Changed the namespace for Tls, now the
789 namespace is Mono.System.Protocol.Tls, before was
792 * Npgsql/Makefile: Change reference from System.Security.Tls to
793 Mono.Security (now Tls lives there).
795 2003-10-16 Pedro Martínez Juliá <yoros@wanadoo.es>
797 * Npgsql/NpgsqlClosedState.cs:
798 * Npgsql/NpgsqlConnectedState.cs:
799 * Npgsql/NpgsqlConnection.cs: Changed TcpClient by TlsSession
800 because now it is used TlsSession and it doesn't work without
803 2003-10-16 Pedro Martínez Juliá <yoros@wanadoo.es>
805 * Makefile: changed reference from Lib/System.Security.Tls.dll to
806 System.Security.Tls because the last will be installed before and
809 * Lib: Removed Lib directory, moved System.Security.Tls.dll to
810 Mono.Security.Tls library directory.
812 2003-10-15 Pedro Martínez Juliá <yoros@wanadoo.es>
814 * Makefile: fix building and the install objectives.
816 2003-04-26 Pedro Martínez Juliá <yoros@wanadoo.es>
818 * Npgsql/NpgsqlDataReader.cs: Change GetFloat and GetDouble. Now
819 they works as direct casting from GetValue.
821 2003-07-18 Peter Williams <peter@newton.cx>
823 * Npgsql/AssemblyInfo.cs: Don't strongname the assembly, because
824 we can't unless corlib is strongnamed too. Not a wonderful solution,
825 but I don't think this ever worked anyway.
827 2003-05-25 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
828 * Npgsql/NpgsqlDataReader.cs: Fixed an invalid index exception when
829 processing 0 rows queries.
831 2003-04-26 Pedro Martínez Juliá <yoros@wanadoo.es>
833 * Npgsql/NpgsqlDataReader.cs: Now GetDateTime works for "dd/MM/yyyy"
834 date formats. I think that it's needed support to auto-detect
835 DateTime format through PgSql server configuration.
837 2003-01-28 Daniel Morgan <danmorg@sc.rr.com>
839 * Npgsql.build: got it to work for Windows build
841 * Npgsql/Npgsql.build
843 * Npgsql/Npgsql.prjx: removed files not needed
845 2003-01-28 Daniel Morgan <danmorg@sc.rr.com>
847 * added the Npgsql (Npgsql is a .Net Data Provider for PostgreSQL)
848 from http://gborg.postgresql.org/project/npgsql/projdisplay.php
849 by adding the following files and directories to the mcs module
850 in mono-cvs.ximian.com at mcs/class:
863 Npgsql/Npgsql (directory)
864 Npgsql/AssemblyInfo.cs
865 Npgsql/NpgsqlAsciiRow.cs
866 Npgsql/NpgsqlBackEndKeyData.cs
867 Npgsql/NpgsqlClosedState.cs
868 Npgsql/NpgsqlCommand.cs
869 Npgsql/NpgsqlConnectedState.cs
870 Npgsql/NpgsqlConnection.cs
871 Npgsql/NpgsqlConnector.cs
872 Npgsql/NpgsqlConnectorPool.cs
873 Npgsql/NpgsqlDataAdapter.cs
874 Npgsql/NpgsqlDataReader.cs
875 Npgsql/NpgsqlEventLog.cs
876 Npgsql/NpgsqlException.cs
877 Npgsql/NpgsqlMediator.cs
878 Npgsql/NpgsqlMessageTypes.cs
879 Npgsql/NpgsqlParameter.cs
880 Npgsql/NpgsqlParameterCollection.cs
881 Npgsql/NpgsqlPasswordPacket.cs
882 Npgsql/NpgsqlQuery.cs
883 Npgsql/NpgsqlReadyState.cs
884 Npgsql/NpgsqlResultSet.cs
885 Npgsql/NpgsqlRowDescription.cs
886 Npgsql/NpgsqlStartupPacket.cs
887 Npgsql/NpgsqlStartupState.cs
888 Npgsql/NpgsqlState.cs
889 Npgsql/NpgsqlTransaction.cs