PgFoundry Logo
     Advanced search
Log In
New Account
  
 
Home My Page Project Tree Project Openings Npgsql .Net Data Provider for Postgresql
 
 
 
 
Summary Forums Tracker Lists Tasks Docs Surveys News SCM Files
 
 

Files | Admin

Notes:

Release Name: Npgsql2.0.8

Notes:
2009-12-28

    Npgsql 2.0.8
    
    This is a bug fix release.
    
    
    
    Highlights for this release:
        
        Work in progress for the bug reported in message 1005698. Josh is working to provide a much more solid fix for this.
        Josh started to add support for better type handling of Npgsql types and CLR types. This way, Npgsql users will be able to get values in either Npgsql specific types, like NpgsqlTimeTZ, or CLR type, like DateTime.
         
        
        
    
    New Features:
    
        Added support for Snapshot Isolation Level.
        
        Npgsql/NpgsqlDataReader.cs: Support for provider specific types (with compatibility flag on change to NpgsqlInterval). This adds initial support for better datatype handling for Npgsql specific types and CLR types.
        

    Bugs fixed:
    
        Initial support for bug fix reported in message 1005698.  The fix changes valid sql that produced	  incorrect results to sometimes valid sql that produced correct results when valid.	Also contains work in progress to resolve the invalid sql. (Josh Cooley)
        [#1010727] Entity framework exception if null inserted in XML column Changed null handling so that the value is only type cast when used in a select clause.	
        [#1010673] syntax error in queries generated by entity framework 2.0.6 ms.net sp1 Changed the filter handling to better work when subqueries in joins.
        [#1010687] Spelling error in NpgsqlCommand Object command timeout exception.
        Added method AddWithValue and made Add(String, object) obsolete and this was causing ambiguity problems with Add and NpgsqlDbType and DbType. See http://pgfoundry.org/tracker/index.php?func=detail&aid=1010714&group_id=1000140&atid=590 and http://pgfoundry.org/tracker/index.php?func=detail&aid=1010715&group_id=1000140&atid=592 for more details. Thanks Gildas (prime.gildas @nospam@ gmail.com)	  for heads up and discussion about that. Note that the issue of adding a new method which takes a DbType parameter is not finished yet. We should check if this is still needed. Updated documentation to not use DbType in the examples. 
        Bug: Money to Decimal conversion. Fixed problem where negative money values weren't being returned correctly. Thanks Denis Moinel (denis.moinel @nospam@ gmail.com) for heads up and patch. See http://pgfoundry.org/forum/message.php?msg_id=1005647 for more info.
        Fix time zone parsing bug reported in message 1005627.	Now handle negative timezones correctly.
        Fixed a bug where Npgsql wasn't honoring the connectiontimeout on Startup method. See http://pgfoundry.org/forum/message.php?msg_id=1005603 for more info. Thanks chaitra p (cpadsalgi @nospam@ peak6.com) for heads up.





Changes: 2009-12-28 00:41 jbcooley * src/: Npgsql/AssemblyInfo.cs, policy.2.0.Npgsql.config: Updated for build 2.0.8 2009-12-27 16:51 jbcooley * src/Npgsql/SqlGenerators/: SqlBaseGenerator.cs, SqlDeleteGenerator.cs, SqlInsertGenerator.cs, SqlSelectGenerator.cs, SqlUpdateGenerator.cs, VisitedExpression.cs: Initial support for bug fix reported in message 1005698. The fix changes valid sql that produced incorrect results to sometimes valid sql that produced correct results when valid. Also contains work in progress to resolve the invalid sql. 2009-12-27 16:44 jbcooley * src/Npgsql/NpgsqlProviderManifest.cs: Initial .NET code 2009-12-21 01:19 jbcooley * src/Npgsql/SqlGenerators/: SqlBaseGenerator.cs, SqlSelectGenerator.cs: Fixed two bugs with Entity Framework SQL generation: [#1010727] Entity framework exception if null inserted in XML column Changed null handling so that the value is only type cast when used in a select clause. [#1010673] syntax error in queries generated by entity framework 2.0.6 ms.net sp1 Changed the filter handling to better work when subqueries in joins. 2009-12-20 00:33 fxjr * docs/UserManual.html: Fixed manual to show examples using NpgsqlDbType instead of DbType. Using DbType is only provided for backwards compatibility. NpgsqlDbType is the prefered way to specify paramter types. 2009-12-20 00:15 fxjr * src/Npgsql/NpgsqlState.resx: [#1010687] Spelling error in NpgsqlCommand Object command timeout exception. Fixed. 2009-12-19 13:30 fxjr * src/Npgsql/NpgsqlParameterCollection.cs, testsuite/noninteractive/NUnit20/CommandTests.cs: Added method AddWithValue and made Add(String, object) obsolete and this was causing ambiguity problems with Add and NpgsqlDbType and DbType. See http://pgfoundry.org/tracker/index.php?func=detail&aid=1010714&group_id=1000140&atid=590 and http://pgfoundry.org/tracker/index.php?func=detail&aid=1010715&group_id=1000140&atid=592 for more details. Thanks Gildas (prime.gildas @nospam@ gmail.com) for heads up and discussion about that. Note that the issue of adding a new method which takes a DbType parameter is not finished yet. We should check if this is still needed. 2009-12-13 22:45 fxjr * src/NpgsqlTypes/DateDatatypes.cs: Added support to parse "-infinity" and "infinity" date values. 2009-12-13 01:27 jbcooley * src/Npgsql/AssemblyInfo.cs: No longer the 2.0.7 release build. Change version number so that compatibility flag can be used. 2009-12-13 01:26 jbcooley * src/Npgsql/NpgsqlTransaction.cs: Support Snapshot Isolation level correctly. 2009-12-13 01:25 jbcooley * src/: NpgsqlTypes/NpgsqlTypesHelper.cs, Npgsql/NpgsqlDataReader.cs: Support for provider specific types (with compatibility flag on change to NpgsqlInterval) 2009-12-13 01:23 jbcooley * src/NpgsqlTypes/DateDatatypes.cs: Support casting time values to DateTime type 2009-12-13 01:22 jbcooley * testsuite/noninteractive/NUnit20/CommandTests.cs: Tests to validate type changes for provider specific type support 2009-12-13 01:17 jbcooley * testsuite/noninteractive/NUnit20/TypesTests.cs: Validate time conversion. Noticed that NpgsqlTimeTZ.LocalTime is really local to timezone specified in value. 2009-12-13 01:16 jbcooley * testsuite/noninteractive/NUnit20/DataAdapterTests.cs: Tests from bug report 1010734 2009-12-13 01:14 jbcooley * testsuite/noninteractive/NUnit20/ConnectionTests.cs: Tests from bug report 2009-12-11 18:24 fxjr * src/NpgsqlTypes/NpgsqlTypeConverters.cs, testsuite/noninteractive/NUnit20/CommandTests.cs: Bug: Money to Decimal conversion. Fixed problem where negative money values weren't being returned correctly. Thanks Denis Moinel (denis.moinel @nospam@ gmail.com) for heads up and patch. See http://pgfoundry.org/forum/message.php?msg_id=1005647 for more info. Also added test case. 2009-12-09 02:17 jbcooley * src/NpgsqlTypes/DateDatatypes.cs: Fix time zone parsing bug reported in message 1005627. Now handle negative timezones correctly. 2009-12-09 02:11 jbcooley * testsuite/noninteractive/NUnit20/TypesTests.cs: Test time zone parsing. Exposes bug reported in message 1005627 2009-12-01 23:50 fxjr * src/Npgsql/NpgsqlConnectedState.cs: Fixed a bug where Npgsql wasn't honoring the connectiontimeout on Startup method. See http://pgfoundry.org/forum/message.php?msg_id=1005603 for more info. Thanks chaitra p (cpadsalgi @nospam@ peak6.com) for heads up.