SCM

File Release Notes and Changelog

Release Name: Npgsql2.0.13.91

Release Notes

2013-06-27 

    Npgsql 2.0.13.91 (beta1)
    
    Fixed bugs:
        [#1011271] NpgsqlSchema: Use InvariantCulture on all return DataTables with schema data. Thanks Oskar Berggren for patch.
        [#1011305] Scope without prepared transactions. Thanks Shay Rojansky for the patch.
        [#1011310] Command timeouts after the first are not handled. Thanks Evan Martin for the patch.
        [#1011316] ConnectionTimeout fix, bypass the 2147 seconds limit of Socket.Poll method. Thanks Tasos Mamaloukos for patch.
        [#1011325] Escaped strings don't work with EF. Thanks  Andrey Polyakov for patch and tests.
        Implements DateTime canonical functions for EntityFramework. Thanks Andrey Polyakov for patch.
        [#1011325] Escaped strings don't work with EF. Thanks  Andrey Polyakov for patch and tests.
        [#1011321] Wrong BitString value. Thanks Jon Hanna for patch and support.
        [#1011326] Connection pooling timer (thus thread) is active even if connection pooling is disabled. Thanks Shay Rojansky for the patch.
        [#1011001] Bug in NpgsqlConnectionStringBuilder affects on cache and connection pool. Thanks Shay Rojansky for the patch.
        [#1011267] Monetary localization bug
        [#1011085] Money format is not set in accordance with the system locale format
        

    New Features:
    
        Add support for new error fields added in PostgreSQL 9.3. See here for more information about those fields: http://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=991f3e5ab3f8196d18d5b313c81a5f744f3baaea Thanks David Rowley for patch.
        
        Initial support for Entity Framework 6. See http://fxjr.blogspot.com/2013/06/initial-ef-6-support-added-to-npgsql.html for more information about it.
        

Change Log

commit 7fbbffca5cd39063739202418131352a00b3820f
Author: Francisco Figueiredo Jr <francisco@npgsql.org>
Date:   Tue Jun 25 13:43:22 2013 -0300

    Fix SimpleTransactionScope* tests when running on Mono version below 3.0
    
    Mono below 3.0 doesn't implement the transaction methods and so the code which checks for the added row was incorrectly being run.

commit ff0a4b905e5b0f7a9c505b1ca7c7a366673d358b
Author: Kevin Pullin <kevin.pullin@gmail.com>
Date:   Mon Jun 24 20:43:27 2013 -0700

    Reapplied ConnectionStringBuilder caching update

commit c8fe8e544801fad4e8d01d80d8dddaf82a2d8708
Author: Francisco Figueiredo Jr <francisco@npgsql.org>
Date:   Mon Jun 24 14:56:20 2013 -0300

    Modified last commit to not use a new connection.

commit 436d5b569050e1461d530bada3361c8b32c402eb
Author: Francisco Figueiredo Jr <francisco@npgsql.org>
Date:   Mon Jun 24 14:33:42 2013 -0300

    Fixed SimpleTransactionScope* methods to clean up data left in the tests.
    
    The data left in the tests were giving problems when the tests are run again.

commit 8af98d9965761723dd079adf59e02dad8df71c11
Author: yfakariya <yfakariya@gmail.com>
Date:   Sun Jun 9 01:19:44 2013 +0900

    Fix ParameterMarkerFormat value of the schema collection is not valid.
    
    Conflicts:
    	testsuite/noninteractive/NUnit20/ConnectionTests.cs

commit 30bcf4695304cc922c2939723bf1dda325fb3059
Author: Francisco Figueiredo Jr <francisco@npgsql.org>
Date:   Sat Jun 15 22:13:32 2013 -0300

    Developers should use NuGet to get EntityFramework.dll assembly for EF6
    support.

commit 63af6457c167d93163a772662f9fe8057d866b08
Author: PÄ“teris Å…ikiforovs <p@mak.id.lv>
Date:   Sat May 4 12:25:00 2013 +0300

    Created a new project for Entity Framework 6 which uses the new namespaces

commit e6f6cf78e6b5a278319586604bae191902515a77
Author: Francisco Figueiredo Jr <francisco@npgsql.org>
Date:   Mon Jun 10 22:38:08 2013 -0300

    Add connection state change events for close and open. Thanks
    https://github.com/pdonald and https://github.com/maxbundchen for the
    patch.
    
    Npgsql didn't have connection state change events. According to
    maxbundchen: "the EF6 depends on open/close events in some cases (like
    update or insert) and Npgsql don't trigger this ones."
    https://github.com/franciscojunior/Npgsql2/pull/19#issuecomment-17627188
    
    Added tests about those events.

commit 17ad6263ceae23988a345a503807eab468a5147e
Merge: e3622de 183ed02
Author: Francisco Figueiredo Jr. <francisco@npgsql.org>
Date:   Tue Jun 11 17:34:46 2013 -0700

    Merge pull request #24 from yfakariya/fix-policy-dll
    
    Policy DLL on NuGet package is not valid.

commit 183ed021bf59908238d34ef94ea597ba9a34921f
Author: yfakariya <yfakariya@gmail.com>
Date:   Tue Jun 11 23:20:54 2013 +0900

    Fix policyFileBuild.bat to be runnable in vs2010 dev env.

commit 1f4d6110fb89bb71ba057b9516f6dde1db8ecf22
Author: yfakariya <yfakariya@gmail.com>
Date:   Mon Jun 10 00:14:05 2013 +0900

    Fix policy-dll is always generated for clr4.

commit e3622de286d876a84869d7ddefdd563256f0ed0e
Author: Francisco Figueiredo Jr <francisco@npgsql.org>
Date:   Mon Jun 3 21:18:59 2013 -0300

    Fixed a little typo.

commit ed46f8d1950a5c46ad1f89f833c8c95abe7fa0cb
Author: Francisco Figueiredo Jr <francisco@npgsql.org>
Date:   Sat Jun 1 20:13:51 2013 -0300

    Added testcase based on bug report "[#1011085] Money format is not set in
    accordance with the system locale format"

commit f51b38cf51472d19a8873d986531359a7de3827c
Author: Francisco Figueiredo Jr <francisco@npgsql.org>
Date:   Sat Jun 1 15:00:40 2013 -0300

    Fixes [#1011267] and [#1011085]. Fixes problems with money support.
    
    Negative money support and other bugs were caused by representation format
    differences caused by the culture configured for the server. By forcing a
    culture agnostic format, we get a consistent behavior. From now on,
    Npgsql uses the 'C' locale for monetary.

commit 65fd96a72a63343bc5aae82eb58227f28dc7d032
Author: davidrowley <dgrowley@gmail.com>
Date:   Fri May 31 08:45:52 2013 +1200

    Tidy up of new test functions
    
    Renamed the 3 new test functions to give them more suitable names. Also
    added comment to explain why a domain is created to test the
    DataTypeName field. I would have guessed that we could see this
    populated by violating a NOT NULL constraint on a table's column, but
    this does not seem to be the case.

commit b26a430fba2a52fb460879ee882bce96ae666e3b
Author: davidrowley <dgrowley@gmail.com>
Date:   Fri May 31 08:35:21 2013 +1200

    Fix missing [Test] clauses from newly added test
    
    Also for the unique violation test I've added some asserts to ensure
    that the data type and column name are empty. These are not populated
    for unique violations, originally I removed the tests but on after
    thought it's probably better to ensure that they're empty strings.

commit ad4a59886d721001e5b5487df627e9652ec1947f
Author: davidrowley <dgrowley@gmail.com>
Date:   Thu May 30 13:40:22 2013 +1200

    Renamed newly added file and added copyright
    
    Renamed Exception.cs to ExceptionTests.cs and added copyright notice to
    the top of the file

commit 0a75dce32d26788a403844b9af221f3100d7dd0d
Author: davidrowley <dgrowley@gmail.com>
Date:   Thu May 30 06:47:00 2013 +1200

    Fixed wrong assumptions about new Exception Tests
    
    After reading the source code of PostgreSQL9.3, it seem that only
    certain errors relating to domain types will populate the DataTypeName
    field. This commit adds 2 new tests. 1 to test for the column name, as
    the previous uniqueviolation did not show the column name which unique
    constraint was violated. Perhaps this has to do with the fact that
    unique constraints can exist for >1 column. Test 2 checks the
    datatypename after a domain's NOT NULL constraint is violated.
    
    I've not yet run the tests. Though I did compare after setting psql \set
    VERBOSITY verbose

commit 99c48ead03fa976720d38722479283e82e6a6389
Author: davidrowley <dgrowley@gmail.com>
Date:   Wed May 29 14:57:59 2013 +1200

    Adds new test for newly added exception fields
    
    This code is untested as I've not yet worked out how to run the test
    suit.
    The constant values in the Assert.AreEqual() calls may need tweaked.
    The prime purpose of the patch is to test that the fields are properly
    being populated. There is no need to also test things like foreign key
    violation as its testing the same code in Npgsql.

commit d411ab516516fcefe63fb2d4f8f5827deca35eb3
Author: davidrowley <dgrowley@gmail.com>
Date:   Wed May 29 13:25:56 2013 +1200

    Add support for new error fields added in PostgreSQL 9.3
    
    This makes the new error information available in the Exception class
    which allows the calling code to, for example see which constraint would
    be violated by the request.
    See PostgreSQL commit message for more details on what extra information
    is available and when. This commit only captures the extra information
    when it's there.
    
    http://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=991f3e5ab3f8196d18d5b313c81a5f744f3baaea

commit 8780b65d9a20d47078e4a1605f34e9db98c2ac8a
Author: Francisco Figueiredo Jr <francisco@npgsql.org>
Date:   Thu May 30 12:00:27 2013 -0300

    Added [Ignore] to some tests which weren't working. Thanks Shay for
    feedback. See Pull Request 18.
    
    A lot of tests were not working and based on Shay's feedback
    https://github.com/franciscojunior/Npgsql2/pull/18 those [Ignore] flags
    were added in order to get all tests green. Those failing tests were
    giving us trouble to identify regressions.

commit 2991fc6dcd284c8ba2aee21dd7766c1fd329c26d
Author: Francisco Figueiredo Jr <francisco@npgsql.org>
Date:   Fri May 24 23:01:49 2013 -0300

    Changed NAnt build file to use App.config when running nunit tests. Also
    removed a trailing semicolon from the tests settings which was causing
    problems.
    
    By making NAnt use App.config file, Npgsql tests run either by NAnt
    console project file or by running nunit inside IDE (like Xaramrin
    Studio) will use the same file and changes will be reflected in both.
    Before that NAnt was using different files.
    
    A trailing semicolon in the app settings config for connection string
    was making Npgsql throw exceptions about bad formatting.

commit 3b921ae5671612ec27e0a442c45f43195a169f43
Author: Francisco Figueiredo Jr <francisco@npgsql.org>
Date:   Thu May 23 10:26:38 2013 -0300

    Fixed tests when running under mono.
    
    All transaction related tests were failing under Mono. A
    NotImplementedException was being raised. Now, those exceptions are
    catch and ignored so tests don't return errors.

commit 52952e1dc47b215fb24b0e04c25824c9fce69702
Author: Francisco Figueiredo Jr <francisco@npgsql.org>
Date:   Thu May 23 00:13:02 2013 -0300

    Fixed connection tests so they don't start to raise errors about
    too many used connections.
    
    Postgresql has a limit of max connections allowed. This fix keeps the
    connection usage inside the max value of connections in the pool which
    is 20. This way tests won't start raising errors about too many used
    connections

commit 1c561096d884047e07febe0d9d5ae3887deeed03
Author: Francisco Figueiredo Jr <francisco@npgsql.org>
Date:   Mon May 20 11:11:20 2013 -0300

    Fixed nunit assembly paths of NunitTests2010 project.

commit 52a6e1978d394fcc4b3302141dcc6e22ba47c122
Author: Francisco Figueiredo Jr <francisco@npgsql.org>
Date:   Mon May 13 20:56:49 2013 -0300

    Added conditional #ifdef ENTITIES to nunit tests related to EF. See
    https://github.com/franciscojunior/Npgsql2/pull/6 for more information.

commit c94a45b19de14e7fe0aa5afbf234e2c4ebcf54a4
Author: Francisco Figueiredo Jr <francisco@npgsql.org>
Date:   Mon May 13 20:49:53 2013 -0300

    Fixed more Monodevelop configurations mismatch. Mono-Debug, Release and
    Mono-Release. Last fix was only for Debug

commit 488d387c2b523f7cca331851b7a89a646870c3ce
Author: Francisco Figueiredo Jr <francisco@npgsql.org>
Date:   Mon May 13 14:59:35 2013 -0300

    Added some paths created by VS.Net to be ignored

commit 6eb3dc29d0cd706c04fc6b8ef42942aede622fc4
Author: Francisco Figueiredo Jr <francisco@npgsql.org>
Date:   Mon May 13 14:48:54 2013 -0300

    Fixed configuration mapping between solution file and project files on Monodevelop.
    
    Monodevelop was complaining about configurations mismatch. I redid the configuration matching and everything was ok again.

commit 3c415a7ab32dc4021e8397d156ec881e79e09925
Author: Francisco Figueiredo Jr <francisco@npgsql.org>
Date:   Mon May 13 14:42:15 2013 -0300

    Changed project settings to compile a library instead of executable.

commit 20fd444bc9df6f0f91aefa07802d1ec56a6d93ec
Author: Francisco Figueiredo Jr <francisco@npgsql.org>
Date:   Mon May 13 14:38:49 2013 -0300

    Merged https://github.com/franciscojunior/Npgsql2/pull/6 from roji.
    
    Pull origin: https://github.com/roji/Npgsql2.git branch xbuild
    
    Original commit message:
    
    Added Mono-Debug and Mono-Release msbuild configuration for use with xbuild
    
    Appears to build just fine! I also tried to muck around with MonoDevelop but it has some trouble with the EmbeddedResources, will try to take a look (less important). This could be a first step for getting rid of both the NAnt and the mdp/mds...
    
    Note that the unit test project doesn't build on Windows, seems like these need to be cleaned up
    : error CS2001: Source file xmlModel/XmlTest.ObjectLayer.cs' could not be found
    : error CS2001: Source filexmlModel/XmlTest.Views.cs' could not be found

commit 06c3aca239ce16388c6b78b3380832e3c733ee2c
Author: Francisco Figueiredo Jr <francisco@npgsql.org>
Date:   Mon May 13 11:29:52 2013 -0300

    Removed a line with a GUID value which was causing problems to be open by Monodevelop.
    
    More info about this problem can be found at: https://github.com/mono/monodevelop/pull/232

commit 3072ed30ec47ca56f473fce42694e5da04a769d8
Author: Francisco Figueiredo Jr <francisco@npgsql.org>
Date:   Sat May 11 14:13:23 2013 -0300

    Added Monodevelop per user  settings file to list of ignored files.

commit 62afedfd2fe4e5986493270ae817601735243409
Author: Francisco Figueiredo Jr <francisco@npgsql.org>
Date:   Thu May 9 10:53:25 2013 -0300

    Added ignored files.

commit 689e9ceeb10bd08b89acc2f32873daf3d7f21a9d
Merge: 3eb3685 59c4735
Author: Francisco Figueiredo Jr. <francisco@npgsql.org>
Date:   Wed May 8 08:19:12 2013 -0700

    Merge pull request #17 from roji/bug1011001
    
    [#1011001] More consistent key/value parsing in NpgsqlConnectionStringBuilder.

commit 3eb36852c7091b610e5b2dfc3b82d73a0db2c668
Merge: f3eb384 bc6c3cf
Author: Francisco Figueiredo Jr. <francisco@npgsql.org>
Date:   Wed May 8 07:21:37 2013 -0700

    Merge pull request #16 from roji/decouple_pool
    
    Refactored pool/connection + pool timer on demand

commit 59c4735879702cb3f52f0e81ad906bc917fcccc0
Author: Shay Rojansky <roji@roji.org>
Date:   Sat Apr 13 17:47:28 2013 +0300

    More consistent key/value parsing in NpgsqlConnectionStringBuilder
    
    .NET's DbConnectionStringBuilder, which NpgsqlConnectionStringBuilder extends,
    trims strings values and discards pairs with empty ones. However, NCSB's setter
    behaved differently, adding empty strings, leading to inconsistent behavior
    (bug #1011001).
    
    Modified NCSB's behavior to be consistent with DCSB - trim and discard empty.

commit 2d130517a32288e9979ec0394a72da12a7ad3dd5
Author: Shay Rojansky <roji@roji.org>
Date:   Sat Apr 13 17:11:21 2013 +0300

    Indentation and empty newlines in StringBuilder

commit bc6c3cf2646838bd2c0dfb22bb4d8c77689d427d
Author: Shay Rojansky <roji@roji.org>
Date:   Fri Apr 12 17:30:32 2013 +0300

    Refactored pool/connection + pool timer on demand
    
    - Allocating of non-pooling connections was being done
      in NpgsqlConnection, moved that code to NpsqlConnection.
    - Since the pool's timer was being started statically,
      opening a non-pooling connection would start the pool's timer
      (bug #1011326).
    - The pool's timer is now started on the demand, when a pooled
      connection is first requested. When no more connections remain,
      the timer is stopped.

commit f3eb38492b3bdcc08858e09c0968a6dccd46815e
Author: fxjr <>
Date:   Fri Apr 5 13:19:41 2013 +0000

    Added tests for BitString based on bug [#1011321] Wrong BitString value.

commit 557fccd2d94e9f2baa45dce6ea7b1f724cc10eed
Author: fxjr <>
Date:   Fri Apr 5 13:09:43 2013 +0000

    [#1011321] Wrong BitString value. Thanks Jon Hanna for patch and support.
    
    Jon Hanna also fixed another problem with the constructor of BitString which wasn't handling a case where the number of bits allocated were being rounded up to the nearest multiple of 32. So, to represent 35 bits, BitString was allocating 64. Thanks Jon for this fix.

commit ead830bd431ba5da9ecebf38f2d98c7db2c3348e
Author: fxjr <>
Date:   Sun Mar 31 16:33:08 2013 +0000

    [#1011325] Escaped strings don't work with EF. Thanks  Andrey Polyakov for patch and tests.
    
    Npgsql had a problem when hadling strings with escaped strings. This patch adds the proper syntax in order for this to work correctly. Check https://github.com/franciscojunior/Npgsql2/pull/10 for more info about this fix.

commit fae7f2ca4532ca68f4ed1336d25880798e48c0fd
Author: fxjr <>
Date:   Sat Mar 23 16:08:03 2013 +0000

    Implements DateTime canonical functions for EntityFramework. Thanks Andrey Polyakov for patch.
    
    See https://github.com/franciscojunior/Npgsql2/pull/10 and https://github.com/magnitudo/Npgsql2/commit/b922eee2839e9cf2ae33f5241e0d8721bb4a9113 for more information.

commit 4dd1a9b7397ef47c96c4b790aa0a9f663a5ff9e8
Author: fxjr <>
Date:   Sun Mar 10 17:34:46 2013 +0000

    Changed variable name as per patch request.

commit d999e45e4376877494f9c7687430924195280f04
Author: fxjr <>
Date:   Sun Mar 10 17:31:05 2013 +0000

    [#1011136]
    [#1011302]
    Applied patch [#1011316] ConnectionTimeout fix, bypass the 2147 seconds limit of Socket.Poll method. Thanks Tasos Mamaloukos for patch.
    
    Npgsql wouldn't allow a timeout higher than 2147 seconds. This patch fixes this limitation.

commit 5d5e42bb1a68ab993ca0a43c81e5fcd79f82ab64
Author: fxjr <>
Date:   Wed Feb 27 13:06:29 2013 +0000

    [#1011310] Command timeouts after the first are not handled. Applied patch [#1011311]. Thank you, Evan Martin, for bug report and patch!
    
    When a command inside a transaction times out the caller may roll back to a savepoint and try again. This works OK the first time. The second time it appears to work, but the rollback takes a long time. On the third attempt the command returns an empty result set. The attached console app reproduces the problem. On investigation, it appears that Npgsql is not cancelling any command after the first, once NpgsqlConnector.CancelRequestCalled is true.

commit ade62ad43e846fc15d1b5eda51460d496fd9e9b9
Author: fxjr <>
Date:   Sat Feb 16 21:40:15 2013 +0000

    Applied Shay Rojansky patch. [#1011305] Scope without prepared transactions. Check https://github.com/franciscojunior/Npgsql2/pull/8 for more info.

commit 78ec5ebcf03c7d5572ad2a411eaa594152f2ffc9
Author: fxjr <>
Date:   Sun Nov 18 14:23:45 2012 +0000

    Fixed possible datareader leak if the test fail. The datareader wouldn't be closed until it was collected.

commit c99438a7e6434cce191c7475057a7b615a1a8b2c
Author: fxjr <>
Date:   Sat Nov 10 00:17:28 2012 +0000

    [#1011271] NpgsqlSchema: Use InvariantCulture on all return DataTables with schema data.
    Thanks Oskar Berggren for patch. Also check https://github.com/franciscojunior/Npgsql2/pull/1 for the patch.

commit 94e64258f882173351975ae92eb068dca5c92582
Author: fxjr <>
Date:   Sun Nov 4 23:09:33 2012 +0000

    Fixed test data insertion and function creation script. Thanks Shay Rojansky for patches. See https://github.com/franciscojunior/Npgsql2/pull/7 for more information.

commit 142afd74f41f719b54d7e4e54a775e3b2ef17a92
Author: fxjr <>
Date:   Fri Sep 14 03:20:59 2012 +0000

    Fixed connection leaks.

commit bb771a0c6ba86598c13e3973c4507474030a40af
Author: fxjr <>
Date:   Fri Sep 14 03:18:46 2012 +0000

    Fixed more connection leaks in the tests.

commit 1f672d3c87eef117acbab3aec589ffba605d478b
Author: fxjr <>
Date:   Fri Sep 14 02:36:16 2012 +0000

    Fixed more connection leaks in the tests.
    
    Added some more tests.

commit 1a6bd466a47fb179e548181621f54aff4471c572
Author: fxjr <>
Date:   Fri Sep 14 02:07:30 2012 +0000

    Fixed some connection leaking tests.
    
    Added more datatype tests.
Powered By FusionForge