[Mono-list] Use github site template in Npgsql project
Hi, all! I really liked your new documentation site on github. I'd like to use this template in Npgsql project site on github. Is this possible? Thanks in advance for any help. -- Regards, Francisco Figueiredo Jr. Npgsql Lead Developer http://www.npgsql.org http://gplus.to/franciscojunior http://fxjr.blogspot.com http://twitter.com/franciscojunior ___ Mono-list maillist - Mono-list@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-list
[Mono-list] Npgsql 2.1.0-rc1 released!
x27;t recommend using prepared statements with Npgsql, only for bytea data types. Thanks to Glen Parker, this is now a thing of the past. Huge directory and project structure. Npgsql had its project layout restructured to easy management of different platforms Npgsql targets: .net 2.0, 3.5, 4.0, 4.5, entity framework prior 6.0, entity framework after 6.0. Huge structure changes to our testsuite. Before, our tests depended on an external script to setup database tables, now everything is done inside the tests setup. Thanks Shay Rojansky. [#74] Use new "Discard all" syntax when releasing connection from pool. Thanks Chen Huajun. New connection string parameter "AlwaysPrepare" to indicate to Npgsql to always prepare statements before executing. [#110] Added support for Entity Framework before version 6.0 and after 6.0. They are totally different things regarding APIs and namespaces. Thanks Shay Rojansky and Kenji Uno. Added nuget EFProvider installation. Thanks Shay Rojansky. Added EF6 ConnectionFactory class. Thanks Shay Rojansky. [#135] Fix for operators @@, @> and <@. Thanks Glen Parker and jjchiw. [#117] Command timeout improvements. Thanks Glen Parker. Final considerations: This release wouldn't be possible without the help of two members: Glen Parker and Shay Rojansky. Glen Parker has been working in the optimizations tasks since his first git commit. From the changelog you can see his tireless work regarding each part of Npgsql which could be optimized. Thank you very much for your contributions, Glen! Shay Rojansky has been helping as the mastermind of the project restructuring support. He contributed a lot of changes which made our lives working with Npgsql much better. Thanks to him we can compile Npgsql for different .net platform versions easily. He also got TeamCity build server working as well as github integration. He helped us to get EntityFramework pre-6 and pos-6 verions easily integrated. Thank you, Shay! I also would like to thank Dave Page who helped us with the server where the TeamCity is installed. Without his help, I'm sure our TeamCity installation would be much more difficult. Thank you, Dave! -- Regards, Francisco Figueiredo Jr. Npgsql Lead Developer http://www.npgsql.org http://gplus.to/franciscojunior http://fxjr.blogspot.com http://twitter.com/franciscojunior ___ Mono-list maillist - Mono-list@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-list
[Mono-list] Npgsql 2.0.14.3 released!
Hi, all. The Npgsql Development Team is proud to announce the Npgsql 2.0.14.3 stable release. Npgsql is a .Net Data provider written 100% in C# which allows .net programs to talk to postgresql backends. More info can be found here: http://fxjr.blogspot.com/2013/12/npgsql-2014-released.html I'd like to specially thank Glen Parker and Shay Rojansky for all their help with this release. Thank you! Checkout the release notes and changelog here: http://pgfoundry.org/frs/shownotes.php?group_id=1000140&release_id=2067 Grab it from NuGet package manager for Visual Studio or Xamarin Studio. https://www.nuget.org/packages/Npgsql/ Or from pgfoundry: http://downloads.npgsql.org Or from github: https://github.com/npgsql/Npgsql/releases/tag/v2.0.14.3 Thank you to all who sent feedbacks, suggestions and patches. You helped to make this release. Please, give it a try and let us know if you find any problems. -- Regards, Francisco Figueiredo Jr. Npgsql Lead Developer http://www.npgsql.org http://gplus.to/franciscojunior http://fxjr.blogspot.com http://twitter.com/franciscojunior ___ Mono-list maillist - Mono-list@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-list
[Mono-list] Npgsql 2.0.14 released!
Hi, all. The Npgsql Development Team is proud to announce the Npgsql2 2.0.14 stable release. Npgsql is a .Net Data provider written 100% in C# which allows .net programs to talk to postgresql backends. More info can be found here: http://fxjr.blogspot.com/2013/12/npgsql-2014-released.html Grab it from NuGet package manager for Visual Studio or Xamarin Studio. https://www.nuget.org/packages/Npgsql/ Thank you to all who sent feedbacks, suggestions and patches. You helped to make this release. Please, give it a try and let us know if you find any problems. -- Regards, Francisco Figueiredo Jr. Npgsql Lead Developer http://www.npgsql.org http://gplus.to/franciscojunior http://fxjr.blogspot.com http://twitter.com/franciscojunior ___ Mono-list maillist - Mono-list@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-list
Re: [Mono-list] Choosing library to compile against
This is really weird :( What got my attention was the error message saying the Npgsql.NpgsqlCommand is defined multiple times. It seems that the references to Npgsql from TestLib and TestReference projects are not being recognized as the same source. I'm out of suggestions now. If I come up with any one, I'll let you know. On Thu, Feb 21, 2013 at 4:40 PM, Peter Hultqvist wrote: > On 2013-02-21 20:00, Francisco Figueiredo Jr. wrote: > > > The projects I worked with only had a direct dependency to Npgsql2. I > never played with a project which had an indirect dependency. > > Are you able to change the TestLib project properties when it is open > inside TestReferences? > > > Did you try add a reference to a fixed path to Npgsql2 assembly to both > TestLib and TestReferences projects instead of pointing them to the Npgsql2 > project? Or maybe just change TestLib reference to a fixed path to Npgsql2 > assembly? > > > I tried a few things without success/same result: > > - Change the project reference to a file reference. > - Changed both references in TestReferences so that they point to the > Npgsql.dll and TestLib.dll from the output directory of TestLib > - Change the version of Npgsql from 2 to 22 which I though would note be > mixed up with the gac > > I'm not sure about direct/indirect dependencies, as I'm only using the > Monodevelop GUI where I can choose package(gac?), project(loaded in > solution) or file(link to a dll on disk). The dlls have been built with > local copy checked. I tried checking the "Specific version" for both file > references with no change in outcome. > > When I changed the assembly name of the Npgsql project to NpgsqlX the > original error was replaced with a new one: > Program.cs(13,37): error CS0433: The imported type `Npgsql.NpgsqlCommand' > is defined multiple times > Program.cs(13,69): error CS0433: The imported type > `Npgsql.NpgsqlConnection' is defined multiple times > > This is weird since the only references are to the NpgsqlX, System(GAC) > and TestLib. > > As stated in my first post, if I remove the distribution installed version > of npgsql, all problems are gone. > rm -r /usr/lib/mono/*/Npgsql* > > -- Regards, Francisco Figueiredo Jr. Npgsql Lead Developer http://www.npgsql.org http://gplus.to/franciscojunior http://fxjr.blogspot.com http://twitter.com/franciscojunior ___ Mono-list maillist - Mono-list@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-list
Re: [Mono-list] Choosing library to compile against
On Thu, Feb 21, 2013 at 3:17 PM, Peter Hultqvist wrote: > I was using MonoDevelop to set up the project(3.1.0 from git repo) > But the result is the same if built from MonoDevelop or using xbuild. > > I made the test program that reproduce the error. > https://github.com/hultqvist/issueTestReferences > The TestReference.sln is made using monodevelop from git, for some reason > that solution file did not work with monodevelop from ubuntu 12.10 so I > made a second solution from scratch using that version of monodevelop, > TestReference2.sln. > Same result in both. > > Hm, I'll give it a try when I get at home. I don't have access to monodevelop right now. > > > The way to force the compiling is to add the reference. It should work. > I'm not following here, I must add references for the project to compile > at all its not an option not to. > > Oh, sorry for that. This was actually a response to your question: "Is there any way to force the compiling process to use the version in the solution instead of the one from the gac?" But I didn't add a proper context to it. > I see it's your project I'm using but I don't think that is where the > problem lies. > > From what I can see the TestLib is correctly compiled against the local > version of Npgsql but when TestReferences is compiled(with Npgsql and > TestLib) then the npgsql references in TestLib points to the gac while the > TestReferences point to the local version and thus the error message. > > > The projects I worked with only had a direct dependency to Npgsql2. I never played with a project which had an indirect dependency. Are you able to change the TestLib project properties when it is open inside TestReferences? Did you try add a reference to a fixed path to Npgsql2 assembly to both TestLib and TestReferences projects instead of pointing them to the Npgsql2 project? Or maybe just change TestLib reference to a fixed path to Npgsql2 assembly? I hope it helps. > On 2013-02-21 17:51, Francisco Figueiredo Jr. wrote: > > > Are you using Monodevelop? > > Did you try to compile a simple test program from command line to see if > it works ok? > > The way to force the compiling is to add the reference. It should work. > > Try to create another simpler project and test if you can compile it. > Maybe there is some problem in the project file which isn't updating your > references? > > > > On Thu, Feb 21, 2013 at 10:46 AM, Peter Hultqvist wrote: > >> How can I force a project to compile using a specific project rather >> than looking in the gac? >> >> My application is using the Npgsql but because of a bug in the >> distribution release I downloaded and compiled the source for it. It is >> included in my solution as a project along my other code. >> My projects is referencing the npgsql project in the same solution. >> >> The distribution(Ubuntu 12.10) version pulled from the >> mono-complete/mono-dev packages. >> >> The big problem is that I get compile errors such as >> >> error CS1502: The best overloaded method match for >> `Prepare(Npgsql.NpgsqlCommand)' has some invalid arguments >> error CS1503: Argument `#1' cannot convert `Npgsql.NpgsqlCommand' >> expression to type `Npgsql.NpgsqlCommand' >> >> Some details: My solution has the npgsql project and two projects of my >> own, A and B, both referencing the npgsql project. Prepare is defined in >> project A and used in project B. Project A compiles fine and project B >> is the one with the error above. >> >> Is there any way to force the compiling process to use the version in >> the solution instead of the one from the gac? >> I thought I had already done that when I reference the solution project >> rather than the package, is it perhaps a bug? >> >> Same error comes up when compiling using xbuild. >> >> The only workaround now is to remove the npgsql files from /usr/lib/mono >> but that is something I rather not have to remember for every new install. >> ___ >> Mono-list maillist - Mono-list@lists.ximian.com >> http://lists.ximian.com/mailman/listinfo/mono-list >> > > > > -- > Regards, > > Francisco Figueiredo Jr. > Npgsql Lead Developer > http://www.npgsql.org > http://gplus.to/franciscojunior > http://fxjr.blogspot.com > http://twitter.com/franciscojunior > > > -- Regards, Francisco Figueiredo Jr. Npgsql Lead Developer http://www.npgsql.org http://gplus.to/franciscojunior http://fxjr.blogspot.com http://twitter.com/franciscojunior ___ Mono-list maillist - Mono-list@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-list
Re: [Mono-list] Choosing library to compile against
Are you using Monodevelop? Did you try to compile a simple test program from command line to see if it works ok? The way to force the compiling is to add the reference. It should work. Try to create another simpler project and test if you can compile it. Maybe there is some problem in the project file which isn't updating your references? On Thu, Feb 21, 2013 at 10:46 AM, Peter Hultqvist wrote: > How can I force a project to compile using a specific project rather > than looking in the gac? > > My application is using the Npgsql but because of a bug in the > distribution release I downloaded and compiled the source for it. It is > included in my solution as a project along my other code. > My projects is referencing the npgsql project in the same solution. > > The distribution(Ubuntu 12.10) version pulled from the > mono-complete/mono-dev packages. > > The big problem is that I get compile errors such as > > error CS1502: The best overloaded method match for > `Prepare(Npgsql.NpgsqlCommand)' has some invalid arguments > error CS1503: Argument `#1' cannot convert `Npgsql.NpgsqlCommand' > expression to type `Npgsql.NpgsqlCommand' > > Some details: My solution has the npgsql project and two projects of my > own, A and B, both referencing the npgsql project. Prepare is defined in > project A and used in project B. Project A compiles fine and project B > is the one with the error above. > > Is there any way to force the compiling process to use the version in > the solution instead of the one from the gac? > I thought I had already done that when I reference the solution project > rather than the package, is it perhaps a bug? > > Same error comes up when compiling using xbuild. > > The only workaround now is to remove the npgsql files from /usr/lib/mono > but that is something I rather not have to remember for every new install. > ___ > Mono-list maillist - Mono-list@lists.ximian.com > http://lists.ximian.com/mailman/listinfo/mono-list > -- Regards, Francisco Figueiredo Jr. Npgsql Lead Developer http://www.npgsql.org http://gplus.to/franciscojunior http://fxjr.blogspot.com http://twitter.com/franciscojunior ___ Mono-list maillist - Mono-list@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-list
[Mono-list] Npgsql 2.0.12 stable released!
Hi, all. The Npgsql Development Team is proud to announce the Npgsql2 2.0.12 stable release. Npgsql is a .Net Data provider written 100% in C# which allows .net programs to talk to postgresql backends. Npgsql is licensed under BSD. More info can be obtained from http://www.npgsql.org About this release: After more than a year of development, Npgsql team is proud to announce the 2.0.12 stable release. This release contains a lot of support for Entity Framework added by our core developer Josh Cooley. A lot of bugs has been ironed on this release. Users are highly recommended to update to this version which includes a lot of performance improvements. You can download it from here: http://downloads.npgsql.org Thank you to all who sent feedbacks, suggestions and patches. You helped to make this release. Please, feel free to give it a try and let us know if you find any problems. -- Regards, Francisco Figueiredo Jr. Npgsql Lead Developer http://www.npgsql.org http://gplus.to/franciscojunior http://fxjr.blogspot.com http://twitter.com/franciscojunior ___ Mono-list maillist - Mono-list@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-list
[Mono-list] Npgsql 2.0.12 (beta4) released
Hi, all!! The Npgsql Development Team is proud to announce the Npgsql2 2.0.12 beta4 release! Npgsql is a .Net Data provider written 100% in C# which allows .net programs to talk to postgresql backends. Npgsql is licensed under BSD. More info can be obtained from http://www.npgsql.org This release is a minor bug fix for the stable 2.0 series and may be the last release towards 2.0.12 stable. Bug fixes: [#1011200] Uses API not supported in MonoTouch. [#1011161] Bug in NpgsqlCommand while getting readers from refcursors. Thanks Rabin Karki for heads up and patch. [#1011174] Requesting the REPEATABLE READ isolation level gives [#1011208] Fix Include combined with Skip and/or Take using linq to entities for bug #1011208 You can download it from here: http://downloads.npgsql.org Thank you to Josh Cooley for all his help with entity framework support and many other things! Thank you to all who sent feedbacks, suggestions and patches. You helped to make this release. Please, feel free to give it a try and let us know if you find any problems. -- Regards, Francisco Figueiredo Jr. Npgsql Lead Developer http://www.npgsql.org http://gplus.to/franciscojunior http://fxjr.blogspot.com http://twitter.com/franciscojunior ___ Mono-list maillist - Mono-list@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-list
[Mono-list] Npgsql 2.0.12 beta 3 (2.0.11.93) released!
Hi, all!! The Npgsql Development Team is proud to announce the Npgsql2 2.0.12 beta3 release! Npgsql is a .Net Data provider written 100% in C# which allows .net programs to talk to postgresql backends. Npgsql is licensed under BSD. More info can be obtained from http://www.npgsql.org This release is a minor bug fix for the stable 2.0 series. Highlights: In this beta version we can highlight two features: 1. Improved connection pooling. Thanks to Andrew heads up we improved Npgsql connection pool code to avoid locks as much as possible. This gave us 30%+ performance improvements. 2. LOG: unexpected EOF on client connection" messages are gone! After so much time causing those messages to appear on server log, Npgsql finally got rid of them. Fixed bugs: [#1010992] System.Double to DOUBLE PRECISION conversion bug. Thanks Udo Liess for excellent report, test case and fix. Fixed "LOG: unexpected EOF on client connection" messages appearing in postgresql log. See http://fxjr.blogspot.com/2011/12/fixed-log-unexpected-eof-on-client.html for more information. [#1011100] NpgsqlParameter and DBNull Value. Now NpgsqlParameter changes the dbtype accordingly to the value assigned to it unless the dbtype has been assigned explicitly. [#1011101] LINQ to entities timestamptz does not accept DateTimeOffset or DateTime. Thanks Misha Sugakov for patch and testing. [#1011138] Connection pooling performance suffers under heavy load. Rewritten connector pool logic in order to keep lock for much less time and also with a higher granularity. Thanks Andrew for heads up. [#1011102] DateTimeOffset/TimeSpan mapping problem on EF 4.1, .NET 4, using code first. Thanks Mirko Geffken for patch. You can dowload it from here: http://downloads.npgsql.org Thank you to Josh Cooley for all his help with entity framework support! Thank you to all who sent feedbacks, suggestions and patches. You helped to make this release. Please, feel free to give it a try and let us know if you find any other problems. -- Regards, Francisco Figueiredo Jr. Npgsql Lead Developer http://www.npgsql.org http://gplus.to/franciscojunior http://fxjr.blogspot.com http://twitter.com/franciscojunior ___ Mono-list maillist - Mono-list@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-list
[Mono-list] Does Mono.Security support SSL compression?
If so, is there any parameter which I can use to disable it? I'd like to add the possibility of disabling compression to Npgsql. Thanks in advance. -- Regards, Francisco Figueiredo Jr. Npgsql Lead Developer http://www.npgsql.org http://gplus.to/franciscojunior http://fxjr.blogspot.com http://twitter.com/franciscojunior ___ Mono-list maillist - Mono-list@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-list
[Mono-list] Npgsql 2.0.12 beta 2 released
Hi, all!! The Npgsql Development Team is proud to announce the Npgsql2 2.0.12 beta2 release! Npgsql is a .Net Data provider written 100% in C# which allows .net programs to talk to postgresql backends. Npgsql is licensed under BSD. More info can be obtained from http://www.npgsql.org This release is another step in the direction of the final 2.0.12 release. Here is the changelog of this version: Npgsql 2.0.11.92 ( 2.0.12 beta2) Fixed bugs: [#1011008] Add PhysicalAddress (MAC Address) support to Npgsql. Thanks Gildas for patche and test case. [#1010977] Add application_name support to connection string. Thanks Chris Coleman for patch. [ npgsql-Bugs-1011018 ] Invalid Cast with DbType.Time Parameter. Thanks Patrick Earl for patch. Also added test case to reproduce the problem. [#1011021] Support DbMetaDataCollectionNames.ReservedWords. Thanks Patrick Earl for patch. Fixed problem with last update about Password as byte[]. Reverted type of Password property of NpgsqlConnectionStringBuilder to String again. It was changed from String to byte[] which was causing problems with previous client code. There is a new property called PasswordAsByteArray for those willing to use the byte[] property. Thanks Dan Shoubridge for heads up. [#1011044]. Fixed missing NpgsqlDataReader.GetTimeSpan() method. Added unit test case to cover this method. Added patch from Patrick Earl. Thanks, Patrick! http://pgfoundry.org/forum/message.php?msg_id=1014749 This was implemented to support more of the NHibernate test suite. src/NpgsqlTypes/NpgsqlTypeConverters.cs: [npgsql-Patches-1011012 ] Australian Date and Time Formats. Thanks Hans Peter for patch Fixes to VS.Net project properties. Thanks Philippe Le Grand for heads up. Thank you very much for all the bug reports and patches sent! Thanks Josh Cooley for all his help with this release. Grab this version from: http://downloads.npgsql.org Feedback, comments and patches are always welcome! -- Regards, Francisco Figueiredo Jr. Npgsql Lead Developer http://www.npgsql.org http://gplus.to/franciscojunior http://fxjr.blogspot.com http://twitter.com/franciscojunior ___ Mono-list maillist - Mono-list@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-list
Re: [Mono-list] Problem open connection npgsql on mono 2.10(Windows)
I'm using Npgsql directly from source using Mono.Security.dll from Mono libraries. Anyway, Mono.Security assembly is only used if you are connecting to Postgresql through SSL, so I think it is not the problem. On Sun, Jun 26, 2011 at 16:08, Andrus wrote: > Delete Mono.Security.dll from your application so this dll from mono gac is > used. > > Andrus. > > > - Original Message - > From: "Khairuddin Ni'am" > To: > Sent: Friday, June 24, 2011 5:24 AM > Subject: Re: [Mono-list] Problem open connection npgsql on mono > 2.10(Windows) > > >> I'd alse tested on Mono 2.10.1 build 2 (Windows). The program run fine. >> >> So, the problem is specific on Mono 2.10.2 build 5 (Windows build) >> >> -- >> View this message in context: >> http://mono.1490590.n4.nabble.com/Problem-open-connection-npgsql-on-mono-2-10-Windows-tp3621423p3621515.html >> Sent from the Mono - General mailing list archive at Nabble.com. >> ___ >> Mono-list maillist - Mono-list@lists.ximian.com >> http://lists.ximian.com/mailman/listinfo/mono-list > > ___ > Mono-list maillist - Mono-list@lists.ximian.com > http://lists.ximian.com/mailman/listinfo/mono-list > -- Regards, Francisco Figueiredo Jr. Npgsql Lead Developer http://www.npgsql.org http://fxjr.blogspot.com http://twitter.com/franciscojunior ___ Mono-list maillist - Mono-list@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-list
Re: [Mono-list] Problem open connection npgsql on mono 2.10 (Windows)
Thanks Bojan for the heads up! I'll wait for a new release then. Regards, Em 24/06/2011 12:25, "Bojan Rajkovic" escreveu: > Hi guys, > > There's a bug in 2.10.2 as released on OS X with asynchronous connections. It is fixed in the mono-2-10 branch (it appears to be a problem in the class libraries, and not in the runtime), but for obvious reasons, no release has been made of anything post 2.10.3. > > —Bojan > > On Jun 24, 2011, at 11:15 AM, Francisco Figueiredo Jr. wrote: > >> I'm also having this problem with 10.2 on OSX. >> >> The day 10.2 was out, I downloaded and tested it and I sent a mail about that. >> >> For now, I'm using Mono 2.10 >> >> >> On Fri, Jun 24, 2011 at 06:50, Khairuddin Ni'am wrote: >>> Yes, I use the upstream library. I downloaded from official site : >>> http://npgsql.projects.postgresql.org/ >>> I use the latest version (Npgsql2.0.11.91-bin-mono2.0.zip) >>> >>> -- >>> View this message in context: http://mono.1490590.n4.nabble.com/Problem-open-connection-npgsql-on-mono-2-10-Windows-tp3621423p3622149.html >>> Sent from the Mono - General mailing list archive at Nabble.com. >>> ___________ >>> Mono-list maillist - Mono-list@lists.ximian.com >>> http://lists.ximian.com/mailman/listinfo/mono-list >>> >> >> >> >> -- >> Regards, >> >> Francisco Figueiredo Jr. >> Npgsql Lead Developer >> http://www.npgsql.org >> http://fxjr.blogspot.com >> http://twitter.com/franciscojunior >> ___ >> Mono-list maillist - Mono-list@lists.ximian.com >> http://lists.ximian.com/mailman/listinfo/mono-list > ___ Mono-list maillist - Mono-list@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-list
Re: [Mono-list] Problem open connection npgsql on mono 2.10 (Windows)
I'm also having this problem with 10.2 on OSX. The day 10.2 was out, I downloaded and tested it and I sent a mail about that. For now, I'm using Mono 2.10 On Fri, Jun 24, 2011 at 06:50, Khairuddin Ni'am wrote: > Yes, I use the upstream library. I downloaded from official site : > http://npgsql.projects.postgresql.org/ > I use the latest version (Npgsql2.0.11.91-bin-mono2.0.zip) > > -- > View this message in context: > http://mono.1490590.n4.nabble.com/Problem-open-connection-npgsql-on-mono-2-10-Windows-tp3621423p3622149.html > Sent from the Mono - General mailing list archive at Nabble.com. > ___ > Mono-list maillist - Mono-list@lists.ximian.com > http://lists.ximian.com/mailman/listinfo/mono-list > -- Regards, Francisco Figueiredo Jr. Npgsql Lead Developer http://www.npgsql.org http://fxjr.blogspot.com http://twitter.com/franciscojunior ___ Mono-list maillist - Mono-list@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-list
Re: [Mono-list] ADO.net issue with 2.11 master/b32093e Win32
I'm experiencing the same issue when working with Npgsql. It seems that it isn't being able to make the tcp connection. On Mon, Apr 25, 2011 at 21:37, Rod wrote: > Okay I have attached a Solution/Project to reproduce this test using: > > Windows 2008 R2 SP1 > SQL Server 2008 R2 w/AdventureWorks DB > Visual Studio 2010 SP1 w/Mono Tools for VS > Mono 2.11 master/b32093e Win32 (built w/Cygwin) > > I tried this using MonoDevelop 2.6 beta 2 it works against .Net 3, and > fails, with same exception, on 2.10.1 and wont even compile against > 2.11.b32093e which I found odd. > > Using Mono Tools for VS it worked against, .Net 4 and 2.10.1 and failed on > 2.11.b32093e with the noted exception. This could be because MonoDevelop > compiles with Mono while Mono Tools for VS "appears to" compile with .NET > and then runs with Mono. > > Either way here is a simple solution that can be used to recreate the issue, > and it found a new issue that you can't even compile this using the latest > mono from source, and it wont work against 2.10.1 when you are using > MonoDevelop 2.6. beta 2 for some reason. > > Basically just need to update the app.config with user name and password if > your AdventureWorks is localhost, ortherwise also update the Data Source > with the remote server name. > > http://mono.1490590.n4.nabble.com/file/n3474459/Mono211AdoTest.zip > Mono211AdoTest.zip > > > -- > View this message in context: > http://mono.1490590.n4.nabble.com/ADO-net-issue-with-2-11-master-b32093e-Win32-tp3473994p3474459.html > Sent from the Mono - General mailing list archive at Nabble.com. > ___ > Mono-list maillist - Mono-list@lists.ximian.com > http://lists.ximian.com/mailman/listinfo/mono-list > -- Regards, Francisco Figueiredo Jr. Npgsql Lead Developer http://www.npgsql.org http://fxjr.blogspot.com http://twitter.com/franciscojunior ___ Mono-list maillist - Mono-list@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-list
[Mono-list] Npgsql 2.0.12 beta1 released!
Hi, all!! The Npgsql Development Team is proud to announce the Npgsql2 2.0.12 beta1 release! Npgsql is a .Net Data provider written 100% in C# which allows .net programs to talk to postgresql backends. Npgsql is licensed under BSD. More info can be obtained from http://www.npgsql.org Thsi is the release notes: Npgsql 2.0.12 beta1 (2.0.11.91) Important Notice: This is a beta release intended to test some critical fixes added since last stable release. Special attention should be given to connection pool interactions. We improved connection pool of Npgsql. Previous implementation was letting connections to be leaked. Now this implementation keeps a reference to all the connections and keeps better track of them. We also improved connection validation from pool before delivering it to the user. This may fix problems where users were reporting strange data from new connections. Another attention should be paid to Dataset and DataAdapter operations. We changed some internals of NpgsqlCommandBuilder which may cause problems. We'd like you to check if you get problems. For more information check this thread: http://pgfoundry.org/tracker/?func=detail&atid=590&aid=1010973&group_id=1000140 Fixed bugs: [#1010951] AllowPartiallyTrustedCallers for npgsql assemblies. [#1010973] specified cast is invalid - datetime fields. In order to fix this bug I had to disable some code in NpgsqlCommandBuilder. Watch out for possible side effects. Fixed problems with SSPI authentication when the password had some non ascii characteres. Also, Npgsql supports to authenticate with an user name other than the current logged one. Thanks Ahmed Shinwari for tests and patch. [#1010997] Consider using System.Threading.Timer instead of System.Timers.Timer. Thanks Alex A Ermoshenko for feedback, patch and tests. NpgsqlConnector.CancelRequest leaks Connector. NpgsqlConnector.CancelRequest creates a connector to cancel the running request, but does not close it. More info at: http://pgfoundry.org/forum/forum.php?thread_id=10059&forum_id=519 Thanks David Leaver for patch. Exception when closing connection. If your connection is in the Ready state and the stream is actually broken NpgsqlReadyState.Close will throw an exception when trying to write to the stream. More info can be found at: http://pgfoundry.org/forum/forum.php?thread_id=10066&forum_id=519 Thanks David Leaver for the patch. In Multi-threaded applications there is a race condition that can occur which will result in a broken connection being re-added to the pool. Thanks David Leaver for patches. More information here: http://pgfoundry.org/forum/forum.php?thread_id=10067&forum_id=519 [#1010986] Endless recursion on hanging connection in ProcessBackendResponsesEnum. Thanks Gildas for feedback and tests. Enhancements: Added performance patch to GetKeyName method. Thanks Dan Smith for patch. http://lists.pgfoundry.org/pipermail/npgsql-devel/2011-February/001117.html You can see full changelog and release notes here: http://pgfoundry.org/frs/shownotes.php?release_id=1727 You can dowload it from here: http://downloads.npgsql.org Thank you to Josh Cooley for all his help with entity framework support! Thank you to all who sent feedbacks, suggestions and patches. You helped to make this release. Thank you very much to David Leaver who gave a lot of feedback and patches to improve connection pool. Please, give it a try and feel free to let us know if you find any problem. -- Regards, Francisco Figueiredo Jr. Npgsql Lead Developer http://www.npgsql.org http://fxjr.blogspot.com http://twitter.com/franciscojunior ___ Mono-list maillist - Mono-list@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-list
[Mono-list] Npgsql 2.0.11 released!
Hi, all!! The Npgsql Development Team is proud to announce the Npgsql2 2.0.11 release! Npgsql is a .Net Data provider written 100% in C# which allows .net programs to talk to postgresql backends. Npgsql is licensed under BSD. More info can be obtained from http://www.npgsql.org This release is a minor bug fix for the stable 2.0 series. The biggest highlights are: Fix for bytea handling with Postgresql 9.0. And many bug fixes: Fixed bugs: [#1010863] GroupBy Expression with two or more parameters creates a sql error [#1010860] [EF, 2.0.10.0] Invalid query is generated Added fix to return CLR type when working with NpgsqlInet and IPAddress types in NpgsqlDataReader.GetValue(). See http://pgfoundry.org/forum/message.php?msg_id=1006360 for more info about that. [#1010921] Data corrupted transferring bytea data from PostgreSQL 9 server. Thanks Mathieu Fenniak for patch. See http://pgfoundry.org/pipermail/npgsql-devel/2010-January/001057.html. This patch should have been applied a long time ago. It was my fault (Francisco) Sorry for that :( New Features: [#1010650] DbConnection.GetSchema: Metadata for Indexes You can see full changelog and release notes here: http://pgfoundry.org/frs/shownotes.php?release_id=1727 You can dowload it from here: http://downloads.npgsql.org Thank you to Josh Cooley for all his help with entity framework support! Thank you to all who sent feedbacks, suggestions and patches. You helped to make this release. Please, feel free to give it a try and let us know if you find any other problems. Also, if you like Npgsql and want to show how much you like it, send us a postcard! http://fxjr.blogspot.com/2008/12/did-you-like-npgsql-send-us-postcard.html -- Regards, Francisco Figueiredo Jr. Npgsql Lead Developer http://www.npgsql.org http://fxjr.blogspot.com http://twitter.com/franciscojunior ___ Mono-list maillist - Mono-list@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-list
Re: [Mono-list] Npgsql sample does not run, if manually compiled
I'm glad you got it working. If you need any other help, please let us know. Francisco Figueiredo Jr. Npgsql lead developer - www.npgsql.org Sent from my Android phone Em 31/10/2010 20:33, escreveu: Hello ! This was a problem with my hosts file :-( I am very sorry. The two - called "identical" - written programs differs in accessing the db server by name. The machine - a VM - was restored from scratch and contained a mismatch between hosts and postgres config. The message from Npgsql - connection refused - was really right :-( My fault! A BIG SORRY! br++mabra ___ Mono-list maillist - mono-l...@lists... ___ Mono-list maillist - Mono-list@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-list
Re: [Mono-list] Npgsql sample does not run, if manually compiled
Where is located your server postgresql and client problem? If they are in different machines, so the problem is just like Abe said. By default, postgresql allows only connections from localhost. You can change that by changing your pg_hba.conf and postgresql.conf files to allow other hosts to connect. Checkout pg_hba.conf file, which is located in your Postgresql Data folder. This file has some instructions inside it which will get you running. In your postgresql.conf file, you will need to find a line which reads: interfaces = localhost and change it to "*". This file also has explanations about it. I hope it helps. On Sat, Oct 30, 2010 at 12:44, Abe Gillespie wrote: > If you're running SharpDevelop, which is Windows only, does that mean you're > running your test program from two different machines? If so then you need to > configure your DB's pg_hba.conf file. > > Sent from phone. Please excuse brevity and mistakes. > > On Oct 30, 2010, at 9:00 AM, "manfred.braun" wrote: > >> Hi All ! >> >> I am just experimental working on the sample shown >> [http://www.mono-project.com/PostgreSQL] for postgres. The program compiles >> fine, this way: >> >> # gmcs -debug+ -t:exe NpgSqlTest.cs -r:System.Data -r:Npgsql >> >> but crashes with this message: >> >> # mono --debug NpgSqlTest.exe >> >> Unhandled Exception: Npgsql.NpgsqlException: >> Connection refused >> at Npgsql.NpgsqlClosedState.Open (Npgsql.NpgsqlConnector context) >> [0x0] >> at Npgsql.NpgsqlConnector.Open () [0x0] >> at Npgsql.NpgsqlConnectorPool.GetPooledConnector (Npgsql.NpgsqlConnection >> Connection) [0x0] >> >> The completely unexpected thing is:If I make a project with SharpDevelop the >> program [without source changes!] compiles AND runs ! It is >> NOT a "connection refused" issue [at the same time, I am connected]. >> >> Anyone any ideas, what happening here? >> >> I am just in a early beginner situation, where I expect all [simple] proggis >> to compile and run from the commandline. This looks like missing a compiler >> switch [I think, I tried them all], a defined environment or something like >> this. >> >> I am using: >> >> debian lenny, 2.6.26-2-686 >> mono 1.9.1, containing corelib 2.0 >> >> Any help would be really great! >> >> br++mabra >> >> >> _______ >> Mono-list maillist - mono-l...@lists.ximian.com >> http://lists.ximian.com/mailman/listinfo/mono-list > ___ > Mono-list maillist - mono-l...@lists.ximian.com > http://lists.ximian.com/mailman/listinfo/mono-list > -- Regards, Francisco Figueiredo Jr. Npgsql Lead Developer http://www.npgsql.org http://fxjr.blogspot.com http://twitter.com/franciscojunior ___ Mono-list maillist - Mono-list@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-list
[Mono-list] Npgsql 2.0.10 released!
Hi, all!! The Npgsql Development Team is proud to announce the Npgsql2 2.0.10 release! Npgsql is a .Net Data provider written 100% in C# which allows .net programs to talk to postgresql backends. It works with Mono and MS.Net. Npgsql is licensed under BSD. More info can be obtained from http://www.npgsql.org Important Notice: Possible breaking change: This release adds support for NpgsqlParameter.NpgsqlValue. This means that Npgsql specific types will be returned by this property. NpgsqlParameter.Value will return *only* CLR types. So, if you are expecting to work with Npgsql specific types, please use NpgsqlParameter.NpgsqlValue property. Sorry for this problem. This change will help Npgsql to conform better with ADO.NET DataSet and other helper classes. This version fixes a multithread problem where even using a different connection for each thread it was possible to corrupt data received by Npgsql. This bug was introduced in 2.0.9 and it is now fixed. If you are getting "The backend sent an unrecognized response" exceptions, there is a high probability that this bug is causing it. Please, upgrade. Fixed bugs: [#1010796] Notification thread not released after copy from stdin. Fixed problems when updating data with DataTable. See http://pgfoundry.org/forum/message.php?msg_id=1005598 [#1010804] Endless loop in BitString? Fix multi-level join generated sql [#1010829] Fix support for CommandBehavior.SequentialAccess with multiple columns. [#1010825] support derive parameters for parameterless functions support null items in arrays NpgsqlSchema.ssdl: provide default value during model generation [#1010776] for a prepared command, ExecuteNonQuery() does not return. [#1010787] Inserting an array does not work in a prepared statement. [#1010798] Cast-Exception with NpgsqlTimeStamp to System.DateTime. New Features: Added VS2010 project file Support for Time types and DateTimeOffset types in Entity Framework Josh Cooley ported a lot of Mono tests so we may expect to have more conformance versions of Npgsql on next releases. This version adds NpgsqlParameter.NpgsqlValue property. Now, developers who want to work with Npgsql specific types can use this property. See Important Notice about possible breaking change this might cause. You can see full changelog and release notes here: http://pgfoundry.org/frs/shownotes.php?release_id=1686 You can dowload it from here: http://downloads.npgsql.org Thank you to Josh Cooley for all his help with entity framework support! Thank you to all who sent feedbacks, suggestions and patches. You helped to make this release. Please, feel free to give it a try and let us know if you find any other problems. Also, if you liked Npgsql and want to show how much, please, send us a postcard! http://fxjr.blogspot.com/2008/12/did-you-like-npgsql-send-us-postcard.html -- Regards, Francisco Figueiredo Jr. Npgsql Lead Developer http://www.npgsql.org http://fxjr.blogspot.com http://twitter.com/franciscojunior ___ Mono-list maillist - Mono-list@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-list
Re: [Mono-list] Generics and PostgreSQL
On Mon, May 24, 2010 at 06:18, Cafer Simsek wrote: > Hi All, > Hi Cafer! > I'm very new to Mono. > > I want to migrate one of my projects to Mono. The project uses two SQL > Client (MsSQL and PostgreSQL), and has a GenericSQLHelper class: > http://codepaste.net/5g9ye4 > > When using MsSQL with this helper (mssqlHelper = new > GenericSQLHelper(cs_mssql);) > working great but it's not working on any PostgreSQL client that I've > tested (Npgsql and Devart's PostgreSQL client). > > It throws an exception on line 182 (GenericSQLHelper.cs). > > It's working great on MS .Net Framework. And it also working on Mono > when using plain method (without generics). > Do you have a working example which shows the problem? Which error are you getting? Thanks in advance. -- Regards, Francisco Figueiredo Jr. Npgsql Lead Developer http://www.npgsql.org http://fxjr.blogspot.com http://twitter.com/franciscojunior ___ Mono-list maillist - Mono-list@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-list
[Mono-list] mono.pc says it requires gthread-2.0 and glib-2.0. Where are those .pc files on OSX install?
Hi all! I notice that after installing a lot of times Mono on my macbook. Am I missing something? Because when I try to run Nant, it uses its internal pkg-config which gives me problem with not being able to find mono because pkg-lib can't satisfy the gthread and glib requirements. I have to manually remove the line from mono.pc file: Requires: glib-2.0 gthread-2.0 and then everything works, but I don't know if I'm breaking something. Thanks in advance for any help. -- Regards, Francisco Figueiredo Jr. Npgsql Lead Developer http://www.npgsql.org http://fxjr.blogspot.com http://twitter.com/franciscojunior ___ Mono-list maillist - Mono-list@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-list
[Mono-list] Npgsql 2.0.8 released!
Hi, all!! The Npgsql Development Team is proud to announce the Npgsql2 2.0.8 release! Npgsql is a .Net Data provider written 100% in C# which allows .net programs to talk to postgresql backends. Npgsql is licensed under BSD. More info can be obtained from http://www.npgsql.org This release is a minor bug fix for the stable 2.0 series. The biggest highlights are: 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. And many bug fixes: 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. You can see full changelog and release notes here: http://pgfoundry.org/frs/shownotes.php?release_id=1550 You can dowload it from here: http://downloads.npgsql.org Thank you to Josh Cooley for all his help with entity framework support! Thank you to all who sent feedbacks, suggestions and patches. You helped to make this release. Please, feel free to give it a try and let us know if you find any other problems. Also, if you like Npgsql and want to show how much you like it, send us a postcard! http://fxjr.blogspot.com/2008/12/did-you-like-npgsql-send-us-postcard.html -- Regards, Francisco Figueiredo Jr. Npgsql Lead Developer http://www.npgsql.org http://fxjr.blogspot.com http://twitter.com/franciscojunior ___ Mono-list maillist - Mono-list@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-list
Re: [Mono-list] Mono and NPGSQL problems, help please!!
On Wed, Nov 18, 2009 at 10:21, Martín Neu wrote: > Hi Robert, > > Mono JIT compiler version 2.4.2.3 (tarball) > Copyright (C) 2002-2008 Novell, Inc and Contributors. www.mono-project.com > TLS: normal > GC: Included Boehm (with typed GC) > SIGSEGV: normal > Notification: Thread + polling > Architecture: x86 > Disabled: none > > Thanks! > Hi, Martín! I tried here your sample on Ubuntu 9.10 with official ubuntu package and it showed your markup message with no errors. :( The only thing I'm doing with your sample is to change to the root of the directory and running xsp2 on it. Is there any other thing you do? Thanks in advance. > On Wed, Nov 18, 2009 at 9:03 AM, Robert Jordan wrote: >> >> Martín Neu wrote: >> > Fransisco, >> > >> > I tried in two diferent computer's, each one with windows environment >> > and >> > the last release of mono. >> >> Please post the output of "mono -V". >> >> Robert >> >> >> ___ >> Mono-list maillist - mono-l...@lists.ximian.com >> http://lists.ximian.com/mailman/listinfo/mono-list > > > _______ > Mono-list maillist - mono-l...@lists.ximian.com > http://lists.ximian.com/mailman/listinfo/mono-list > > -- Regards, Francisco Figueiredo Jr. Npgsql Lead Developer http://www.npgsql.org http://fxjr.blogspot.com http://twitter.com/franciscojunior ___ Mono-list maillist - Mono-list@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-list
Re: [Mono-list] Mono and NPGSQL problems, help please!!
On Tue, Nov 17, 2009 at 23:40, Martín Neu wrote: > Fransisco, > > I tried in two diferent computer's, each one with windows environment and > the last release of mono. > > I think the problem is not the instalation of mono (i install all items). > I compiled sucessfuly a console application, but fails with a ASP.NET web > application, the problem maybe is with the XSP server... > > Thanks for your help!, I realy lost with this!! > Did you try to to compile Mono in your system? Also, did you try your app on Gnu/Linux or OSX? I hope it helps. > On Tue, Nov 17, 2009 at 10:29 PM, Francisco Figueiredo Jr. > wrote: >> >> On Tue, Nov 17, 2009 at 11:04, Martín Neu wrote: >> > I send you heare a sample. >> > When runing with MS compiles there is no error, but when runing with XSP >> > (Mono VS Debug tools) i get the error. >> > >> > Thanks!!! >> > >> >> Hi, Martín! >> >> I tested your sample code here and it showed up the label ok. >> >> I tested it on OSX with latest mono release. >> >> Maybe there is a chance your mono install is not ok? >> >> I hope it helps >> >> >> >> > On Tue, Nov 17, 2009 at 9:54 AM, Francisco Figueiredo Jr. >> > wrote: >> >> >> >> It's strange. >> >> Can you send me a test sample? >> >> I can try it here in my dev machine and see if I get the same problem >> >> you >> >> are getting. >> >> Thanks in advance >> >> >> >> Regards, >> >> Francisco Figueiredo Jr. >> >> Npgsql Lead Developer >> >> http://www.npgsql.org >> >> http://fxjr.blogspot.com >> >> http://twitter.com/franciscojunior >> >> On 17/11/2009, at 09:46, Martín Neu wrote: >> >> >> >> Hi! >> >> >> >> I use the version 2.0.7, but i try with 2.0.6 too. >> >> I try with booth mono and ms compiled version's. >> >> >> >> I realy lost... >> >> >> >> On Mon, Nov 16, 2009 at 11:30 PM, Francisco Figueiredo Jr. >> >> wrote: >> >>> >> >>> On Mon, Nov 16, 2009 at 11:45, Martín Neu >> >>> wrote: >> >>> > I just tried remove Mono.Security and only reference NPGSQL, but i >> >>> > get >> >>> > the >> >>> > same error. >> >>> > I think NPGSQL was compiled whit Mono.Security inside. >> >>> > >> >>> > Other thing i try is re-compile npgsql referencing Mono.Security >> >>> > located in >> >>> > the Mono GAC, but fail again. >> >>> > >> >>> > Any idea? >> >>> > >> >>> >> >>> Which Npgsql version did you get? >> >>> >> >>> I think you are using the ms.net compiled binary. Try to use the Mono >> >>> compiled binary. >> >>> >> >>> I know this shouldn't give you different results, but I've seen cases >> >>> where you get problems by using Mono compiled binary with ms.net and >> >>> vice-versa. >> >>> >> >>> I hope it helps. >> >>> >> >>> >> >>> >> >>> >> >>> > On Mon, Nov 16, 2009 at 10:39 AM, Marek Habersack >> >>> > >> >>> > wrote: >> >>> >> >> >>> >> Martín Neu wrote: >> >>> >>> >> >>> >>> Hi Marek! >> >>> >> >> >>> >> Hey, >> >>> >> >> >>> >>> >> >>> >>> I can't remove it becouse i need the npgsql library to connect my >> >>> >>> application to PostgreSQL. >> >>> >> >> >>> >> Yes, you can remove it. Mono has its own copy of Mono.Security and >> >>> >> the >> >>> >> one >> >>> >> distributed with Npgsql (for the benefit of .NET), that is the one >> >>> >> you're >> >>> >> most likely using, is too old for your Mono. >> >>> >> >> >>> >> marek >> >>> >>> >> >>> >>> Any other idea? >> >>> >>> >> >>> >>> Thanks! >> >>> >>> >> >>> >>>
Re: [Mono-list] Mono and NPGSQL problems, help please!!
On Tue, Nov 17, 2009 at 11:04, Martín Neu wrote: > I send you heare a sample. > When runing with MS compiles there is no error, but when runing with XSP > (Mono VS Debug tools) i get the error. > > Thanks!!! > Hi, Martín! I tested your sample code here and it showed up the label ok. I tested it on OSX with latest mono release. Maybe there is a chance your mono install is not ok? I hope it helps > On Tue, Nov 17, 2009 at 9:54 AM, Francisco Figueiredo Jr. > wrote: >> >> It's strange. >> Can you send me a test sample? >> I can try it here in my dev machine and see if I get the same problem you >> are getting. >> Thanks in advance >> >> Regards, >> Francisco Figueiredo Jr. >> Npgsql Lead Developer >> http://www.npgsql.org >> http://fxjr.blogspot.com >> http://twitter.com/franciscojunior >> On 17/11/2009, at 09:46, Martín Neu wrote: >> >> Hi! >> >> I use the version 2.0.7, but i try with 2.0.6 too. >> I try with booth mono and ms compiled version's. >> >> I realy lost... >> >> On Mon, Nov 16, 2009 at 11:30 PM, Francisco Figueiredo Jr. >> wrote: >>> >>> On Mon, Nov 16, 2009 at 11:45, Martín Neu wrote: >>> > I just tried remove Mono.Security and only reference NPGSQL, but i get >>> > the >>> > same error. >>> > I think NPGSQL was compiled whit Mono.Security inside. >>> > >>> > Other thing i try is re-compile npgsql referencing Mono.Security >>> > located in >>> > the Mono GAC, but fail again. >>> > >>> > Any idea? >>> > >>> >>> Which Npgsql version did you get? >>> >>> I think you are using the ms.net compiled binary. Try to use the Mono >>> compiled binary. >>> >>> I know this shouldn't give you different results, but I've seen cases >>> where you get problems by using Mono compiled binary with ms.net and >>> vice-versa. >>> >>> I hope it helps. >>> >>> >>> >>> >>> > On Mon, Nov 16, 2009 at 10:39 AM, Marek Habersack >>> > >>> > wrote: >>> >> >>> >> Martín Neu wrote: >>> >>> >>> >>> Hi Marek! >>> >> >>> >> Hey, >>> >> >>> >>> >>> >>> I can't remove it becouse i need the npgsql library to connect my >>> >>> application to PostgreSQL. >>> >> >>> >> Yes, you can remove it. Mono has its own copy of Mono.Security and the >>> >> one >>> >> distributed with Npgsql (for the benefit of .NET), that is the one >>> >> you're >>> >> most likely using, is too old for your Mono. >>> >> >>> >> marek >>> >>> >>> >>> Any other idea? >>> >>> >>> >>> Thanks! >>> >>> >>> >>> >>> >>> On Mon, Nov 16, 2009 at 10:32 AM, Marek Habersack >>> >>> mailto:gren...@twistedcode.net>> wrote: >>> >>> >>> >>> MNEU wrote: >>> >>> >>> >>> Hi! >>> >>> >>> >>> Hello >>> >>> >>> >>> >>> >>> I'm using mono in Windows environment (using npgsql), when i >>> >>> run >>> >>> the proyect >>> >>> with MS compiler i have no errors and work fine. But when i >>> >>> use >>> >>> the mono >>> >>> compiler i get this error: >>> >>> >>> >>> >>> >>> ** (C:\Program >>> >>> Files\Mono-2.4.2.3\lib\mono\2.0\winhack\xsp2.exe:4188): >>> >>> WARNING **: Missing method >>> >>> >>> >>> >>> >>> Mono.WebServer.XSPWebSource::.ctor(IPAddress,int,SecurityProtocolType,X509Certificate,PrivateKeySelectionCallback,bool,bool,bool) >>> >>> in assembly C:\Program >>> >>> >>> >>> >>> >>> Files\Mono-2.4.2.3\lib\mono\gac\Mono.WebServer2\0.2.0.0__0738eb9f132ed756\Mono.WebServer2.dll, >>> >>> referenced in assembly C:\Program >>> >>> >>> >>> >>> >>> Files\Mono-2.4.2.3\lib\mono\gac\xsp2\2.4.2.0__0738eb9f132ed756\xsp2.exe >>> >>> >>> >>> >>> >>> I have the Mono.Security.dll referenced and in the same >>> >>> directory. >>> >>> >>> >>> Remove it and it will work >>> >>> >>> >>> marek >>> >>> >>> >>> >>> >> >>> > >>> > >>> > ___ >>> > Mono-list maillist - mono-l...@lists.ximian.com >>> > http://lists.ximian.com/mailman/listinfo/mono-list >>> > >>> > >>> >>> >>> >>> -- >>> Regards, >>> >>> Francisco Figueiredo Jr. >>> Npgsql Lead Developer >>> http://www.npgsql.org >>> http://fxjr.blogspot.com >>> http://twitter.com/franciscojunior >> > > -- Regards, Francisco Figueiredo Jr. Npgsql Lead Developer http://www.npgsql.org http://fxjr.blogspot.com http://twitter.com/franciscojunior Sent from Brasilia, DF, Brazil ___ Mono-list maillist - Mono-list@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-list
Re: [Mono-list] Mono and NPGSQL problems, help please!!
On Mon, Nov 16, 2009 at 11:45, Martín Neu wrote: > I just tried remove Mono.Security and only reference NPGSQL, but i get the > same error. > I think NPGSQL was compiled whit Mono.Security inside. > > Other thing i try is re-compile npgsql referencing Mono.Security located in > the Mono GAC, but fail again. > > Any idea? > Which Npgsql version did you get? I think you are using the ms.net compiled binary. Try to use the Mono compiled binary. I know this shouldn't give you different results, but I've seen cases where you get problems by using Mono compiled binary with ms.net and vice-versa. I hope it helps. > On Mon, Nov 16, 2009 at 10:39 AM, Marek Habersack > wrote: >> >> Martín Neu wrote: >>> >>> Hi Marek! >> >> Hey, >> >>> >>> I can't remove it becouse i need the npgsql library to connect my >>> application to PostgreSQL. >> >> Yes, you can remove it. Mono has its own copy of Mono.Security and the one >> distributed with Npgsql (for the benefit of .NET), that is the one you're >> most likely using, is too old for your Mono. >> >> marek >>> >>> Any other idea? >>> >>> Thanks! >>> >>> >>> On Mon, Nov 16, 2009 at 10:32 AM, Marek Habersack >>> mailto:gren...@twistedcode.net>> wrote: >>> >>> MNEU wrote: >>> >>> Hi! >>> >>> Hello >>> >>> >>> I'm using mono in Windows environment (using npgsql), when i run >>> the proyect >>> with MS compiler i have no errors and work fine. But when i use >>> the mono >>> compiler i get this error: >>> >>> >>> ** (C:\Program >>> Files\Mono-2.4.2.3\lib\mono\2.0\winhack\xsp2.exe:4188): >>> WARNING **: Missing method >>> >>> Mono.WebServer.XSPWebSource::.ctor(IPAddress,int,SecurityProtocolType,X509Certificate,PrivateKeySelectionCallback,bool,bool,bool) >>> in assembly C:\Program >>> >>> Files\Mono-2.4.2.3\lib\mono\gac\Mono.WebServer2\0.2.0.0__0738eb9f132ed756\Mono.WebServer2.dll, >>> referenced in assembly C:\Program >>> >>> Files\Mono-2.4.2.3\lib\mono\gac\xsp2\2.4.2.0__0738eb9f132ed756\xsp2.exe >>> >>> >>> I have the Mono.Security.dll referenced and in the same directory. >>> >>> Remove it and it will work >>> >>> marek >>> >>> >> > > > ___ > Mono-list maillist - mono-l...@lists.ximian.com > http://lists.ximian.com/mailman/listinfo/mono-list > > -- Regards, Francisco Figueiredo Jr. Npgsql Lead Developer http://www.npgsql.org http://fxjr.blogspot.com http://twitter.com/franciscojunior ___ Mono-list maillist - Mono-list@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-list
Re: [Mono-list] [Mono-aspnet-list] sqlite questions?
Yeap, we changed license so it would be more aligned with server license itself and also to help users with commercial products. Although LGPL already allowed them to use Npgsql, they had fears about it. Another motivation was VS.Net design support which may impose some restrictions in code distribution in source form which would give a conflict with LGPL. On Tue, Nov 3, 2009 at 13:04, Daniel Morgan wrote: > Npgsql developers have re-licensed Npgsql under the BSD license. > http://fxjr.blogspot.com/2007/08/npgsql-license-changed-to-bsd_27.html > > Npgsql > http://npgsql.projects.postgresql.org/ > > Plus, Npgsql has (copied from the Npgsql web page): > > # Support for .Net 2.0 and 3.5 > # Entity Framework (EF): In order to use it, you have to download a special > build with the 3.5 suffix in its name on our download page. > # Improved performance for large resultsets:Different from Npgsql1, Npgsql2 > doesn't read all table contents before returning control to user code. This > makes Npgsql much more memory efficient when dealing with large tables. > # ASP.Net Providers > > --- On Tue, 11/3/09, Marek Habersack wrote: > >> From: Marek Habersack >> Subject: Re: [Mono-list] [Mono-aspnet-list] sqlite questions? >> To: "william leader" >> Cc: "Dale E. Moore" , Mono-list@lists.ximian.com, >> "monodevelop-list" , >> mono-aspnet-l...@lists.ximian.com >> Date: Tuesday, November 3, 2009, 3:58 AM >> william leader wrote: > ... >> Much better choice, as >> somebody else suggested, is PostgreSQL - >> its .NET driver (Npgsql) is LGPL, has all the >> features you mentioned (membership, profile, role) >> and is shipped with Mono. > ... > > > > _______ > Mono-list maillist - mono-l...@lists.ximian.com > http://lists.ximian.com/mailman/listinfo/mono-list > -- Regards, Francisco Figueiredo Jr. Npgsql Lead Developer http://www.npgsql.org http://fxjr.blogspot.com http://twitter.com/franciscojunior ___ Mono-list maillist - Mono-list@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-list
[Mono-list] Npgsql 2.0.6 released!
Hi, all!! The Npgsql Development Team is proud to announce the Npgsql2 2.0.6 release! Npgsql is a .Net Data provider written 100% in C# which allows .net programs to talk to postgresql backends. Npgsql is licensed under BSD. More info can be obtained from http://www.npgsql.org This release is a minor bug fix for the stable 2.0 series. The biggest highlights are: This build should fix the problems people is having with long running queries being cancelled even when the developer sets a high timeout. Thanks Adriaan, Npgsql now performs function checks much faster on setups which have too many functions as now Npgsql sends a query which allows server to use indexes to find the function. Josh Cooley added fixes to some culture sensible queries. He also fixed problems with unions and NULL values in columns Visual Studio Designer support (not working right now) Josh Cooley started to add visual studio designer support to Npgsql. It is not working yet. We are using excellent Robert Simpson's sqlite provider code as a base to ours. Thank you Robert! You can see full changelog and release notes here: http://pgfoundry.org/frs/shownotes.php?release_id=1434 You can dowload it from here: http://downloads.npgsql.org Thank you to Josh Cooley for all his help with entity framework support! Thank you to all who sent feedbacks, suggestions and patches. You helped to make this release. Please, feel free to give it a try and let us know if you find any other problems. Also, if you like Npgsql and want to show how much you like it, send us a postcard! http://fxjr.blogspot.com/2008/12/did-you-like-npgsql-send-us-postcard.html -- Regards, Francisco Figueiredo Jr. Npgsql Lead Developer http://www.npgsql.org http://fxjr.blogspot.com http://twitter.com/franciscojunior ___ Mono-list maillist - Mono-list@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-list
[Mono-list] Npgsql 2.0.5 released!
Hi, all!! The Npgsql Development Team is proud to announce the Npgsql2 2.0.5 release! Npgsql is a .Net Data provider written 100% in C# which allows .net programs to talk to postgresql backends. Npgsql is licensed under BSD. More info can be obtained from http://www.npgsql.org This release is a minor bug fix for the stable 2.0 series. The biggest highlights are: Fixes for entity framework support thanks Josh Cooley Fix for a regression when using prepared statements with parameters with size specified. This broke Daniel's asp.net provider support in some cases. Fix for the famous bug of Seek not supported exception. Now Npgsql handles this situation better. It is not a complete fix but it is a nice step on this direction. You can see full changelog and release notes here: http://pgfoundry.org/frs/shownotes.php?release_id=1366 You can dowload it from here: http://downloads.npgsql.org Thank you to Josh Cooley for all his help with entity framework support! Thank you to all who sent feedbacks, suggestions and patches for your help to make this release. Please, feel free to give it a try and let us know if you find any other problems. Also, if you like Npgsql and want to show how much you like it, send us a postcard! http://fxjr.blogspot.com/2008/12/did-you-like-npgsql-send-us-postcard.html -- Regards, Francisco Figueiredo Jr. Npgsql Lead Developer http://www.npgsql.org http://fxjr.blogspot.com http://twitter.com/franciscojunior Sent from Brasilia, DF, Brazil ___ Mono-list maillist - Mono-list@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-list
Re: [Mono-list] aspsqlprovider problem select table users
On Tue, Mar 17, 2009 at 16:17, Francisco Figueiredo Jr.
wrote:
> On Sat, Mar 14, 2009 at 18:11, Rodrigo Cuevas wrote:
>> Hi,
>>
>> The problem is in the method GetParseCommandText() in file NpgsqlCommand.cs
>>
>> Comment lines:
>>
>> if (parameters[i].TypeInfo.UseSize && (parameters[i].Size > 0))
>> {
>> parseCommand += string.Format("({0})", parameters[i].Size);
>> }
>>
>> Now work.
>>
>> It is a bug in Npgsql 2.0.4 or not?
>>
>
> Hi, Rodrigo!
>
> It seems to be a bug in Npgsql indeed.
> We received today a report about it:
>
> http://pgfoundry.org/forum/message.php?msg_id=1004741
>
> I'll be working to get a testcase for this and apply the fix so we
> don't get this problem again in future releases.
>
> Thank you and Daniel for your feedback on this.
>
>
Fix applied.
Please, grab latest cvs and give it a try.
Thanks for feedback!
--
Regards,
Francisco Figueiredo Jr.
Npgsql Lead Developer
http://www.npgsql.org
http://fxjr.blogspot.com
http://twitter.com/franciscojunior
Sent from: Brasilia DF Brazil.
___
Mono-list maillist - Mono-list@lists.ximian.com
http://lists.ximian.com/mailman/listinfo/mono-list
Re: [Mono-list] aspsqlprovider problem select table users
2009/3/17 Rodrigo Cuevas :
> Hi Francisco, thank.
>
Hi, Rodrigo!
You are welcome!
> Other code with problem:
>
> MembershipUser user = Membership.GetUser("testuser"); //ok
> string pass = user.GetPassword(); //error
>
> Error:
>
> Unable to cast object of type 'System.DBNull' to type 'System.String'.
>
> D:\Sigem7\src\Npgsql2.0.4.src\src\Npgsql\NpgsqlDataReader.cs Line: 306
> public override String GetString(Int32 i)
> Line 305: {
> Line 306: return (String) GetValue(i); //error
> Line 307: }
>
> Stack Trace:
>
> [InvalidCastException: Unable to cast object of type 'System.DBNull' to type
> 'System.String'.]
> Npgsql.NpgsqlDataReader.GetString(Int32 i) in
> D:\Sigem7\src\Npgsql2.0.4.src\src\Npgsql\NpgsqlDataReader.cs:306
> NauckIT.PostgreSQLProvider.PgMembershipProvider.GetPassword(String
> username, String answer) in
> D:\Sigem7\src\NauckIT.PostgreSQLProvider-1.2.4.0\PgMembershipProvider.cs:782
>
> Error Npgsql 2.0.4 or not ?
>
In this case, this error is by design.
Npgsql as well as other providers don't handle null values on their
get* methods.
You should call IsDBNull to test this.
http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqldatareader.getint32.aspx
"No conversions are performed; therefore, the data retrieved must
already be a 32-bit signed integer.
Call IsDBNull to check for null values before calling this method."
I hope it helps.
--
Regards,
Francisco Figueiredo Jr.
Npgsql Lead Developer
http://www.npgsql.org
http://fxjr.blogspot.com
http://twitter.com/franciscojunior
Sent from: Brasilia DF Brazil.
___
Mono-list maillist - Mono-list@lists.ximian.com
http://lists.ximian.com/mailman/listinfo/mono-list
Re: [Mono-list] aspsqlprovider problem select table users
On Sat, Mar 14, 2009 at 18:11, Rodrigo Cuevas wrote:
> Hi,
>
> The problem is in the method GetParseCommandText() in file NpgsqlCommand.cs
>
> Comment lines:
>
> if (parameters[i].TypeInfo.UseSize && (parameters[i].Size > 0))
> {
> parseCommand += string.Format("({0})", parameters[i].Size);
> }
>
> Now work.
>
> It is a bug in Npgsql 2.0.4 or not?
>
Hi, Rodrigo!
It seems to be a bug in Npgsql indeed.
We received today a report about it:
http://pgfoundry.org/forum/message.php?msg_id=1004741
I'll be working to get a testcase for this and apply the fix so we
don't get this problem again in future releases.
Thank you and Daniel for your feedback on this.
--
Regards,
Francisco Figueiredo Jr.
Npgsql Lead Developer
http://www.npgsql.org
http://fxjr.blogspot.com
http://twitter.com/franciscojunior
___
Mono-list maillist - Mono-list@lists.ximian.com
http://lists.ximian.com/mailman/listinfo/mono-list
[Mono-list] Npgsql2 2.0.4 released!
Hi, all!! A little bit late announcement: The Npgsql Development Team is proud to announce the Npgsql2 2.0.4 release! Npgsql is a .Net Data provider written 100% in C# which allows .net programs to talk to postgresql backends. Npgsql is licensed under BSD. More info can be obtained from http://www.npgsql.org This release is a minor bug fix for the stable 2.0 final release. It contains fixes for last minute breaks of bytea support and culture dependent floating point representation in 2.0.3 release. Npgsql was sending floating point values with a comma where locale uses it. i.e.: 14.4 as 14,5 in en_ES. You can see full changelog and release notes here: http://pgfoundry.org/frs/shownotes.php?release_id=1325 You can dowload it from here: http://downloads.npgsql.org Thank you to Josh Cooley for all his help with entity framework support! Please, give it a try and let us know if you have any problems. Check out our forums: http://forums.npgsql.org -- Regards, Francisco Figueiredo Jr. Npgsql Lead Developer http://www.npgsql.org http://fxjr.blogspot.com http://twitter.com/franciscojunior ___ Mono-list maillist - Mono-list@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-list
[Mono-list] Npgsql 2.0.3 released!
Hi, all!! The Npgsql Development Team is proud to announce the Npgsql2 2.0.3 release! Npgsql is a .Net Data provider written 100% in C# which allows .net programs to talk to postgresql backends. Npgsql is licensed under BSD. More info can be obtained from http://www.npgsql.org This release is a minor bug fix for the stable 2.0 series. The biggest highlight goes to fixes for entity framework support thanks Josh Cooley Jon Hanna added a lot of improvements to Npgsql. You can see full changelog and release notes here: http://pgfoundry.org/frs/shownotes.php?release_id=1320 You can dowload it from here: http://downloads.npgsql.org Thank you to Josh Cooley for all his help with entity framework support! Thanks Jon Hanna for all your help on fixes and improvements. Please, give it a try and let us know if you have any problems. Check out our forums: http://forums.npgsql.org P.S.: If you like Npgsql, you can send us a postcard. Here are the addresses: Josh Cooley 102 Boston Harbour Way Madison, AL 35758 USA Francisco Figueiredo Jr. QMSW 05 Lote 02 Bloco C Apto 116 Sudoeste - Brasilia - DF - Brazil Zip Code: 70680-500 Brazil Thank you very much! -- Regards, Francisco Figueiredo Jr. Npgsql Lead Developer http://fxjr.blogspot.com http://www.npgsql.org ___ Mono-list maillist - Mono-list@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-list
[Mono-list] Npgsql 2.0.2 released!
Hi, all!! The Npgsql Development Team is proud to announce the Npgsql2 2.0.2 release! Npgsql is a .Net Data provider written 100% in C# which allows .net programs to talk to postgresql backends. Npgsql is licensed under BSD. More info can be obtained from http://www.npgsql.org This release is a minor bug fix for the stable 2.0.1 final release. Fixes: Fix the fix for datetime.MinValue and MaxValue. Only MinValue was fixed. Now both Min and Max are fixed. Thanks Andrus Moor for heads up.(fxjr) Fixed problem with parameter sizes and prepared statements.(fxjr) [#1010488] NgsqlParameter of type containing DBNull values throws NullReferenceException [#1010521] NpgsqlInterval should be quoted. Datetime with negative values (thanks to Mathieu Fenniak ) and singular values such as "1 day" [#1010495] Bad performance calling a (empty) function very often. New additions: Added documentation about how to use Npgsql with Provider Factory. Thanks Alaric for heads up. Ensure refcursors work with System.Transactions. (Josh) On this release, Josh Cooley fixed some bugs on Entity Framework support and System.Transactions. For more information about those and other fixes, please, see our ChangeLog. You can see full changelog and release notes here: http://pgfoundry.org/frs/shownotes.php?release_id=1273 You can dowload it from here: http://downloads.npgsql.org Thank you to Josh Cooley for all his help with entity framework support! Please, give it a try and let us know if you have any problems. Check out our forums: http://forums.npgsql.org Did you like Npgsql? You can tell us how much you liked by sending us a postcard. You can send your postcard to these addresses: Josh Cooley 102 Boston Harbour Way Madison, AL 35758 USA Francisco Figueiredo Jr. QMSW 05 Lote 02 Bloco C Apto 116 Sudoeste - Brasilia - DF - Brazil Zip Code: 70680-500 -- Regards, Francisco Figueiredo Jr. Npgsql Lead Developer http://fxjr.blogspot.com http://www.npgsql.org ___ Mono-list maillist - Mono-list@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-list
[Mono-list] Npgsql 2.0.1 released!
Hi, all!! The Npgsql Development Team is proud to announce the Npgsql2 2.0.1 release! Npgsql is a .Net Data provider written 100% in C# which allows .net programs to talk to postgresql backends. Npgsql is licensed under BSD. More info can be obtained from http://www.npgsql.org This release is a minor bug fix for the stable 2.0 final release. The biggest highlight goes to small fixes for entity framework support. You can see full changelog and release notes here: http://pgfoundry.org/frs/shownotes.php?release_id=1244 You can dowload it from here: http://downloads.npgsql.org Thank you to Josh Cooley for all his help with entity framework support! Please, give it a try and let us know if you have any problems. Check out our forums: http://forums.npgsql.org -- Regards, Francisco Figueiredo Jr. Npgsql Lead Developer http://fxjr.blogspot.com http://www.npgsql.org ___ Mono-list maillist - Mono-list@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-list
[Mono-list] Npgsql2 Final Released!!
Hi, all! The Npgsql Development Team is proud to announce the Npgsql2 RTM! Npgsql is a .Net Data provider written 100% in C# which allows .net programs to talk to postgresql backends. Npgsql is licensed under BSD. More info can be obtained from http://www.npgsql.org After almost two years of development since Npgsql 1.0, Npgsql 2 brings new features and support for newer versions of .Net. Although externally Npgsql2 doesn't seem very different of Npgsql1 regarding features, internally Npgsql2 had a lot of improvements which represents a much more stable product, more bugs fixed and many implemented methods. It is strongly advised that current users update from Npgsql1 to Npgsql2. Main features are: Support for .Net 2.0 and 3.5 Josh Cooley did a great job and added support for EntityFramework. Npgsql2 now doesn't read all table contents before returning control to user code. This makes Npgsql much more memory efficient when dealing with large tables. Thanks Jon Hanna for this. Check User Manual for more info about that and how to revert to old behavior of loading all data if you need it. Thanks to Daniel Nauck, Npgsql now have support for ASP.Net providers. You can visit Daniel project page at: http://dev.nauck-it.de/aspsqlprovider/ You can see full changelog and release notes here: http://pgfoundry.org/frs/shownotes.php?release_id=1230 You can dowload it from here: http://downloads.npgsql.org For instructions about how to use NpgsqlFactory, check out our User Manual: http://manual.npgsql.org Please, give it a try and let us know if you have any problems. Check out our forums: http://forums.npgsql.org -- Regards, Francisco Figueiredo Jr. http://fxjr.blogspot.com http://www.npgsql.org ___ Mono-list maillist - Mono-list@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-list
Re: [Mono-list] Monodevelop for Mono 2.0 rc1?
On Fri, Sep 19, 2008 at 10:26 AM, Andrew Jorgensen <[EMAIL PROTECTED]> wrote: > We have not re-built Monodevelop 1.0 against 2.0 because we believe there is > no need. Now you're on OSX though. Marc Christensen is working on updating > the gtk-related dependencies on Mac and making a seperate installer for > Monodevelop on Mac. We removed MD from the Mac installer because it has > enough bugs on Mac to give people the wrong impression of Mono. We got > comments like "mono is not ready for primetime" when those comments should > have been "MD on mac is still in Alpha". > We cannot promise that the MD Mac installer will be ready when mono 2.0 > releases but it should come along not long after. > Hi, Andrew! Thanks for the feedback! I have been using Monodevelop on mac since 1.9.1 and it was going very well. I had occasionally some crashes but I wouldn't say it isn't so Alpha. It worked very well. :) Well, I'm looking forward the new installer for Mac. Thanks again. -- Regards, Francisco Figueiredo Jr. http://fxjr.blogspot.com http://www.npgsql.org ___ Mono-list maillist - Mono-list@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-list
Re: [Mono-list] Monodevelop for Mono 2.0 rc1?
On Fri, Sep 19, 2008 at 6:10 AM, Paul <[EMAIL PROTECTED]> wrote: > Hi, > Hi, Paul! >> Is there a monodevelop built for Mono 2.0 RC1 or do I have to compile >> it from source? > > You'll probably have to build from source. > Thanks! I will give it a try. -- Regards, Francisco Figueiredo Jr. http://fxjr.blogspot.com http://www.npgsql.org ___ Mono-list maillist - Mono-list@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-list
[Mono-list] Monodevelop for Mono 2.0 rc1?
Hi all! Is there a monodevelop built for Mono 2.0 RC1 or do I have to compile it from source? I'm using OSX. Thanks in advance. -- Regards, Francisco Figueiredo Jr. http://fxjr.blogspot.com http://www.npgsql.org ___ Mono-list maillist - Mono-list@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-list
[Mono-list] Npgsql2 RC2 Released!!
Hi, all!! The Npgsql Development Team is proud to announce the Npgsql2 RC2 release! Npgsql is a .Net Data provider written 100% in C# which allows .net programs to talk to postgresql backends. Npgsql is licensed under BSD. More info can be obtained from http://www.npgsql.org On the highlights, thanks to Josh Cooley, we have support for newer version of EntityFramework 3.5sp1 We fixed problems about networkstream seek not supported exceptions. Also, we fixed a lot of problems with connection pool. Mono version of Npgsql wasn't using connection pool at all. Now it uses it. So, if you have a a heavy Npgsql usage pattern, you will benefit from this fix. You can see full changelog and release notes here: http://pgfoundry.org/frs/shownotes.php?release_id=1217 You can dowload it from here: http://downloads.npgsql.org I'd like to thank Josh Cooley for all his help and support. Thank you to all who helped us with this release with feedback, bug fixes, bug reports and comments. We couldn't make it without your help. Thank you very much! Please, give it a try and let us know if you have any problems. Check out our forums: http://forums.npgsql.org -- Regards, Francisco Figueiredo Jr. http://fxjr.blogspot.com http://www.npgsql.org ___ Mono-list maillist - Mono-list@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-list
Re: [Mono-list] Npgsql bug? Timeout while getting a connection from pool
On Thu, Aug 14, 2008 at 3:24 PM, matthieu Barthélemy <[EMAIL PROTECTED]> wrote: > Hi all, > Hi, Matthieu! > I just installed the 2.0-preview of mono, with all packages, from the > Opensuse 10.3 repository. > > My app opens several (between 4 and 8 for now ) connections, each one > in a different thread. Everything works fine during 3-4min, and then > it raises this exception : Can you check if you are closing all your connections after using it? You can see if you are leaking some connection by enable logging of Npgsql and look for connection leaking messages. The first explanation which comes to my mind regarding why you may be having this problem now is that gargabe collection on Mono may have changed from 1.9 to 2.0. Npgsql has code to fix connection leaking but only when the connection is gargabe collected. If the runtime takes more time to collect, your pool may exhaust first. Also, what Npgsql version are you using? I would recomend to use the Npgsql from downloads.npgsql.org as the version which comes bundled with Mono is the Npgsql1 version. We are working to get the Npgsql2 boundled with the final Mono release. I hope it helps. -- Regards, Francisco Figueiredo Jr. http://fxjr.blogspot.com http://www.npgsql.org ___ Mono-list maillist - Mono-list@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-list
Re: [Mono-list] Npgsql bug? Timeout while getting a connection from pool
On Thu, Aug 14, 2008 at 3:24 PM, matthieu Barthélemy <[EMAIL PROTECTED]> wrote: > Hi all, > Hi, Matthieu! > I just installed the 2.0-preview of mono, with all packages, from the > Opensuse 10.3 repository. > > My app opens several (between 4 and 8 for now ) connections, each one > in a different thread. Everything works fine during 3-4min, and then > it raises this exception : Can you check if you are closing all your connections after using it? You can see if you are leaking some connection by enable logging of Npgsql and look for connection leaking messages. The first explanation which comes to my mind regarding why you may be having this problem now is that gargabe collection on Mono may have changed from 1.9 to 2.0. Npgsql has code to fix connection leaking but only when the connection is gargabe collected. If the runtime takes more time to collect, your pool may exhaust first. Also, what Npgsql version are you using? I would recomend to use the Npgsql from downloads.npgsql.org as the version which comes bundled with Mono is the Npgsql1 version. We are working to get the Npgsql2 boundled with the final Mono release. I hope it helps. -- Regards, Francisco Figueiredo Jr. http://fxjr.blogspot.com http://www.npgsql.org ___ Mono-list maillist - Mono-list@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-list
[Mono-list] [ANN] Npgsql2 RC1 Released!!
Hi, all!! The Npgsql Development Team is proud to announce the Npgsql2 RC1 release! Npgsql is a .Net Data provider written 100% in C# which allows .net programs to talk to postgresql backends. Npgsql is licensed under BSD. More info can be obtained from http://www.npgsql.org On the highlights, thanks to Josh Cooley, we have support for newer version of EntityFramework 3.5sp1beta. Another highlight is that we fixed the cast problem some people had when using Npgsql2 beta4. Now, Npgsql will only use casts if the user explicitly specify a DbType or NpgsqlDbType value. Also, thanks Andreas Schönebeck, who provided us with testcases and feedback, we have a much better threadabortexception handling. Those exceptions were making Npgsql be instable and sometimes unusable. On this release, Daniel Nauck packaged another build of his ASP.Net provider (1.1.8). You can also download it from our downloads page. More information about it can be found on Daniel Nauck's AspSQLProvider project page: http://dev.nauck-it.de/aspsqlprovider/ Thank you, Daniel You can see full changelog and release notes here: http://pgfoundry.org/frs/shownotes.php?release_id=1197 You can dowload it from here: http://downloads.npgsql.org I'd like to thank Josh Cooley for all his help and support. Thank you to all who helped us with this release with feedback, bug fixes, bug reports and comments. We couldn't make it without your help. Thank you very much! Please, give it a try and let us know if you have any problems. Check out our forums: http://forums.npgsql.org -- Regards, Francisco Figueiredo Jr. http://fxjr.blogspot.com http://www.npgsql.org ___ Mono-list maillist - Mono-list@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-list
Re: [Mono-list] i dont have the mono.security.dll, how can i get.
2008/6/9 arre99 <[EMAIL PROTECTED]>: > > Sorry, and hi. > Hi! > im using npgsql and c#, for connect by postgressql. i have this error: > > "No se puede cargar el archivo o ensamblado No se puede cargar el archivo o > ensamblado 'Mono.Security, Version=1.0.5000.0, Culture=neutral, > PublicKeyToken=0738eb9f132ed756' ni una de sus dependencias. El sistema no > puede hallar el archivo especificado., Version=1.0.5000.0, Culture=neutral, > PublicKeyToken=0738eb9f132ed756' ni una de sus dependencias. El sistema no > puede hallar el archivo especificado." > > now i can find where download the Mono.Security.dll, its not comming with > npgsql. > Mono.Security.dll is available in Mono framework itself. That's why in the Npgsql compiled with Mono you don't have it attached. What Mono version are you using? From the assembly version it is requesting it seems to be Mono 1.1 profile. And what Npgsql version? Thanks in advance. -- Regards, Francisco Figueiredo Jr. http://fxjr.blogspot.com http://www.npgsql.org ___ Mono-list maillist - Mono-list@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-list
Re: [Mono-list] Mono process hangs on exit
On Wed, May 7, 2008 at 7:21 AM, Dick Porter <[EMAIL PROTECTED]> wrote: > On Wed, 2008-05-07 at 00:24 -0300, Francisco Figueiredo Jr. wrote: >> Hi, all! >> >> I'm facing an interesting problem... >> >> My mono processes seem to be not finishing correctly. They hang when >> they were supposed to finish. >> >> If I execute nant it hangs in the end instead of returning to bash. >> >> Do you have anything like that? >> >> Is there something I can do to check what could be happening? >> >> I'm using Ubuntu Hardy 8.04 with mono 1.2.6 > > This sounds like https://bugzilla.novell.com/show_bug.cgi?id=322163 > (especially the ubuntu with mono 1.2.6 part matching the later > comments.) If you could add to that bug we will have more data to work > with. > Thanks Dick, for pointer. I'm having problems with my account right now but this is the information I could gather: This is the backtrace: Thread 3 (Thread 0xb769db90 (LWP 21365)): #0 0xb7fda410 in __kernel_vsyscall () #1 0x4cce6aa5 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/tls/i686/cmov/libpthread.so.0 #2 0x081088ff in ?? () #3 0xb7b971dc in ?? () #4 0xb7b971c4 in ?? () #5 0x4cceb14f in pthread_getaffinity_np@@GLIBC_2.3.4 () from /lib/tls/i686/cmov/libpthread.so.0 #6 0x0810b3cd in ?? () #7 0x in ?? () Thread 2 (Thread 0xb7c25b90 (LWP 21364)): #0 0xb7fda410 in __kernel_vsyscall () #1 0x4ccea196 in nanosleep () from /lib/tls/i686/cmov/libpthread.so.0 #2 0x08105c91 in ?? () #3 0xb7c25344 in ?? () #4 0x in ?? () Thread 1 (Thread 0xb7fc6940 (LWP 21361)): #0 0xb7fda410 in __kernel_vsyscall () #1 0x4cce7ae7 in pthread_kill () from /lib/tls/i686/cmov/libpthread.so.0 ---Type to continue, or q to quit--- #2 0x08131f92 in ?? () #3 0xb769db90 in ?? () #4 0x001e in ?? () #5 0x0001 in ?? () #6 0x081255d0 in ?? () #7 0x in ?? () #0 0xb7fda410 in __kernel_vsyscall () My machine is a pentium4m with HT, but I disabled HT. I will try to reenable it again to see if I face this problem too. This stacktrace is from a nant execution. I can reproduce it all time. Interesting enough is that if I just run gmcs, which also uses mono, it exists ok. Only when I execute any other program it hangs. I hope it helps. -- Regards, Francisco Figueiredo Jr. http://fxjr.blogspot.com http://www.npgsql.org ___ Mono-list maillist - Mono-list@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-list
[Mono-list] Mono process hangs on exit
Hi, all! I'm facing an interesting problem... My mono processes seem to be not finishing correctly. They hang when they were supposed to finish. If I execute nant it hangs in the end instead of returning to bash. Do you have anything like that? Is there something I can do to check what could be happening? I'm using Ubuntu Hardy 8.04 with mono 1.2.6 Thanks in advance. -- Regards, Francisco Figueiredo Jr. http://fxjr.blogspot.com http://www.npgsql.org ___ Mono-list maillist - Mono-list@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-list
Re: [Mono-list] Creating Silverlight/Moonlight application
On Wed, Apr 30, 2008 at 4:29 PM, Andrus Moor <[EMAIL PROTECTED]> wrote: > > > I'm interested how to setup access to server data using Mono and npgsql. > Should I setup Web Service or WCF to get the data over to the client > application ? > Hi, Andrus!! If you have any problems with Npgsql in your setup, please, let us know. I read both Mono and Npgsql mail lists and Npgsql forums. -- Regards, Francisco Figueiredo Jr. http://fxjr.blogspot.com http://www.npgsql.org ___ Mono-list maillist - Mono-list@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-list
[Mono-list] [ANN] Npgsql2 Beta3 Released!! - Correction
Hi, all!! The Npgsql Development Team is proud to announce the Npgsql2 Beta3 release! Npgsql is a .Net Data provider written 100% in C# which allows .net programs to talk to postgresql backends. Npgsql is licensed under BSD. More info can be obtained from http://www.npgsql.org This release is one of the better done for Npgsql ever. One of the big highlights of it is the great job on scalability done by Jon Hanna. Npgsql, by default, doesn't cache all the data read from database before delivering it to clients. Now it is delivered on demand which gives a big benefit regarding used memory and consequently in scalability as application servers will be able to use the memory which was being used by Npgsql in past. You can see some details here: http://npgsql.projects.postgresql.org/docs/manual/preloadScalabilty.html Another highlight is the release of a version with support for Entity Framework beta3. (http://en.wikipedia.org/wiki/ADO.NET_Entity_Framework and http://msdn2.microsoft.com/en-us/library/aa697427(VS.80).aspx) Thanks Josh Cooley for this! This support is available on .net 3.5 and is our first release with this type of support. Please, give it a try and let us know what you get. You can see full changelog and release notes here: http://pgfoundry.org/frs/shownotes.php?release_id=1124 You can dowload it from here: http://downloads.npgsql.org Direct links: http://pgfoundry.org/frs/download.php/1733/Npgsql2.0beta3-bin-mono2.0.tar.bz2 http://pgfoundry.org/frs/download.php/1730/Npgsql2.0beta3-bin-EntityFrameworkBeta3.zip http://pgfoundry.org/frs/download.php/1729/Npgsql2.0beta3-bin-ms.net2.0.zip http://pgfoundry.org/frs/download.php/1732/Npgsql2.0beta3-src.zip I'd like to thank God for allowing me to do that. I'd like to thank Josh Cooley for all his help. Jon Hanna for his great job adding on demand data fetching, Alaric Dailey, David Bachmann and Hiroshi Saito for all their feedback and patches and all users who sent bug reports, comments and fixes. We couldn't make it without your help. Thank you very much! Please, give it a try and let us know if you have any problems. Check out our forums: http://forums.npgsql.org -- Regards, Francisco Figueiredo Jr. fxjr.blogspot.com www.npgsql.org ___ Mono-list maillist - Mono-list@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-list
[Mono-list] Npgsql2 Beta3 Released!
Hi, all!! The Npgsql Development Team is proud to announce the Npgsql2 Beta3 release! Npgsql is a .Net Data provider written 100% in C# which allows .net programs to talk to postgresql backends. Npgsql is licensed under BSD. More info can be obtained from http://www.npgsql.org This release is one of the better done for Npgsql ever. One of the big highlights of it is the great job on scalability done by Jon Hanna. Npgsql, by default, doesn't cache all the data read from database before delivering it to clients. Now it is delivered on demand which gives a big benefit regarding used memory and consequently in scalability as application servers will be able to use the memory which was being used by Npgsql in past. You can see some details here: http://npgsql.projects.postgresql.org/docs/manual/preloadScalabilty.html You can see full changelog and release notes here: http://pgfoundry.org/frs/shownotes.php?release_id=1124 You can dowload it from here: http://downloads.npgsql.org Direct links: http://pgfoundry.org/frs/download.php/1733/Npgsql2.0beta3-bin-mono2.0.tar.bz2 http://pgfoundry.org/frs/download.php/1730/Npgsql2.0beta3-bin-EntityFrameworkBeta3.zip http://pgfoundry.org/frs/download.php/1729/Npgsql2.0beta3-bin-ms.net2.0.zip http://pgfoundry.org/frs/download.php/1732/Npgsql2.0beta3-src.zip I'd like to thank God for allowing me to do that. I'd like to thank Josh Cooley for all his help. Jon Hanna for his great job adding on demand data fetching, Alaric Dailey, David Bachmann and Hiroshi Saito for all their feedback and patches and all users who sent bug reports, comments and fixes. We couldn't make it without your help. Thank you very much! Please, give it a try and let us know if you have any problems. Check out our forums: http://forums.npgsql.org -- Regards, Francisco Figueiredo Jr. fxjr.blogspot.com www.npgsql.org ___ Mono-list maillist - Mono-list@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-list
Re: [Mono-list] Npsql parameter with leading '?'
On Thu, Apr 3, 2008 at 6:55 AM, Manuel de la Pena <[EMAIL PROTECTED]> wrote: > Hi Francisco, > Hi, Manuel! > > The fact of having to use '@ or ':' does not really bother me and I have > already changed the parameter names in my code. I have added the feature > request since it will make it easier to port code that was using Oracle to > use PostgreSQL although I understand it is not an important one. > Great!! Thanks for your feedback! We will work on this feature request. > Thanks for the quick replay, > You are welcome! -- Regards, Francisco Figueiredo Jr. fxjr.blogspot.com www.npgsql.org ___ Mono-list maillist - Mono-list@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-list
Re: [Mono-list] Npsql parameter with leading '?'
On Wed, Apr 2, 2008 at 8:05 PM, Manuel de la Pena <[EMAIL PROTECTED]> wrote: > Hi guys, > Hi, Manuel! > I have been doing some work with IDataParameters and IDbCommands using > the Npsql ADO connector. I've noticed that the Npsql adds a ':' infront > of my parameters name which I have named as '?' + 'parameter_name'. > Yes. Npgsql had a bug which is already fixed where it prefixed parameter name. > I have used the '?' as it is done with the OracleClient, is this the > correct behaviour/approach? > > I have checked the code and Npsql does accept '@' and ':' as the leading > chars of the named parameters. Should '?' also be accepted? I'm sure I > am not the only one that has made this error. > Npgsql only accepts @ and : as prefix for parameter placeholders. There is no work done to support ? as parameter placeholders. Is this a big issue for you? I think we can add support for this type of commandtext. At first Npgsql only supported : prefix. Later we added @ support because it would easy people migrating from SQLServer. Now, if it would easy migration from Oracle, of course we have to do something about it! :) Manuel, can you fill a feature request on our project tracker? http://pgfoundry.org/tracker/?group_id=1000140 Thanks in advance. > > > Cheers for you great work, > And thank you for your interest in Npgsql! -- Regards, Francisco Figueiredo Jr. fxjr.blogspot.com www.npgsql.org ___ Mono-list maillist - Mono-list@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-list
Re: [Mono-list] Difference in generic IList from .NET
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
A S wrote:
| I'm new to mono, and trying to get my existing .NET application to
run. I'm having a problem with a difference in the behavior of generic
lists. Please can someone help me out? Am I being stupid? Or should I
raise a bug?
|
| In Mono, if a writable list is accessed as an IList, it appears to be
treated as readonly. Here is a minimal program that works fine under .NET:
|
| using System;
| using System.Collections.Generic;
|
| namespace MonoTest
| {
| class Program
| {
| static void Main(string[] args)
| {
| IList lList = new int[2];
| lList[0] = 1;
| }
| }
| }
|
Hi, Adam!
What mono version are you using?
I'm using mono 1.2.6 and your program doesn't throw any exception.
Maybe you are using some previous Mono version which had this bug and it
was already fixed in 1.2.6
I hope it helps.
Regards,
Francisco Figueiredo Jr.
http://fxjr.blogspot.com
Npgsql Lead Developer
http://pgfoundry.org/projects/npgsql
Mono Project Contributor
http://www.go-mono.com
MonoBrasil Project Founder Member
http://monobrasil.softwarelivre.org
- --
~ - Would you tell me, please, which way I ought to go from here?
~ - That depends a good deal on where you want to get to.
~ -- Lewis Carroll "Alice's Adventures in Wonderland"
-BEGIN PGP SIGNATURE-
Version: GnuPG v2.0.7 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iQEVAwUBR4+pdf7iFmsNzeXfAQIkwQf/XxcbH7DjeykLTzPBrBppaLIxryODtVxB
0B1EVYOu8zxt1jaZbyjM0rirPDUWB+eZCDxm3qzuhCSCVnq7VSmrnU0FOU92um3e
UT0p1gPv3keqx/yHRDnQ74CO86hdflDwdoGg5tl0Vc/icB7hgYzq/AbmQSEGWDcu
GBCAugJNJfd8woSdSqKZipqokh59FhMXRNu+L+hnebs31/CGKQH9CY7Q/dFLBfCl
WXMPucRzizU5gfApauEhtzhcXi2Ja30Rbqyp+qQClqVZFgXEWSsylQsMX27KYJKX
0gzFTMANAhWpfMc33ccTjZzIfJ6JK+Bubfy8Jx5rissEdz4mtpDwSA==
=lDP0
-END PGP SIGNATURE-
___
Mono-list maillist - Mono-list@lists.ximian.com
http://lists.ximian.com/mailman/listinfo/mono-list
Re: [Mono-list] Announce: Nemo 0.1
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Anders Rune Jensen wrote: > On Nov 29, 2007 3:39 PM, Francisco Figueiredo Jr. > <[EMAIL PROTECTED]> wrote: >> Hi, Anders! > > Hi Francisco > Hi Anders! > > What filetypes are your existing files? Nemo should show all the > normal file types: pdf, doc, txt, images, zip etc. Also note that you > can change what filetypes Nemo will index in ~/.nemo/configuration.xml > if you have special file types that you want included in Nemo. > > On the first indexing run, Nemo should show you "inserting: > " in the console whenever it insert a file into the > database. Does that appear for your files? You can force it to reindex > using the --reindex switch. You can check the database also, it's an > sqlite3 database stored in ~/.nemo/. > I resintalled tracker and remove .nemo folder. Now it is indexing ok. Just noted the following: PDF files are being previewed correctly, but my .txt files aren't :( Although they appear in search result. I receive a lot of encoding problems, see MONO_EXTERNAL_ENCODING or something like that. nemo seems to have some paths hardcoded to /usr/share, like the no preview image. I'd like to use another prefix when installing it and if the file isn't find, nemo crashes with a filenotfoundexception. I'm liking very much nemo. I started to really use it today. As I get any other feedback, I will let you know. Thanks for this program!! :) Regards, Francisco Figueiredo Jr. http://fxjr.blogspot.com Npgsql Lead Developer http://pgfoundry.org/projects/npgsql Mono Project Contributor http://www.go-mono.com MonoBrasil Project Founder Member http://monobrasil.softwarelivre.org - -- - Would you tell me, please, which way I ought to go from here? - That depends a good deal on where you want to get to. -- Lewis Carroll "Alice's Adventures in Wonderland" -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.7 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iQEVAwUBR1RKNP7iFmsNzeXfAQKIFwf6As5lHCpyV+HE5vmYg37NyzzcaAwC0RMx HaYgZD9RRFZQFHoAtq0xBOJlm1f+ZTliOZ43Q5Gf32HsOH1Kwhl91A1Cv+ecZ8Nr YO7eQP9X0jh9Z5sx+Ks9QDAhgL886T5R89Q/E8U2umppTH0HRBLj+jKELvc5MV+2 84iXvnfx1dAC1UIYNghweBLZ7wysfvqrkqIe8iJbq2nA3+4SSNa917TzPgVcnJCA kruUdKwmZPLOg/Mm7VNG1anKedQHilOxwXNgVKhA2XH8X2McJQ33aPDvNXEYta2E WIhaYquGUxOTzCYqAH9Sta1Toa7u57/UiSMU4o5KDBB1BzTlIsNs3A== =zvPa -END PGP SIGNATURE- ___ Mono-list maillist - Mono-list@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-list
Re: [Mono-list] Announce: Nemo 0.1
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Anders Rune Jensen wrote: > Hi > Hi, Anders! I installed Nemo and it seems very nice. But I noticed one thing... It index all my home files but it doesn't show them on month view not in any other view. If I create a file with nemo running it apperas correctly but none of the existing files appear :( Also, when doing searchs, I can see that it can make the search with tracker, tracker returns results but nemo doesn't show them. Is this a problem? Is there any way I can make nemo show my existing files? Thanks in advance. Regards, Francisco Figueiredo Jr. http://fxjr.blogspot.com Npgsql Lead Developer http://pgfoundry.org/projects/npgsql Mono Project Contributor http://www.go-mono.com MonoBrasil Project Founder Member http://monobrasil.softwarelivre.org - -- - Would you tell me, please, which way I ought to go from here? - That depends a good deal on where you want to get to. -- Lewis Carroll "Alice's Adventures in Wonderland" -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.7 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iQEVAwUBR07POv7iFmsNzeXfAQJ7BAf/WzJo4b/tMaSKaqO+oVA84Ecxg+7Lr+jF tRMKdymDVX92P/BybuwelkV41zSOfCDCS9lN6/i2rysr9BndPYdurFgOzMpd4v2R jr0ZaTDrH/RHhMMQT75S5B3aboC7vqxzmVBtp11bfwnKrNHYZ7ncrpPK+Nn4a30s Bi+GYIlu/Lbaq2O9FV9jKdhmqElFK6aWDWCHo7H7R58oakrTq4wuCkKkpWe75Ktj U06yA8JvbhV424djclx6sW7uhwsNO/WKz+86kVe4GRNlNqObDP870XK1ZDUjyftt bj0bBhcK3avjoCc5p4R8ouwHyLSX0814dQ4CMIf0Ha+q/BSDcumzQg== =F8N4 -END PGP SIGNATURE- ___ Mono-list maillist - Mono-list@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-list
[Mono-list] Npgsql2 beta1 released!!
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, all! Npgsql Development Team is proud to announce that Npgsql2 Beta1 is available! Its assembly version is 1.98.1, just in case you need to configure something with it using its assembly number. Npgsql is a .Net Data Provider which allows your programs using .Net runtime (mono or ms.net) to connect to postgresql server without any additional library. In this release, besides the usual bug fixes, we would like to highlight initial support for System.Transactions, COPY IN/OUT and uuid postgresql 8.3 datatype. Full release notes can be found here: http://pgfoundry.org/frs/shownotes.php?release_id=966 You can get it at the usual place: http://pgfoundry.org/frs/?group_id=1000140 There are binaris for Mono 2.0 and MS.net 2.0 I'd like to thank God for allowing me to make this happen. I'd like to help all who helped us contributing with feedback, bug fixes and comments which allowed us to improve Npgsql even more! Stay tuned for more features in upcoming releases. Keep your feedback and bug fixes coming! Regards, Francisco Figueiredo Jr. http://fxjr.blogspot.com Npgsql Lead Developer http://npgsql.projects.postgresql.org Mono Project Contributor http://www.go-mono.com MonoBrasil Project Founder Member http://monobrasil.softwarelivre.org - -- - Would you tell me, please, which way I ought to go from here? - That depends a good deal on where you want to get to. -- Lewis Carroll "Alice's Adventures in Wonderland" -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.7 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iQEVAwUBRzCyEf7iFmsNzeXfAQLyrwf+Kq9sdJ26U/etwjf97sWnZyObkvVuMvyV AeygB6iNO0Eeo3NBL5bgmjKx1rDFdmAX5v9LJU9J0VM8qqE+l5dsgqQHH5Yl9Vzm nzp4shjlMiCkkbsgJun4WQQ8af2jPX+dpHwvdeyABUmXyPOd8H1/SHQDJm84mz/f E6x39oDHE66ovjo3uORjTIqbJDyKgEGXZ9KqDrZuLtNbrHbPFy7LsAREIaFC6efI fCNcTlNEaK5mZf0MoFq2Eso0veU6HeTBbqCH5r2XXfCKCT9XKhP0wBv67XecxFvd bcNd2jNqjJLjJZnaMbkHC6RvCyFiPhTMopL+WfcCkZowrLvgJK5fmA== =5AIv -END PGP SIGNATURE- ___ Mono-list maillist - Mono-list@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-list
Re: [Mono-list] updating to 1.2.5.1
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Daniel Soto wrote: > Hi. > Hi, Daniel! > A tiny question. > > I compiled mono 1.2.5 from source, how can i to update to version > 1.2.5.1 <http://1.2.5.1>? simply compiling the new sources? Or i must to > delete (or make uninstall?) the previous? > I use the svn version and I simply update from svn, make and make install. I don't make uninstall so, I think it is ok to just grab the new sources and make install it to the same prefix you used before. I hope it helps. Regards, Francisco Figueiredo Jr. http://fxjr.blogspot.com Npgsql Lead Developer http://pgfoundry.org/projects/npgsql Mono Project Contributor http://www.go-mono.com MonoBrasil Project Founder Member http://monobrasil.softwarelivre.org - -- - Would you tell me, please, which way I ought to go from here? - That depends a good deal on where you want to get to. -- Lewis Carroll "Alice's Adventures in Wonderland" -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.7 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iQEVAwUBRve/k/7iFmsNzeXfAQKLgQgAo3VkfNA11fVJUyBPgazcDmWgmQqhfkNt DYgSBeW1mK1wAH8m+pfW0jEh9chfT/rJKDaNigaLTXuL52o4mhlGPYYYuV76ghZx uHYMpnVkgzx6cGiZbZTfqOzuZ6386TL4EH6yyOc4v983nUNEuQ5jfaC6tokFr2Ey wOU4JfGIy+YEuDvJHZLWPhJS9kaBJ3YzpcZ2LA+BcEuzX6JuIafABKGFOa2jFxpN 3wPtG1EvLBDp/vw4cecwV6dgcyNpjB10lhhlXXbXvgkonfMsh67QqCjAnAOxXnyy mzUFjfYg16sEBlTCl1Xy6yWRUsrfdd+QimmJua55pwFdXniAuuNXjA== =0i4P -END PGP SIGNATURE- ___ Mono-list maillist - Mono-list@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-list
[Mono-list] Npgsql License changed to BSD!!
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, all!! We finally moved from LGPL to BSD. Please, check this blog post for more info: http://fxjr.blogspot.com/2007/08/npgsql-license-changed-to-bsd_27.html We hope to have a much more updated Npgsql 2 with many new features. Thank you very much. Regards, Francisco Figueiredo Jr. http://fxjr.blogspot.com Npgsql Lead Developer http://pgfoundry.org/projects/npgsql Mono Project Contributor http://www.go-mono.com MonoBrasil Project Founder Member http://monobrasil.softwarelivre.org - -- - Would you tell me, please, which way I ought to go from here? - That depends a good deal on where you want to get to. -- Lewis Carroll "Alice's Adventures in Wonderland" -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.7 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iQEVAwUBRtO76v7iFmsNzeXfAQJfnAf9H9ct6v+apOVaFseYtXME4DRxyelz8ZD3 UVj9Xu7C760vZbTD5FhyA/5qRXujksH2x0YDEA45lFIURt4L6niJr+goqXH9lhrj 6RYdnoh8T/cijLOTUVPfPpFhMRVL3WFuqzrlxezAu0WhSj98HOAWy3aoswwjtWAo R+33dc6DZ4EU1pD8ygLR2FCuEvaYOdW1/cleF4qn3d7tT4SVNBg6uEPsCwg78aEG sNoUxUQqpTuMGVqwVLOs33LBL1oSaZAT8WCrG6vLCiMDqDYB2Ge0qS35NBW6fFDy zrprE/ae9i6nLjXzgevrNXjwoZ3CIbRqs7sNwCuWb4FzvB5Z/kURIg== =RCOr -END PGP SIGNATURE- ___ Mono-list maillist - Mono-list@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-list
[Mono-list] Npgsql2 Preview Release is available
Hi all! After so much time without updates, we released Npgsql2 Preview Update. This version uses the ado.net 2.0 apis and have asp.net providers support. It is a preview release only because there are many missing bits which will be added on future releases. Important Notice: As we are changing license to BSD it may be possible that future releases have some missing features which is present in this release. This is due to the fact we may not be able to get a permission to relicense the patch to new license. If this happens, we will let you know. We also will work hard to reimplement the missing parts. It is availabe in the usual place: http://pgfoundry.org/frs/?group_id=1000140 Please, give it a try and let us know what you think. Thanks all for you help. -- Regards, Francisco Figueiredo Jr. http://fxjr.blogspot.com Npgsql Lead Developer http://npgsql.projects.postgresql.org Mono Project Contributor http://www.go-mono.com MonoBrasil Project Founder Member http://monobrasil.softwarelivre.org - Would you tell me, please, which way I ought to go from here? - That depends a good deal on where you want to get to. -- Lewis Carroll "Alice's Adventures in Wonderland" Novo Yahoo! Cadê? - Experimente uma nova busca. http://yahoo.com.br/oqueeuganhocomisso ___ Mono-list maillist - Mono-list@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-list
[Mono-list] Res: npgsql ExecuteReader(CommandBehavior.SchemaOnly) not works with LIMIT
Hi Andrus! This is a know limitation of Npgsql. We still need to check if there is any user provided limit clause before adding our to implement SchemaOnly behavior. Is it possible for you to remove or schemaonly or the limit clause when calling executereader? -- Regards, Francisco Figueiredo Jr. http://fxjr.blogspot.com Npgsql Lead Developer http://npgsql.projects.postgresql.org MonoBrasil Project Founder Member http://monobrasil.softwarelivre.org "My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there." - Indira Gandhi __ Fale com seus amigos de graça com o novo Yahoo! Messenger http://br.messenger.yahoo.com/ ___ Mono-list maillist - Mono-list@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-list
Re: [Mono-list] System.InvalidCastException in Npgsql
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Daniel Morgan wrote: > >> I need to edit DataTable returned by Npgsql in grid. >> I'm studying GTK# and WinForms DataGrid for this. >> It would be nice if sqlsharpgtk allows edit tables >> in grid. >> I was looking for a sample GTK# code which allows to >> edit DataTable in grid >> but have'nt found any. >> So I think I will use WinForms. >> > > I can provide you with some sample code for an > editable gtk# TreeView/ListStore. > Hi Daniel! I would like to see this sample code. Would you mind if I put it on Npgsql project page as a sample? This would help new users to get used to Npgsql and gtk# at same time. :) - -- Regards, Francisco Figueiredo Jr. http://fxjr.blogspot.com Npgsql Lead Developer http://pgfoundry.org/projects/npgsql Mono Project Contributor http://www.go-mono.com MonoBrasil Project Founder Member http://monobrasil.softwarelivre.org - -- - Would you tell me, please, which way I ought to go from here? - That depends a good deal on where you want to get to. -- Lewis Carroll "Alice's Adventures in Wonderland" -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.4 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iQEVAwUBRTwfCf7iFmsNzeXfAQKzWwgAm/6RW0SvQy5dKS4G2QEwd25XLWpFvjmx PnmX9rQxTbeB7ZalDmRofM3AOvJKO/c4CQmBcufTouQel9LYJm1y+uRTVDeT1Vv+ IsXn1bhOjKa8XSwjkyCWe1aMI7nbxlIoaaiKaod6cOwF9DayGoFhBcoXRawdAlFP 1sO/BJLke/LbBy6/DprJMnz08ZhXihyrBFij9I7lRyHo7XrxBTeV76Lt87UWqv2F lmg1metoI7GR69w4kiDz6/PLltG9yCwoB+sldNJPv/w+ld1cpuz1+pWC+2/dAcli 4rT1YpWcrXLC2XQHt4IW9iF9Iz4e4CslzwiaVX5BrIfq+9osiSXsGQ== =tg1W -END PGP SIGNATURE- ___ Novidade no Yahoo! Mail: receba alertas de novas mensagens no seu celular. Registre seu aparelho agora! http://br.mobile.yahoo.com/mailalertas/ ___ Mono-list maillist - Mono-list@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-list
[Mono-list] Npgsql svn updated
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi all! I just updated Npgsql 1.0 to svn. Revision: 66825 Please, give it a try and let me know if you got any problems. Thanks for your patience. - -- Regards, Francisco Figueiredo Jr. http://fxjr.blogspot.com Npgsql Lead Developer http://pgfoundry.org/projects/npgsql Mono Project Contributor http://www.go-mono.com MonoBrasil Project Founder Member http://monobrasil.softwarelivre.org - -- - Would you tell me, please, which way I ought to go from here? - That depends a good deal on where you want to get to. -- Lewis Carroll "Alice's Adventures in Wonderland" -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.4 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iQEVAwUBRThU3v7iFmsNzeXfAQIClAf/eDf7jFWixmabGMBvGtp8u74UII8XSalI 6y13KDqzcFQ7AKPYaiu1VM0BkptiHAd8yo938uroWzoeIL+jG02ohgS9SSSqoCDe 5DzNnVR2zoxgphyfTbox4M+oHSsnJA+N7DSC7VW4P2MVkuQU6bOSzxAKcjwIYI9Q oTMKjWoo4WJSLcBwl780QL/3sYLBjfg0JQXKuemwUUpuafxEVmYtOkA8K71oWamy kAYGkjF+17iYGs7uSqS/lAKNfKIYiLdke+UPlu4/0Exhy5N761pNX4h7rDkJa0rE 4Hh3lGWPZA67V3WKE4f7tk3weBfp3lZ3eOaaAnc2848cimKezLoTKg== =N6Tx -END PGP SIGNATURE- ___ Você quer respostas para suas perguntas? Ou você sabe muito e quer compartilhar seu conhecimento? Experimente o Yahoo! Respostas ! http://br.answers.yahoo.com/ ___ Mono-list maillist - Mono-list@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-list
[Mono-list] Npgsql 1.0 Released!!
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi all, I'd like to say that Npgsql Development Team has released version 1.0 of Npgsql. Npgsql is a .Net Provider for Postgresql 7.x and 8.x. It allows your .Net programs access a Postgresql backend. More info about it can be found at: http://www.mono-project.com/PostgreSQL and http://npgsql.projects.postgresql.org Release notes: http://pgfoundry.org/frs/shownotes.php?release_id=662 This version marks an end of a cycle and the beginning of another: add support for .net 2.0 and ado.net 2.0 to Npgsql. This work will be done using current Npgsql 1.0 code base. This way we expect to have a working ado.net 2.0 enabled build really soon. We also have a lot of optimizations we want to do to make Npgsql much faster and much more feature complete. Stay tuned! Special Thanks: * God, for allowing this to happen. * All users and developers who give feedback and comments about Npgsql. Without your help this won't be possible. Please, give it a try and let me know of any problems you get. Download Page: http://pgfoundry.org/frs/?group_id=1000140 Thank you very much, guys! You are great!! P.S.: Sorry for sending this message so late. I was having problems with my Internet connection. P.P.S: Note: Mono svn will be updated soon. - -- Regards, Francisco Figueiredo Jr. http://fxjr.blogspot.com Npgsql Lead Developer http://npgsql.projects.postgresql.org Mono Project Contributor http://www.go-mono.com MonoBrasil Project Founder Member http://monobrasil.softwarelivre.org - -- - Would you tell me, please, which way I ought to go from here? - That depends a good deal on where you want to get to. -- Lewis Carroll "Alice's Adventures in Wonderland" -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.4 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iQEVAwUBRTTbmf7iFmsNzeXfAQIjQQf9E8c86Ke+YfFLdM0D8v2Gcb9m4N29vHs/ ZTLZu+04ZBpjQuOBMKuNWeJnHswudbrxHbhmUEaGkz7zUjXtuYkm8Yj4cldB4cax Cy4hM8bF5K0ErG0R7BCMnjzaC5e/DVZspqLn7oYLOtni8+jm0i8KNIZleOy3Ptjp 3fdeTnvO8p6HFfJpjV4QE17DaGPD0gqcZ7WiK9s36Zua1T/nbBD4puLL7jpS9aQn Ih4YMoMm396AfGlVVVxt7NtGFnm/sQ4fviraRKPJTtJKm/iBINkHEa8WhO/OtOJa /HNj00NVHYwmqN8omf0PyOVihHJkoACPGAXMVY2xIkYezTqDviniOg== =B84q -END PGP SIGNATURE- ___ Novidade no Yahoo! Mail: receba alertas de novas mensagens no seu celular. Registre seu aparelho agora! http://br.mobile.yahoo.com/mailalertas/ ___ Mono-list maillist - Mono-list@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-list
[Mono-list] NetworkStream.ReadByte behavior is differing from ms.net
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi all, While playing with NetworkStream.ReadByte in Npgsql I faced a situation where Mono behavior is differing from ms.net. If I establish a connection and later stop server while client is connected and call NetworkStream.ReadByte() from client, ms.net throws a SocketException wrapped inside an IOException, while Mono returns -1. This is ms.net stack trace: Unhandled Exception: System.IO.IOException: Unable to read data from the transp rt connection. ---> System.Net.Sockets.SocketException: Uma conexão estabelecid foi anulada pelo software no computador host at System.Net.Sockets.Socket.Receive(Byte[] buffer, Int32 offset, Int32 size SocketFlags socketFlags) at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 ize) --- End of inner exception stack trace --- at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 ize) at System.IO.BufferedStream.ReadByte() at Npgsql.NpgsqlState.ProcessBackendResponses_Ver_3(NpgsqlConnector context) at Npgsql.NpgsqlState.ProcessBackendResponses(NpgsqlConnector context) at Npgsql.NpgsqlReadyState.Query(NpgsqlConnector context, NpgsqlCommand comm nd) at Npgsql.NpgsqlConnector.Query(NpgsqlCommand queryCommand) at Npgsql.NpgsqlCommand.ExecuteCommand() at Npgsql.NpgsqlCommand.ExecuteScalar() at c.Main(String[] args) Checking mono source, it seems that it ends calling System.Net.Sockets.Socket.Receive(Byte[] buffer, Int32 offset, Int32 size SocketFlags socketFlags) too from NetworkStream.Read(). Socket.Receive ends up calling Receive_nochecks which seems is not realizing that the connection is broken and returns ok which makes Receive returns ok without throwing any SocketException. Can you confirm that? The closest bug I could find about that is this: http://bugzilla.ximian.com/show_bug.cgi?id=63233 But it talks about async calls which isn't my case. If you can confirm that, I can fill a bug report. Thanks in advance. - -- Regards, Francisco Figueiredo Jr. http://fxjr.blogspot.com Npgsql Lead Developer http://pgfoundry.org/projects/npgsql Mono Project Contributor http://www.go-mono.com MonoBrasil Project Founder Member http://monobrasil.softwarelivre.org - -- - Would you tell me, please, which way I ought to go from here? - That depends a good deal on where you want to get to. -- Lewis Carroll "Alice's Adventures in Wonderland" -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.4 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iQEVAwUBRP2FbP7iFmsNzeXfAQJGkQgAn/oknk5yYc1Wu8ES/SUo3bq5OTGKoliY m61V6NzCDxylVPiXcPUaFjfjisXMQuwr3KgCs5IigLAyyff/odOLbuTcQk0y6SqE xmMv85yPpW//ZEuAoLzVzg5cxyhGWSBCtdbVWGZKFcDbm5eTixHvIVO+x0KGx34c 8BniK6RNq0wnQTk9k2ytlvopfegmeDBVsnsbJa9dbD/hdwMbi1kCYcxQbWSZgHHv 313PanjLx26Pui1OY/DqjHT1hGvLt3wVbfdLvkb4usEa+JwEm+kU0JAE3jWU0QDF L5ECTwFWabZ0G3mtqd6gz3YQPENjSKaOsOfEpybFDtpjvWbrn1PEVA== =G7K0 -END PGP SIGNATURE- ___ O Yahoo! está de cara nova. Venha conferir! http://br.yahoo.com ___ Mono-list maillist - Mono-list@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-list
Re: [Mono-list] Proper data abstraction of Npgsql.NpgsqlCommandBuilder
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Andrus wrote:
> How to change the following code so that it works with data providers other
> than npgsql ? Npgsql.NpgsqlCommandBuilder does not implement any common
> interface.
> System.Data.ICommandBuilder builder; causes error.
>
NpgsqlCommandBuilder doesn't implement any interface.
You may need to create some adaptor which can use a custom common
interface. This way you would have adapters for each provider you want
to use.
>
> private System.Data.IDbDataAdapter DataAdapter1;
>
> private void button1_Click(object sender, EventArgs e)
> {
>
>
> Npgsql.NpgsqlCommandBuilder builder;
>
> builder = new Npgsql.NpgsqlCommandBuilder(this.DataAdapter1);
>
> this.DataAdapter1.InsertCommand =
> builder.GetInsertCommand(this.dataSet1.Tables[1].Rows[1]);
>
> }
Hmmm, while working with commandbuilder and dataadapter, you don't need
to specify manually the insert command. NpgsqlCommandBuider can do that
for you automatically.
I hope it helps.
- --
Regards,
Francisco Figueiredo Jr.
http://fxjr.blogspot.com
Npgsql Lead Developer
http://pgfoundry.org/projects/npgsql
Mono Project Contributor
http://www.go-mono.com
MonoBrasil Project Founder Member
http://monobrasil.softwarelivre.org
- --
- Would you tell me, please, which way I ought to go from here?
- That depends a good deal on where you want to get to.
-- Lewis Carroll "Alice's Adventures in Wonderland"
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.4 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iQEVAwUBRPtxzP7iFmsNzeXfAQLCrQgAnqvxsoImc26pgG0SXVkSMsXmk/Fb9RNa
xgegQl9LfuOSFQX+3pCv91DOYGY6M7gmKCyL2guvyOEkz+A8QIfYDGybSh0AEF9L
scsOunVlXUI6E9wA7zF/oItqEvZffAAAS1j7wLjcS8izhvX49FnaYVOIsQK2VnI4
6eUXT5M138Qmg0x3rfiPm9R4Mz/I2YNcLzd9cS49M/9y/V9krF5Pmy8SZud53fAG
KiUoQ2JO7mVGCb6EuY5EU3IRTeWpMX8q0y6SXD0WKlVwllPc7dfD91ss444huTC9
1GT2gj+zbv6VVf4y7jC1z2CWg6U8MR6Qr5UbhQrrjrot9ivNBvjn/w==
=ALgJ
-END PGP SIGNATURE-
___
Novidade no Yahoo! Mail: receba alertas de novas mensagens no seu celular.
Registre seu aparelho agora!
http://br.mobile.yahoo.com/mailalertas/
___
Mono-list maillist - Mono-list@lists.ximian.com
http://lists.ximian.com/mailman/listinfo/mono-list
Re: [Mono-list] Update command does not include schema
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Andrus wrote: > Update command generated in MONO for PostgeSQL does not include > schema name before table name. > > The following code running under MONO 1.1.16.1 in Windows returns > > update "mytable" set > > but when running under .NET it returns correctly schema also: > > update "myschema"."mytable" set ... > > > How to force mono to add schema name to update command ? > > Andrus. > Hi Andrus. What version of Npgsql are you using? It is possible that you may have downloaded a version for ms.net from Npgsql site which is different of the Mono version you have. Can you try with a version downloaded from Npgsql site? Or give it a try with a more recent Mono version? Thanks in advance. Francisco Figueiredo Jr. http://fxjr.blogspot.com Npgsql Lead Developer http://pgfoundry.org/projects/npgsql Mono Project Contributor http://www.go-mono.com MonoBrasil Project Founder Member http://monobrasil.softwarelivre.org - -- - Would you tell me, please, which way I ought to go from here? - That depends a good deal on where you want to get to. -- Lewis Carroll "Alice's Adventures in Wonderland" -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.4 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iQEVAwUBRPO3//7iFmsNzeXfAQLyiAf/cEojrYscD8/zCivwcS+weSPRQLIsFRpz unmJqpocB6k4Rfz/21E55NuTjT4XlblJyw/lCF9G6OMSlTybZRG2sV06cKReI1fL Pz3j5YbbTpOThIddLGRpcdw1EsuyMN/JXnJ1M15gPGJ3Rj55PyUm9tnutybZrnyP sAf1/vJlVK8hrLq4YKJh4ccbTdij1GGIDX1+0Epo6gE+CZyebUB2xLguzAFgB3Hv YAnDuN+EJTH6KpK8e+7qHe4zkqM3iVZklB2RVS2bXA4QpyrxAtDhJqHrT+/G3C40 9kPAd7E0VWaUq2c3ZGvObVYnqNjE9oIMVMCozx7CX5vWHnHJfGdV0Q== =YpOw -END PGP SIGNATURE- ___ O Yahoo! está de cara nova. Venha conferir! http://br.yahoo.com ___ Mono-list maillist - Mono-list@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-list
Re: [Mono-list] Npgsql and resgen.exe problems with net_2_0 profile compilation
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Raja R Harinath wrote: > Hi, > > > Bah! I should actually try it out before shooting off my mouth :-) > > A fix is in SVN r63980. > Hi Raja! Thank you! I will give it a try and let you know if I find any problems! Francisco Figueiredo Jr. http://fxjr.blogspot.com Npgsql Lead Developer http://pgfoundry.org/projects/npgsql Mono Project Contributor http://www.go-mono.com MonoBrasil Project Founder Member http://monobrasil.softwarelivre.org - -- - Would you tell me, please, which way I ought to go from here? - That depends a good deal on where you want to get to. -- Lewis Carroll "Alice's Adventures in Wonderland" -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.4 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iQEVAwUBROjdd/7iFmsNzeXfAQLauwf/fxympXTRKv9Fs9UxbTWtte94YjcMNbmE ny27CjiMLnclkImfY4Nc9gE1sJwRH9E6UGnBCTpnYTrmzy7z6N2igjETOCdK0YHx Yu/YLKHYuCejKTEpqDiCvZnyC3Xk0cM+CSaeqLwq2GpCWdXNFki1+867ONCOokru WQcX6gs5e58dkzxm123jLI6h1Y1M1STvjQYWCA/y2c37k7/q4UurFSruetqW2jLX +23UPKtY/0pHFWUjGKh8I3XJXO4Lo6dtuHFM+HuRrk6KKvLf2SjWF4saYrR8+HBU qR3xMzo7/ZebIX4BYuSQUmYm6xL1KFyNMaHdoQymshqZH4Xc9jjTLg== =4uKt -END PGP SIGNATURE- ___ O Yahoo! está de cara nova. Venha conferir! http://br.yahoo.com ___ Mono-list maillist - Mono-list@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-list
[Mono-list] [ANN] Npgsql 1.0RC3 Released!
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi all, I'd like to say that Npgsql version 1.0RC3 is out. Npgsql is a .Net Provider for Postgresql 7.x and 8.x. It allows your .Net programs access a Postgresql backend. More info about it can be found at: http://www.mono-project.com/PostgreSQL and http://pgfoundry.org/projects/npgsql Mono SVN updated: Revision 63849. Release notes: http://pgfoundry.org/frs/shownotes.php?release_id=618 Special Thanks: * God for allowing this to happen. * Josh Cooley who gave a big help fixing critical bugs for this release. * All users and developers who give feedback and comments about Npgsql. Please, give it a try and let me know of any problems you get. Download Page: http://pgfoundry.org/frs/?group_id=1000140 - -- Regards, Francisco Figueiredo Jr. http://fxjr.blogspot.com Npgsql Lead Developer http://pgfoundry.org/projects/npgsql Mono Project Contributor http://www.go-mono.com MonoBrasil Project Founder Member http://monobrasil.softwarelivre.org -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.4 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iQEVAwUBROOTDf7iFmsNzeXfAQJaRwf/RcTk7CcFSfTW9/UkkgOZT1FMx1Sncp6z WH4EIzclRATzrPrjwwsh3KFm7av6wBKx8nB3rRhI3FnSIUPrghWs+hGT5HO3OL44 XCzD5IpzXcfdXIPTdtaHbEJmq++Pmz+bjz1awJZVZdtmmeOaiRf6ajOnISuvD2nc fPRlJkHHyXd4pVU1JBnGjubn/vklZC1B++Q0QbuasmQzp2jLqCg5nvtizQ+TRoif vqcOkJIikOYU1aoPX4TDnwB3hXQGjyG7K0A0FiE2tEn1HBPuctywoj+6gYx2OwBk VFpo29RdkGBPTSObZZvsVJkIjDYOAfYzWTWy+S0yOrgRw6lB+XvJpg== =skCY -END PGP SIGNATURE- ___ O Yahoo! está de cara nova. Venha conferir! http://br.yahoo.com ___ Mono-list maillist - Mono-list@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-list
Re: [Mono-dev] Call for release notes comments.
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Miguel de Icaza wrote: > Hello folks, > > As usual, am calling for people to email me about new features that > are worth mentioning in the release notes for 1.1.17. > > The current -very early draft- is at: > > http://www.go-mono.com/archive/1.1.17 > Hi Miguel! Updated Npgsql to RC3. - -- Regards, Francisco Figueiredo Jr. http://fxjr.blogspot.com Npgsql Lead Developer http://pgfoundry.org/projects/npgsql MonoBrasil Project Founder Member http://monobrasil.softwarelivre.org - - "Science without religion is lame; religion without science is blind." ~ Albert Einstein -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.4 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iQEVAwUBROORcP7iFmsNzeXfAQL8rQf8CJY1q2tzK9weE0+Y5+87UZu7r9cxrtbE iQHQhybdPQTXBXRdvucF1PFkwotfJShE5IdyjFL8mTHrg2KTjCpN1oWU0NvISNqv pYdaF+2yW5fA1NHsvPbKAr2mCYZKd2WywRzH3v5rp8jrz4XitInlEa9gtb5TZpQL A9m/DZrXi+N2AdriSG/j5O26xdsboTmwA4UOFtl4kr2cu3VyrTwstyHyvgBvFb7h mw9SV16K5Fkxz2lJymVPw+iVZnsx2herDRsyhOUOHq54G2DT9bkd4YXTxqIKi3Gl 2oYjZxbwycDopk0rmJUj6A611dtBGOAlGKx+QRl/uO1A3yoU6wZwMg== =HOyP -END PGP SIGNATURE- ___ O Yahoo! está de cara nova. Venha conferir! http://br.yahoo.com ___ Mono-devel-list mailing list Mono-devel-list@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-devel-list
[Mono-list] Npgsql and resgen.exe problems with net_2_0 profile compilation
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi all, After getting a new snapshot from svn after reinstalling my system, I noticed that Makefile seems to be looking for resgen.exe inside net_2.0_bootstrap which seems to not being installed. I had to copy resgen.exe from net_2_0 to make it work. Is this expected? To reproduce it, just issue the following in mcs/Npgsql folder: make PROFILE=net_2_0 clean and make PROFILE=net_2_0 Note that if you make it with profile 1.1 first, this problem won't trigger because the resources will already be generated. Thanks in advance. - -- Regards, Francisco Figueiredo Jr. http://fxjr.blogspot.com Npgsql Lead Developer http://pgfoundry.org/projects/npgsql MonoBrasil Project Founder Member http://monobrasil.softwarelivre.org - - "Science without religion is lame; religion without science is blind." ~ Albert Einstein -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.4 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iQEVAwUBROOPbv7iFmsNzeXfAQKUBwf8DXB/C0ZGtLQs8g2sugnPXTM/oO00ImEV B2hfS5KnivVMGBh2lXHb2MC9K0E22mQx+jI+4Kuymaok/pJSsWqI06xM1fpr8g/9 RVdHp9vWX6MqM0a0wZ7W1S3cRgP/EfG/xUkDI3Lv/rZimthW9VX3W8NQBHXoQUEZ FPO8Z9+WdB0iNP6An46p/xCmMo3Q29JW7qOvXNF21E68JM80vtoCYutCbEPRQdza LSGyIG9e0Ij+FNxeFZd8EdQW2X4tFNRqKVkb4usw2Cms4TuLPK4LyjXVwalhaRwt 6BIi98JgCH4fvREwvnWsWwAtabNtY0XGKFmxTpKZnQQ2Ucfi9xRYUg== =P9h7 -END PGP SIGNATURE- ___ Você quer respostas para suas perguntas? Ou você sabe muito e quer compartilhar seu conhecimento? Experimente o Yahoo! Respostas ! http://br.answers.yahoo.com/ ___ Mono-list maillist - Mono-list@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-list
[Mono-list] Npgsql 1.0RC2 released!
Hi all, Npgsql Development Team is proud to announce NpgsqlRC2! What Npgsql? It is a .net data provider for Postgresql. It allows .net applications to access postgresql backends. More information can be found here: http://npgsql.projects.postgresql.org http://www.mono-project.com/PostgreSQL There were a lot of fixes and new features added. Please, check release notes for more information: http://pgfoundry.org/frs/shownotes.php?release_id=587 Downloads are available here: http://pgfoundry.org/frs/?group_id=1000140 Note that Mono 2.0 packages aren't available. This is because after my machine reinstall, I didn't install mono 2.0 yet. Sorry for that. I will provide packages for Mono 2.0 as soon as I finish compile Mono 2.0 on my machine. Also note that ms.net 2.0 version still doesn't have support for ado.net 2.0. It is only compiled with ms.net 2.0 framework. We are working on ado.net 2.0 support and hope to have it released soon. Mono repository also will be updated soon. I'd like to thank God for allowing me to do that. I'd like to thank Josh Cooley for all his effort and collaboration on this release. Thank you for all users who provided valuable feedback which allowed us to make Npgsql even better! Please give it a try and let us know of any problems you find. Francisco Figueiredo Jr. Npgsql Lead Developer -- Regards, Francisco Figueiredo Jr. http://fxjr.blogspot.com Npgsql Lead Developer http://npgsql.projects.postgresql.org MonoBrasil Project Founder Member http://monobrasil.softwarelivre.org "My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there." - Indira Gandhi ___ Você quer respostas para suas perguntas? Ou você sabe muito e quer compartilhar seu conhecimento? Experimente o Yahoo! Respostas ! http://br.answers.yahoo.com/ ___ Mono-list maillist - Mono-list@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-list
[Mono-list] Re: Npgsql updated to RC1
On Thursday 27 April 2006 11:27, Francisco Figueiredo Jr. wrote: > Hi all, > > I just updated Mono svn with Npgsql RC1. > > Svn revision: 59976 > > Please, let me know if you find any problems with it. > > Thanks in advance. Hi all, unfortunately I commited the wrong NpgsqlCommand.cs file :( It is now fixed at revision 59982. Sorry for any problem. -- Regards, Francisco Figueiredo Jr. http://fxjr.blogspot.com Npgsql Lead Developer - http://pgfoundry.org/projects/npgsql MonoBrasil Project Founder Member - http://monobrasil.softwarelivre.org pgpY6QXkJHDM4.pgp Description: PGP signature ___ Mono-list maillist - Mono-list@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-list
[Mono-list] Npgsql updated to RC1
Hi all, I just updated Mono svn with Npgsql RC1. Svn revision: 59976 Please, let me know if you find any problems with it. Thanks in advance. -- Regards, Francisco Figueiredo Jr. http://fxjr.blogspot.com Npgsql Lead Developer - http://pgfoundry.org/projects/npgsql MonoBrasil Project Founder Member - http://monobrasil.softwarelivre.org pgpTp8snOh5lc.pgp Description: PGP signature ___ Mono-list maillist - Mono-list@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-list
[Mono-list] Re: Socket.Poll only works after first read of data? [Solved]
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Francisco Figueiredo Jr. wrote: > > Hi all, > > I'm playing with Npgsql to implement CommandTimeout feature. > > My idea is to use Socket.Poll method in order to do that. > > After adding the infrastructure code to Npgsql, I faced an strange > problem, or maybe it is not strange, just my knowledge about it is :) > Ok. My fault, as always... After checking that another program I had written worked with Poll and seeing what was going on with ethereal, I found out that I forgot to flush the socket data. Doh! :) After that, Poll worked from the first data exchange as it would if I had done it right the first time. Btw, after checking Mono sources, Poll wasn't working but Read was, as I previously stated, because Mono code wisely flush any pending writes before doing read. Thanks Mono for doing the right thing! - -- Regards, Francisco Figueiredo Jr. http://fxjr.blogspot.com Npgsql Lead Developer http://pgfoundry.org/projects/npgsql MonoBrasil Project Founder Member http://monobrasil.softwarelivre.org - - "Science without religion is lame; religion without science is blind." ~ Albert Einstein -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.6 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iQEVAwUBRClRG/7iFmsNzeXfAQJYrwf+J78v7dYd2298Qwr0kOkRwpY8ag65hCHp YW90G1qF7rSwvgHah1R/MBwrbZA1ddoLuFCfh6QnR68a/svW0pXC0FlxBdV3D9QE 8HY/p90UUvnpWkzhgwpo669F1mVVd48xEOMi0yS0maHCZ4IXJ40UhEEb4dZoya5y 10Ccf4Ki3Qfyo5ooA64eyMAmDMp6fS7LWR0x0bmhKDSfBKyYBA+5aIMZfs0zGuwu 1Ni2mkh/HOJIoD5f3v0A/FcE8G3Kmy7kyItx2tpNwIrImOOQoAbzwQ2WCaXkvaRa 4OlULjYy2TI7Qvh6QWrA7Y1tqbnzkTU2nJJMJz1RMxEJ/5sUgconTA== =zxwn -END PGP SIGNATURE- ___ Yahoo! doce lar. Faça do Yahoo! sua homepage. http://br.yahoo.com/homepageset.html ___ Mono-list maillist - Mono-list@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-list
[Mono-list] Socket.Poll only works after first read of data?
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi all, I'm playing with Npgsql to implement CommandTimeout feature. My idea is to use Socket.Poll method in order to do that. After adding the infrastructure code to Npgsql, I faced an strange problem, or maybe it is not strange, just my knowledge about it is :) After I connect to a socket server, write some data and expect to receive data, if I call Socket.Poll, it doesn't return true :( I passed a timeout of 20 seconds: 100 * 20 with a SelectMode.Read If I call socket.Read it works. The strange part of all this is that after subsequent data exchange with server, Socket.Poll works like a charm and doesn't timeout anymore. Is this the way it should be working, or am I missing something? I tried to put some Thread.Sleep() before calling Poll just to be sure that it would not be a matter of the server is really taking to much time to write data, but even with that, it didn't work :( I know it is useless as on Poll call, I already add a 20 secs wait time. Any clues? Thanks in advance. - -- Regards, Francisco Figueiredo Jr. http://fxjr.blogspot.com Npgsql Lead Developer http://pgfoundry.org/projects/npgsql MonoBrasil Project Founder Member http://monobrasil.softwarelivre.org - - "Science without religion is lame; religion without science is blind." ~ Albert Einstein -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.6 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iQEVAwUBRClOGf7iFmsNzeXfAQKdZgf/UkZwEyzATO7gRdJjTuhHOAN4ONhqcqcZ lJ++s8NeEVSFpBpfZh3GcEABgfFjYd9Qo4Zfj56dawbyrVITYeQ5HRYQ+Hmtytbg DtD1MrKRSTq+lkK6Dc3KoJYpeS8N6PfXezN3k/BqrC7vRSTXYXtU266XaZx9ZmBJ jwGbPpCeoPGHyeGSpp60HmPCElOLKC14ONg0gqYWScsO+zhJkg8wzPzQJMMc3QqW NHHeo3pVQ6zQooHrLWyZelutZNJVppXTOYfN1otmgKq8aOcNHeB+8ncdKMthz0ku gFKIVH4zSNkrirR+uBIrYcgLnXz5s8JGrzLZBniL/OycTOJKvfZNGA== =m6io -END PGP SIGNATURE- ___ Novo Yahoo! Messenger com voz: Instale agora e faça ligações de graça. http://br.messenger.yahoo.com/ ___ Mono-list maillist - Mono-list@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-list
Re: [Mono-list] Special-Signs Problem
--- Helge Lenuweit <[EMAIL PROTECTED]> escreveu: > Hello Jan, > > it should help to provide the appropriate client-side encoding in the > connection string, like so: encoding=LATIN1;. For .NET, I found it > easiest to switch to encoding=UNICODE generally as .NET string data are > unicode characters anyway. > > Regards, > Helge > Hi Helge, Jan. Npgsql only supports two encodings: ASCII (default) and UNICODE. If your database is in any other encoding, like LATIN1, you should use encoding=UNICODE in your connection string. Postgresql server will do the conversion automagically for you. I'm thinking about changing the default to UNICODE in order to avoid this problem. We receive sometimes reports of problems like that. Sorry Jan. And thanks Helge for providing the correct answer for this. -- Regards, Francisco Figueiredo Jr. ___ Yahoo! doce lar. Faça do Yahoo! sua homepage. http://br.yahoo.com/homepageset.html ___ Mono-list maillist - Mono-list@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-list
[Mono-list] [ANN] Npgsql 1.0beta2 is out!
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi all, I'd like to say that Npgsql version 1.0beta2 is out. Note: Mono svn will be updated soon. Npgsql is a .Net Provider for Postgresql 7.x and 8.x. It allows your .Net programs access a Postgresql backend. More info about it can be found at: http://www.mono-project.com/PostgreSQL and http://pgfoundry.org/projects/npgsql Release notes: http://pgfoundry.org/frs/shownotes.php?release_id=407 Special Thanks: * Hubert Fongarnand and Bryan Mayland who sent a lot of optimizations to Npgsql. * All users and developers who give feedback and comments about Npgsql. * God for allowing this to happen. Please, give it a try and let me know of any problems you get. Download Page: http://pgfoundry.org/frs/?group_id=1000140 Thanks in advance. - - - -- Regards, Francisco Figueiredo Jr. Npgsql Lead Developer http://gborg.postgresql.org/project/npgsql MonoBrasil Project Founder Member http://monobrasil.softwarelivre.org - - - - "Science without religion is lame; religion without science is blind." ~ Albert Einstein -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.6 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iQEVAwUBRSxYMf7iFmsNzeXfAQJ4Kwf9FuofacPi0M4ujpE2FNq0SC6dshI491dQ bXf0Le19af2lQDo8gbgJCvRKoppwyrrjtpAWrz0Dlvo+2E4nasmPsLKJNCoVtape KfgAThpQPfUJg9uNkQ+HhPOEFEr4HnYK56KcoQuRtNIx9lSiJn3tWlEiDvAzgxoa vb11kFu9CH79hDVqrBmVAG+DDPyjMhGEWdCKi+h+ej4MKZe0BuzjerQ3wol/mbqZ zYEMAQ/yH+Lkkj+jr/tsQG1OpzX8yWZt2Spx3BL+REk70/6mr/V6GSz23BHBXpKm anHBexd+FVlDbUCJUCpU2hkru7TSXeERkf6vADCv4OeIUQgilnEpng== =0mvj -END PGP SIGNATURE- ___ Yahoo! doce lar. Faça do Yahoo! sua homepage. http://br.yahoo.com/homepageset.html ___ Mono-list maillist - Mono-list@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-list
Re: [Mono-list] Npgsql myCommand.ExecuteScalar type cast issue
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Joe Audette wrote: > Being close to christmas not everyone may be reading the mail but Francisco > is the developer of npgsql and I know he follows this list. > Hi Joe. That was exactly what happened :) Christopher, do you have a test case for your problem? To check what type is being returned, add the following: Console.WriteLine(command.ExecuteScalar().GetType()); What type in your database is the field which you are doing the executeScalar()? If you are using an select * from some table, Postgresql changed the type of the data returned from int4 to int8, which Npgsql translates to Int64. So, you may be receiving an Int64 and this explains why you may be not being able to directly cast it to int32. I hope it helps. - -- Regards, Francisco Figueiredo Jr. http://fxjr.blogspot.com Npgsql Lead Developer http://www.pgfoundry.org/projects/npgsql MonoBrasil Project Founder Member http://monobrasil.softwarelivre.org - - "Science without religion is lame; religion without science is blind." ~ Albert Einstein -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.6 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iQEVAwUBQ67QKf7iFmsNzeXfAQJgZwf9H43hq/tDk0F2H/BW44kCAF19ebvwOMMs 1fZICFP4yavhd1Lc5U2yrDEGuB5twZCrg+HLfQAeWFO21rCax9JSdgv4h2SM2KFx kSLzKcWFHeowyiSfgq5AQhoMf4jbyBOhA122cEI90ZcY8TM7NjxLviyjU9RihrTv AT/GOW3ShFrxnD8vJYSWyxvP4OxPcNPsLcHe2Ba9NcvpfCZRD21NJa1OuN1jcsg0 3AD4AW8bJig8Uh+YJHJGuD5A/aWTBvEVniWcsZ0OVtwqkSo/fyc45RNllqNb7vR/ VxpxiAUOHwxWUpGrttjoYd1phOH4ZzIycGIBrsgFoApU0/19d+07Gw== =T2nN -END PGP SIGNATURE- ___ Yahoo! doce lar. Fa�a do Yahoo! sua homepage. http://br.yahoo.com/homepageset.html ___ Mono-list maillist - Mono-list@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-list
[Mono-list] Npgsql updated in svn
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi all, I just updated Npgsql on mono svn. Revision 54161. Please, give it a try and let me know of any problems you may find. Thanks in advance. - -- Regards, Francisco Figueiredo Jr. Npgsql Lead Developer http://www.pgfoundry.org/projects/npgsql MonoBrasil Project Founder Member http://monobrasil.softwarelivre.org - - "Science without religion is lame; religion without science is blind." ~ Albert Einstein -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.6 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iQEVAwUBQ5mKx/7iFmsNzeXfAQJHAQf/aN5hk5WmlCny3Y37tQ65Ze15jfK/094/ HCdkq5cVE2qWwqJXKZSNrfQyq82sLsZFZ6XSYp7+eWUvErutmvwryaiC3jNn9R2I eNfBTs/UEJgqIb5rTd01TsCCvNcahTBk2Luq/4SsbIGCKUAZ2kCQgfJhPTN0cMzj 2sXEyLswJy9iRKpdBHXA3eYtDA9hNahdQi48uHWgTSIUWYzDo136kurC3fl86Fws DjUCu1Yu8kPEmmlBX8mLKhhih9L22MiY0sGVqr6iawp6q3ulxB/YrP7m6pvZWlF7 g/T2caVQXPTEA4APj5cyiAmBNMmGzqLhxiGP3CN64YDSZh18rMBliA== =SlIG -END PGP SIGNATURE- ___ Yahoo! doce lar. Faça do Yahoo! sua homepage. http://br.yahoo.com/homepageset.html ___ Mono-list maillist - Mono-list@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-list
Re: [Mono-list] nunit addin hosed my monodevelop session
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 kadil wrote: > Hi, > > I was messing arount with the addins added nunit, now monodevelop woll not > start. gets stuck loadinh the nunit addin. under a different login, it starts > just fine. any known way to get a vanilla config for my monodevelop? > I think you can try to remove the folder: ~/.config/MonoDevelop Note that this will remove all previous configurations of MonoDevelop for your user. I hope it helps. - -- Regards, Francisco Figueiredo Jr. Npgsql Lead Developer http://www.pgfoundry.org/projects/npgsql MonoBrasil Project Founder Member http://monobrasil.softwarelivre.org - - "Science without religion is lame; religion without science is blind." ~ Albert Einstein -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.6 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iQEVAwUBQ5mHq/7iFmsNzeXfAQKgnwf9GRLutgzO++84/81DQTigmOJDr2ClZ6gE 2yMqZveU49XfQXl4dOOZYW7v4WcD0HUg3DUPG/h4UVSK1Ze0X7f4AncbiLB0SspG O/B8nBsa9gFXYSi/Htp44aWQrmLEhd+2ArO7cjhx2W7sU3zE2iGZBzOtuZjWhPug mQFm36e3Fa3Cb3C803YjbzTXWnAldSuUEwfFPr+8Y+f6pW+Go036dmOWUB6cMt73 qRPAHhKTNXFuoIuqueOeclM/PoDJuKLb6afQn8n1Ba47Dohe8qz+hj4ZTh2SynBz 7aZas8ng3Wxv6nbg7z5H+3KdRd9CxEjg8s6YOVFI3PruxAMtgR9q1g== =io5H -END PGP SIGNATURE- ___ Yahoo! doce lar. Faça do Yahoo! sua homepage. http://br.yahoo.com/homepageset.html ___ Mono-list maillist - Mono-list@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-list
[Mono-list] [ANN] Npgsql 1.0beta1 is out!
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi all, I'd like to say that Npgsql version 1.0beta1 is out. Note: Mono svn will be updated soon. Npgsql is a .Net Provider for Postgresql 7.x and 8.x. It allows your .Net programs access a Postgresql backend. More info about it can be found at: http://www.mono-project.com/PostgreSQL and http://pgfoundry.org/projects/npgsql Please check full release notes here: http://pgfoundry.org/frs/shownotes.php?release_id=369 Special Thanks: * Josh Cooley for the hard work with metadata support. * All users and developers who give feedback and comments about Npgsql. * God for allowing this to happen. Please, give it a try and let me know of any problems you get. Download Page: http://pgfoundry.org/frs/?group_id=1000140 Thanks in advance. - - -- Regards, Francisco Figueiredo Jr. Npgsql Lead Developer http://gborg.postgresql.org/project/npgsql MonoBrasil Project Founder Member http://monobrasil.softwarelivre.org - - - "Science without religion is lame; religion without science is blind." ~ Albert Einstein -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.6 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iQEVAwUBQ5cuQP7iFmsNzeXfAQJpGgf/YpxgVKSfNeoZ6CLXcB72f2bK2NraB6Tw wxLpOfgPsr8vIapxWvu4bjLFbUNlpdIibWmOoifA/gOYSfXYU5OMP24z6YrQgKjH 2fLpuQmv/OzMjBZ8DR8pqAStQOt2c3jeuBFyzqDBpq5jVdi/hICPyUWgjOoKdkJY vSUYk0hGo/UMbLeNG75cWf5pthUeK3qA3TT5FLfkxl173UF1QrXVMwbQZ781DSIq uxOXCmEVHsFSbIF2CUxw+8d9uB5QPOooQjS6kOIrslXCdss7VNpf/NCDoKaL/0t7 3EC+demGlURvTXFiUavAbU9C10fb1afAdJ9PUGfJHva8WdMa0psjPA== =6LWC -END PGP SIGNATURE- ___ Yahoo! doce lar. Faça do Yahoo! sua homepage. http://br.yahoo.com/homepageset.html ___ Mono-list maillist - Mono-list@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-list
Re: [Mono-list] Problem with Npgsql
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Willngton Roque wrote: > I'm try using Mono with Npgsql and have this problem. > I'm try reboot my pc and de problem percist. > > Unhandled Exception: System.InvalidOperationException: DataReader > positioned beyond end of result set. > in <0x00092> Npgsql.NpgsqlDataReader:CheckHaveRow () > in <0x00058> Npgsql.NpgsqlDataReader:GetValue (Int32 Index) > in <0x00051> Npgsql.NpgsqlDataReader:get_Item (System.String name) > in <0x000aa> MonoSql:Main (System.String[] args) > > Help me? > Hi Willngon. Can you enable Npgsql log and send it to me? NpgsqlEventLog.Level = LogLevel.Debug; NpgsqlEventLog.LogName = "NpgsqlTests.LogFile"; Thanks in advance. - -- Regards, Francisco Figueiredo Jr. Npgsql Lead Developer http://gborg.postgresql.org/project/npgsql MonoBrasil Project Founder Member http://monobrasil.softwarelivre.org - - "Science without religion is lame; religion without science is blind." ~ Albert Einstein -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.6 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iQEVAwUBQzXch/7iFmsNzeXfAQLyQgf+ONqHu/eDOc4/n4HMiUXijezDCs3V05dm S0cwsUcYk/kipJLuEfuKdFSUOXtn2EKc3UVQWyydjG9QvZdJV3Q6hqqlZRcLAp6U kpUomdp1eI8+HDhkREkCJhdbwxr9Wm7/XUPhRU962VHYsC84fEbXVh6k+Wn3aieu eS3Lvahqua52OuOfIKpbog/dnlzEn7PiWqfoD9Y9LLM+ZCMTAlJ9WoksEzzIEAP3 tehKq0cJzfPfnlfi57/wMvVvb2N4LFMemLg9pHY3mNi/fEOegrk/lACb/nbh4pJ3 WPd6VOxFZT6/5gWCYtfqh8wXWq8iB3Jf5cTiqevZyJT2xzyX00OqBA== =sTPS -END PGP SIGNATURE- ___ Novo Yahoo! Messenger com voz: ligações, Yahoo! Avatars, novos emoticons e muito mais. Instale agora! www.yahoo.com.br/messenger/ ___ Mono-list maillist - Mono-list@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-list
[Mono-list] WebControls.DataGrid and DataReader problems
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi all,
I'm getting some problems when using WebControls.DataGrid and a
DataReader as datasource.
The problem seems to be with the enumerator getting past the size of
reader when reading values to fill a grid.
I received a report from Jan Waiz about getting exceptions when using an
NpgsqlDataReader when using a grid and a setting PageSize and
VirtualItemCount properties.
When using a dataset as datasource this problem doesn't appear.
Sample test case:
// THIS IS THE CODE THAT WORKS !
// Dont forget to disable above Source when trying this :-)
/*
// Get a Connection...
NpgsqlConnection oConn = new NpgsqlConnection();
// ...with a guilty Connection-String
oConn.ConnectionString = "DRIVER={PostgreSQL};" +
"SERVER=127.0.0.1;" +
"UID=npgsql_tests;" +
"DATABASE=npgsql_tests";
oConn.Open();
DataSet oDSet = new DataSet();
DataAdapter oAdap = new NpgsqlDataAdapter( "SELECT * FROM
MyTable", oConn );
oAdap.Fill( oDSet );
// Normaly via a Count-Statement.
DataGrid1.VirtualItemCount = 3;
DataGrid1.PageSize = 10;
// Assign and bind Datareader
DataGrid1.DataSource = oDSet;
DataGrid1.DataBind();
// Finish. Close what has to be closing...
oConn.Close();
=
// THIS IS THE CODE THAT DOESNT WORK
// Dont forget to disable below Source when trying this :-)
// Get a Connection...
Npgsql.NpgsqlConnection oConn = new
Npgsql.NpgsqlConnection();
// ...with a guilty Connection-String
oConn.ConnectionString = "DRIVER={PostgreSQL};" +
"SERVER=127.0.0.1;" +
"UID=npgsql_tests;" +
"DATABASE=npgsql_tests";
oConn.Open();
// Get a Command-Object
Npgsql.NpgsqlCommand oCmnd = oConn.CreateCommand();
// Assign Statement
oCmnd.CommandText = "SELECT * FROM MyTable";
// Get a Datareader
Npgsql.NpgsqlDataReader oRead = oCmnd.ExecuteReader();
// Normaly via a Count-Statement.
DataGrid1.VirtualItemCount = 3;
DataGrid1.PageSize = 10;
// Assign and bind Datareader
DataGrid1.DataSource = oRead;
DataGrid1.DataBind();
// Finish. Close what has to be closing...
oRead.Close();
oConn.Close();
The only difference between those tests are the datasource type.
This is the stack trace he receives:
// What happens. If PageSize is larger than VirtaulItemCount, following
// Runtime-Error happens when running in Mono.
//System.InvalidOperationException: DataReader positioned beyond
end of result set.
//in <0x00072> Npgsql.NpgsqlDataReader:CheckHaveRow ()
//in <0x00029> Npgsql.NpgsqlDataReader:GetValues (System.Object[]
Values)
//in <0x00031> System.Data.Common.DbEnumerator:get_Current ()
//in <0x00016>
System.Web.UI.WebControls.PagedDataSource+PrivateIEnumeratorEnumerator:get_Current
()
//in <0x006e2>
System.Web.UI.WebControls.DataGrid:CreateControlHierarchy (Boolean
useDataSource)
//in <0x0003f>
System.Web.UI.WebControls.BaseDataList:OnDataBinding (System.EventArgs e)
//in <0x00023> System.Web.UI.WebControls.BaseDataList:DataBind ()
//in <0x000b7> NpgTest.Default:Page_Load (System.Object sender,
System.EventArgs e)
//in (wrapper delegate-invoke)
System.MulticastDelegate:invoke_void_object_EventArgs
(object,System.EventArgs)
//in <0x0005c> System.Web.UI.Control:OnLoad (System.EventArgs e)
//in <0x00026> System.Web.UI.Control:LoadRecursive ()
//in <0x00212> System.Web.UI.Page:InternalProcessRequest ()
//in <0x000af> System.Web.UI.Page:ProcessRequest
(System.Web.HttpContext context)
//in <0x00233>
System.Web.HttpApplication+ExecuteHandlerState:Execute ()
//in <0x0007c>
System.Web.HttpApplication+StateMachine:ExecuteState (IStateHandler
state, System.Boolean readysync)
After checking Npgsql logs, it seems that return value of
NpgsqlDataReader.Read() isn't being checked when it returns false when
there is no more row to be read. As this seems to be ignored, code tries
to read data again and NpgsqlDataReader throws an exception saying there
is no more data to read.
I tested that code with latest svn code and I could see that it is
already fixed.
I just wanted to confirm if this was really a bug with last released
code as with 1.1.8.3 this problem still exists.
Thanks in advance.
- --
Regards,
Francisco Figueiredo Jr.
Npgsq
RE: [Mono-list] Updated Npgsql on svn for 0.7.1 release.
--- Carl Olsen <[EMAIL PROTECTED]> escreveu: > I'm not sure how to go about updating. I think I'm using the Npgsql.dll > that came with SUSE 9.3 Professional. I installed MONO from the RPMs, which > I think resulted in MONO 1.1.7. I then upgraded to MONO 1.1.8, using the > RPMs from Red Carpet. I think I copied the Npgsql.dll file from SUSE 9.3 to > my Windows XP computer and installed it in the global assembly cache, and > then included it as a reference in my projects in Visual Studio before > copying the projects back to SUSE 9.3 and running them on Apache 2. > > If I understand this correctly, I would need a new Npgsql.dll file and > install it in the global assembly caches on both computers (the SUSE Linux > web server and my Windows XP development workstation), and then recompile my > project by deleting the old Npgsql.dll reference and adding the new one. > > If that is correct, where do I get the new Npgsql.dll from? > Yeap. This is correct. You can get the new Npgsql.dll from Npgsql project: http://gborg.postgresql.org/project/npgsql/download/download.php Also, you can get Npgsql from daily builds of Mono: http://mono.ximian.com/daily/ And of course, when we get a new Mono release, the latest Npgsql release will be there too :) I hope it helps. -- Regards, Francisco Figueiredo Jr. ___ Yahoo! Acesso Grátis - Internet rápida e grátis. Instale o discador agora! http://br.acesso.yahoo.com/ ___ Mono-list maillist - Mono-list@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-list
Re: [Mono-list] Updated Npgsql on svn for 0.7.1 release.
--- Joe Audette <[EMAIL PROTECTED]> escreveu: > I was having this problem at r48966 but as of r48977 > its building. > Hi Joe! Sorry for late response. Nice to know you got it working. :) I forgot to add the revision number to my message. I will add it next time. I think putting the revision number of this type of update is of big help.:) Sorry for that. -- Regards, Francisco Figueiredo Jr. __ Converse com seus amigos em tempo real com o Yahoo! Messenger http://br.download.yahoo.com/messenger/ ___ Mono-list maillist - Mono-list@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-list
Re: [Mono-list] System Requirements [or am I crazy]
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Marc DM wrote: > > Add to that, does anyone know how I can use tools available on Linux to > convert a mono/.NET assembly to a JAR compatible with tomcat. I've read > about Mainsoft's Mainwin for J2EE. But it requires Visual Studio and > Windows. I have neither (my XP died, so I'm all Linux now). > IKVM? www.ikvm.net I hope it helps. - -- Regards, Francisco Figueiredo Jr. Npgsql Lead Developer http://gborg.postgresql.org/project/npgsql MonoBrasil Project Founder Member http://monobrasil.softwarelivre.org - - "Science without religion is lame; religion without science is blind." ~ Albert Einstein -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.6 (GNU/Linux) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iQEVAwUBQxB1TP7iFmsNzeXfAQLHBQf/ba2XX8r5tmkUw5DJzKwE6SiEd6yGo8sa c/AJZyuNmD1bUA6tAgJAm7gWSG0KhkKRfedUcBoSfAWExefi4HWsxB8WJMLHub0v Rrcemnc6E+761TCANCOMT6oz0SpZVFPA5qZEl1giTEk5QHmisZOWfA3PSJjr8YFT IA5Z3EvmY4sZ9l/3OLdBlR7Sjo6iyQOWQV+Ox6tZOPEQmZxnLZLwaILiakttn/Yo 6ksyfZf5F153czfsn9dFXuy87zg34p10ahKB4RziPJI1fp+3QmuqFiRdGZ9zK/to ccvua5q69cfX+myLRp17NG59rJ4m+23SpxgLmK90l1UI3WUqZ7NuFQ== =kare -END PGP SIGNATURE- ___ Yahoo! Acesso Grátis - Internet rápida e grátis. Instale o discador agora! http://br.acesso.yahoo.com/ ___ Mono-list maillist - Mono-list@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-list
[Mono-list] Updated Npgsql on svn for 0.7.1 release.
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi all, I just updated Mono svn to Npgsql 0.7.1. Please, give it a try and let me know if there is any problem while compiling Npgsql on Mono. Thanks in advance. - -- Regards, Francisco Figueiredo Jr. Npgsql Lead Developer http://gborg.postgresql.org/project/npgsql MonoBrasil Project Founder Member http://monobrasil.softwarelivre.org - - "Science without religion is lame; religion without science is blind." ~ Albert Einstein -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.6 (GNU/Linux) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iQEVAwUBQxB0tv7iFmsNzeXfAQLHuAf/ejRswa4vwyfIr959vBUkadk5PXKvGGIJ lNMA5LXe50prsgjwkT6KCs8tIkLUzdSeJ1YraA7ITHFgQSFzCZaI3bqiLLMx2+eX NBJzhgoX5JeIDHznwxxzl6aPkvrgpnKFZy1aVFDwIdYjNUkA1+SMbuqjoDFtbszC Vjl42hMM593IIgzFdJgKN3aFxcKbDVDtGmu2/1rElMp8Y1rOnmXsXBl3oIhfSXyM c6fLG7aCy8Ysug0yAd1gTnK1dMY8ikhTAan0rADl/TbZWxgTCkL9kCWFaSG67Xsg MWKIkYiZjbKsUa5NnM20KL2R0qQk28i/sbnjM5x+QbJqByzurZMFig== =g/x5 -END PGP SIGNATURE- ___ Yahoo! Acesso Grátis - Internet rápida e grátis. Instale o discador agora! http://br.acesso.yahoo.com/ ___ Mono-list maillist - Mono-list@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-list
[Mono-list] Npgsql 0.7.1 is out!!
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi all, I'd like to say that Npgsql version 0.7.1 is out. Npgsql is a .Net Provider for Postgresql 7.x and above. It allows your .Net programs access a Postgresql backend. More info about it can be found at: http://www.mono-project.com/contributing/postgresql.html and http://gborg.postgresql.org/project/npgsql This release fix some critical bugs with MinPoolSize and concurrent utilization of Npgsql. Also fixed problems when calling stored procedures and having trailing ";" on commandtexts. Some other bugs were fixed and metadata improved. Please, see full change log below for more details. All users are encouraged to upgrade to this version. Also, on this release, there is no ms.net 1.0 Npgsql version available. Previous 1.0 releases were using Mono.Security.dll compiled for 1.1 and so it was really a 1.1 assembly. Nobody complained up to now so I think nobody is using Npgsql with ms 1.0. Please, let me know if you need a 1.0 installation. Download Page: http://gborg.postgresql.org/project/npgsql/download/download.php We now have windows installers for .Net 1.0 and 1.1. Gnu/Linux and FreeBSD are also available. Special Thanks: * Oluwatope Akinniyi for building and testing windows installers. * Josh Cooley for helping with bug fixes :) * Jon Asher for help and support. * All users and developers who give feedback and comments about Npgsql. Please, give it a try and let me know of any problems you get. RELEASE NOTES: Npgsql 0.7.1 Features added: 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. Added refcursor parameter support. Now, refcursors can be passed as arguments for functions. Thanks Jon Asher for heads up and tests. Bug fixes: 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. 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). gborg 1388. Fixed documentation about User Id connection string key. Thanks Peyn (peyn at tlen dot pl) for heads up. gborg 1387. 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. Fixed problem with stored procedure command texts which finished with a ";". Npgsql was adding incorrectly a trailing "()" when calling this command text. Fixed ConnectorPool when creating MinPoolSize connections. Josh Cooley said when submitting patch: "It seems that if the MinPoolSize was set to anything other than one, then it was prepopulated with the first connector created." Thanks Aza (aza at azaclauson dot com) for heads up and big thanks Josh Cooley (jbnpgsql at tuxinthebox dot net) for fix! Fixed problems with parameters with "@" prefix. They weren't correctly recognized. Thanks Pejvan Beigui ( pejvan at gmail dot com) for heads up. Fixed infinite loop when getting metadata using Mono runtime. We were using DataSet.Fill to get metadata info and Mono implementation of DataSet.Fill was calling our method to get metadata which resulted in a loop. Thanks Josh Cooley (jbnpgsql at tuxinthebox dot net) for fix! Thanks in advance. - -- Regards, Francisco Figueiredo Jr. Npgsql Lead Developer http://gborg.postgresql.org/project/npgsql MonoBrasil Project Founder Member http://monobrasil.softwarelivre.org - - "Science without religion is lame; religion without science is blind." ~ Albert Einstein -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.6 (GNU/Linux) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iQEVAwUBQw/l6f7iFmsNzeXfAQKuoAf/fYU1bjVe9lmdEi58oLOXFNbNCqYT7vkc EcZXbyYOyOSsiG042pPUcu3ni7k5WHXH+D6glknEZIYswrmtC9J9hwZU/C1g0Jme N9xZMu9e9vJ/iXAadTY1bhhaS5zC3OWe9Q8BznnFKFY0rHeXa2IF2UOt1r3AaMYp 6YfBXu8v/fpDCg5u0ccbX7nog/6EZsZgWyeyVrvqiJO6WCP8sK2T3+eXnqPA2sNJ RSKiOr4L2yWHZj5qdHAWSNoTQRP8rb6tZay+V3vNJH0gn8V7vmFQcrgf606Y8KgX G3tnNX1IZLIMt5ojX6A9a+HS2j+09oVHS3CvJ8iTRvdRd9bCVttqJQ== =vPe3 -END PGP SIGNATURE- __
Re: [Mono-list] Npgsql error
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Fabian Salamanca Dominguez wrote:
>
> Hi
>
Hi Fabian!
> I tried to compile a simple C# program and access a Postgresql DB but I
> got this error in runtime (it compiled with no errors) :
>
> [EMAIL PROTECTED] Mono]$ mcs dbaccess.cs -r:Npgsql.dll -r:System.Data.dll
> [EMAIL PROTECTED] Mono]$ mono dbaccess.exe
>
> Unhandled Exception: System.InvalidCastException: Cannot cast from
> source type to destination type.
> in <0x000e1> dbAccess:Main (System.String[] args)
>string sql =
>"SELECT operatingsystem, nodeid " +
>"FROM assets";
What are the sql types of operatingsystem and nodeid?
Npgsql doesn't do any implicit conversion of types.
>dbcmd.CommandText = sql;
>IDataReader reader = dbcmd.ExecuteReader();
>while(reader.Read()) {
> string operatingsystem = (string) reader["operatingsystem"];
> string nodeid = (string) reader["nodeid"];
> Console.WriteLine("OS: " +
> operatingsystem + " " + nodeid);
>}
To be sure, do the following:
Console.WriteLine(reader["operatingsystem"].GetType());
This will show you what type is being returned.
I hope it helps.
- --
Regards,
Francisco Figueiredo Jr.
Npgsql Lead Developer
http://gborg.postgresql.org/project/npgsql
MonoBrasil Project Founder Member
http://monobrasil.softwarelivre.org
- -
"Science without religion is lame;
religion without science is blind."
~ Albert Einstein
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.6 (GNU/Linux)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org
iQEVAwUBQvNlyv7iFmsNzeXfAQLKzAf/V/qotjEIx6JH9HS7zGcrlLzfUad71xeP
WVgR8xo7TkYVvM0rThA3QLk9nlzT+1MLwlLwLO+HjTvz60vgEUmcWwbTFqjbZnt0
hkTmokXeVAdQjLjUsPRAb5xPPcuT89YnGtrfSdpv7wLe/BXJMT/JXE9C/94BuXiB
NL+50QpUQc9ZAKGwcZ4qkO1cDCIi+cLTgjdPBAqOxInLFzYvAbkAgd/yKn1EkRYC
/UYdtsQDdE6ie0dyPh9Q1L6tlBE0bNa7ol0sbY7OjuFtEkx2DvjOycrdMjjCt7HJ
1YkWLIlxUy6lMSzSnYwl7c0RRAgRVeBKldqknPYp9NbfCyC994NGzA==
=txOv
-END PGP SIGNATURE-
___
Yahoo! Acesso Grátis - Internet rápida e grátis.
Instale o discador agora! http://br.acesso.yahoo.com/
___
Mono-list maillist - Mono-list@lists.ximian.com
http://lists.ximian.com/mailman/listinfo/mono-list
[Mono-list] Npgsql 0.7 final is out!!
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi all, I'd like to say that Npgsql version 0.7 final release is out. This will be the last "zero dot" release. We are now heading to 1.0 GA Release. Download Page: http://gborg.postgresql.org/project/npgsql/download/download.php Npgsql is a .Net Provider for Postgresql 7.x and above. It allows your .Net programs access a Postgresql backend. More info about it can be found at: http://www.mono-project.com/contributing/postgresql.html and http://gborg.postgresql.org/project/npgsql Please check full release notes here: http://gborg.postgresql.org/project/npgsql/cvs/co.php/Npgsql/src/Npgsql/RELEASENOTES.txt?r=1.13&Horde=eb8adb715c94c1748841d799b2186791 We now have windows installers for .Net 1.0 and 1.1. Gnu/Linux and FreeBSD are also available. Special Thanks: * Oluwatope Akinniyi for building and testing windows installers. * BitRock guys for providing an special open source license so we can build installers for Gnu/Linux and FreeBSD. * All users and developers who give feedback and comments about Npgsql. Please, give it a try and let me know of any problems you get. Thanks in advance. - -- Regards, Francisco Figueiredo Jr. Npgsql Lead Developer http://gborg.postgresql.org/project/npgsql MonoBrasil Project Founder Member http://monobrasil.softwarelivre.org - - "Science without religion is lame; religion without science is blind." ~ Albert Einstein -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.6 (GNU/Linux) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iQEVAwUBQtZsLv7iFmsNzeXfAQLHIgf/RZCvqQ6ejjDVtGl8C7/COpFCXkWi32Rx ehdLpAE8UCL5gM+4SgaLzjHeQ7MMD0kUQ/RJBYqxf7YsFNGzKpBqu2lYlJnjp5j3 W5vC0NRGAwrr4S2PuVMGV8Ym7AgunbZMq/bHm+Gijumme91O5f7xLR2cDV8XGWRf bRAASGOkt6j+OgGVu3VYQe5GfyHQlXZKwtE0tsbJxsTgAOZSe5vo1RVgHXJ5F138 dWpFpjNSG6FeCKNAFE87OrffPwxTiW4psH3qg0uOW+9bJeR/h8CxTTifSD+1amU/ n7RkA2ZyHhztgWfBBsLobBwH2QjQvgiMqS+AlzLIs9UpCsCCsmg5Hw== =eJB0 -END PGP SIGNATURE- ___ Yahoo! Acesso Grátis - Internet rápida e grátis. Instale o discador agora! http://br.acesso.yahoo.com/ ___ Mono-list maillist - Mono-list@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-list
[Mono-list] Updated Npgsql code in svn
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi all, I finally updated Npgsql code in Mono svn to updated 0.7beta6. Please, give it a try and let me know if you find any problems. Thanks in advance. - -- Regards, Francisco Figueiredo Jr. Npgsql Lead Developer http://gborg.postgresql.org/project/npgsql MonoBrasil Project Founder Member http://monobrasil.softwarelivre.org - - "Science without religion is lame; religion without science is blind." ~ Albert Einstein -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.6 (GNU/Linux) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iQEVAwUBQssX1v7iFmsNzeXfAQIXtAf9Gk8Cunx+DJXwm/uI59rd4AnHzzuDf5tt wbizUxqkzU8IC6r2w5UJKMGV5sKLxdk7V465Tl3cMClmEYwSi4zP4jTzmDeNjxDH baWJuv1mrqcjMR9FWHKYYDPf6/xZ6tpP30Caj3dchiiof5wJn0XfSIg966QMUkZW LfqEkfy6qgb/6OpqiMEpqUPkb9w0zBfVccRXUGkWPF9X9iwXKiIafCbYmuVOfIaq GxPYVnxXeVgSBZn1+cxJUfhVdaiRJHuAWxzhi9vhBWpNmLtg32xPblwDeI+uWStU FY6t8gjgdwYe238REoqenRMvt43cDuKiH6yaOcF1l7q7y6UNu+A3Gw== =hExc -END PGP SIGNATURE- ___ Yahoo! Acesso Grátis - Internet rápida e grátis. Instale o discador agora! http://br.acesso.yahoo.com/ ___ Mono-list maillist - Mono-list@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-list
RE: [Mono-list] Time out using Npgsql
--- Carl Olsen <[EMAIL PROTECTED]> escreveu: > I have set up an identical web site on a Windows 2003 server using the same > database on my Linux box. The next time the Apache site locks up, I'll see > if the Windows 2003 site is doing the same thing. Both of them use Npgsql, > so that may produce more information on where the problem is occurring. > Hi Carl! Thanks for set them up. This will allow us to see if the problem is with Npgsql. Please, let me know when you have problems. Regards, Francisco Figueiredo Jr. __ Converse com seus amigos em tempo real com o Yahoo! Messenger http://br.download.yahoo.com/messenger/ ___ Mono-list maillist - Mono-list@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-list
RE: [Mono-list] Time out using Npgsql
--- Carl Olsen <[EMAIL PROTECTED]> escreveu: > I can't figure out where it is failing, because it just times out. It's > happening on all of my page now, since I have a session hit counter in the > global.asax.cs file that writes to PostgreSQL every time someone visits the > site. Before I added the hit counter, it was only occurring on the page > that had data connections to PostgreSQL. It only happens occasionally, not > all the time. Restarting Apache fixes it. I'm not sure if the problem is > Npgsql or Apache, or both. > Hi Carl. Can you check if your webserver box is having network problems with your postgresql box? This may mean some type of firewall or some network program which could temporarily disable access to your postgresql box. Also, could you try some console app in your webserver box to connect to your postgresql box? This test could make you sure that you are being able to get data from postgresql. It would also be good if you could put this console app to keep all day trying connections to postgresql in order to check if you get network down just sometimes. I hope it helps. Regards, Francisco Figueiredo Jr. ___ Yahoo! Acesso Grátis - Internet rápida e grátis. Instale o discador agora! http://br.acesso.yahoo.com/ ___ Mono-list maillist - Mono-list@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-list
RE: [Mono-list] Npgsql.dll
--- Carl Olsen <[EMAIL PROTECTED]> escreveu: > Hi Francisco, > Hi Carl, sorry for late response. > I did create an alias: > > declare > input ALIAS FOR $1; > > are you suggesting that I use "param1" instead of "input"? > > I suppose that would make it easier to do the ADO.NET code, rather than > trying to remember unusual names for parameters. Is that your point? > Yeap, this is exactly my point. Parameter names can help document your procedure so you can remember some time later when you have to update or check for some error in your procedure. Regards, Francisco Figueiredo Jr. __ Converse com seus amigos em tempo real com o Yahoo! Messenger http://br.download.yahoo.com/messenger/ ___ Mono-list maillist - Mono-list@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-list
Re: [Mono-list] Npgsql.dll
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Carl Olsen wrote: > Hi Chris, > Hi Carl, I'm not Chris, but I'd like to make a suggestion: try to crate an alias for your parameter: declare param1 ALIAS for $1; I hope it helps. - -- Regards, Francisco Figueiredo Jr. Npgsql Lead Developer http://gborg.postgresql.org/project/npgsql MonoBrasil Project Founder Member http://monobrasil.softwarelivre.org - - "Science without religion is lame; religion without science is blind." ~ Albert Einstein -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.6 (GNU/Linux) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iQEVAwUBQrSpuP7iFmsNzeXfAQK5Vgf7BtoV9sIJKH+XPDQU5l1sEvip7i4A0Juz 3sevk3dyg3IuX07N2WXOHowU95zDTJysOOmO5pqIkSVBdYOweFejnKmd1nvnXjIw JrKIh0ymFYXLet5wOGLkHDuzis+f8I/b5x9+cT1+1q1+I/SGy3HxE+p05GxJ5RgV IWPqEKec3PPanMiovR3Awg/Mze4AUQNPGO7D0f9DHE1oy0jJ9F0iWDiuR1Ao+aNl 3qa6JZMIvseLI+vcK8fY8VySSRvkshsxQtgy+9fgFdwVYxbNjqKQdn+Q7sYpbUM1 Ychmwcc97EObp4h2Pvm+QoBNn8jbV47DEsD0etyxO+64D1po9TrJzw== =4mMq -END PGP SIGNATURE- ___ Yahoo! Acesso Grátis - Internet rápida e grátis. Instale o discador agora! http://br.acesso.yahoo.com/ ___ Mono-list maillist - Mono-list@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-list
Re: [Mono-list] Npgsql.dll (correction)
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Carl Olsen wrote: > It seems to be working fine now since I rebooted the server, so I'm not sure > it actually slows down or just stops working. I'm going to convert the > stored procedures from SQL to PL/pgsql right now, so I'll see if that makes > any difference. > Hi Carl! - From what I see from your code it seems correct and shouldn't be slowing down after each iteration. Sorry for not being very much helpful here :( Please, let us know if it keeps getting slow. Thanks in advance. - -- Regards, Francisco Figueiredo Jr. Npgsql Lead Developer http://gborg.postgresql.org/project/npgsql MonoBrasil Project Founder Member http://monobrasil.softwarelivre.org - - "Science without religion is lame; religion without science is blind." ~ Albert Einstein -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.6 (GNU/Linux) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iQEVAwUBQrShKv7iFmsNzeXfAQJhAQf8DCy2eQTLD9+HlkLxvKdigf0JLkOrsjHn r1yis2EX7CTqxFtZI58SB4b181tXeXDQ5Vua0wuBqpV4EfhrT58O8Y3zaU/g8IDZ IiWF0hViXXijBX+dPEpQQlb9TouNAocTJ37RirV2dHie1wv9K+IcFeNLD8IKGsxW a5oPSq5x8TXY8Gg3qwoMvO3d+WfndnzaYuLoFskLjJcebcm5EpYMiW1bYrlRjgig gg0VTA/S6KGUE82pWYNzMkfFc4Rq9m5nkNU00lWApm5e7+oERBXfj9i4Hp7QP3Ev S7urYb/uCtnTyyFM+ZTqt9aiA4ucO/zbzk2+IHwcLFxV+i1YW2CMPQ== =IgIW -END PGP SIGNATURE- ___ Yahoo! Acesso Grátis - Internet rápida e grátis. Instale o discador agora! http://br.acesso.yahoo.com/ ___ Mono-list maillist - Mono-list@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-list
Re: [Mono-list] Npgsql.dll (correction)
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Carl Olsen wrote: > I'm having trouble with the page timing out before it returns any data. It > seems to work fine after the server is rebooted, and just keeps getting > slower each time the page is opened. > Hm, this is very strange :( Do you have some samples of query code you are doing? I don't see right now what could be happening in Npgsql which could be causing it to make server slower each time page is opened. Maybe with your sample queries I can do a better investigation. Did you try do some repeating queries on console to see if you can reproduce this problem? - -- Regards, Francisco Figueiredo Jr. Npgsql Lead Developer http://gborg.postgresql.org/project/npgsql MonoBrasil Project Founder Member http://monobrasil.softwarelivre.org - - "Science without religion is lame; religion without science is blind." ~ Albert Einstein -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.6 (GNU/Linux) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iQEVAwUBQrJuR/7iFmsNzeXfAQI/vQf+OLA9sFY7XlCA+DACqWe4N7k6AmAPQSdZ pCKBxYTzu17pl/OVwzs+0ovSWQUBASmGjoT6RSkZ3G4Z88TFJf+O1fh5u0oznL09 EPNyc07G7VttoKLUqKBS40nimY4Pfgp2bI/7+1UgzPJ3qWyvZPqWQwB3NmEYliza RARvGEj/EE2EXhhA9YEz5BCQ/PspptLhm0aLJ/azJ32foAwFx4qjSYWeJdkZxJGM bLGDGDoGoTjN4EbmJGET6H1t5EYBrzvXKu8madrKSIyNH6zm3vYLTNfOhTZDDTLd w8vzmaSB3UCOSu3oFxGaVhajpMA61v0r4czDKxB+bzUobU1s2pAvqA== =4ut1 -END PGP SIGNATURE- ___ Yahoo! Acesso Grátis - Internet rápida e grátis. Instale o discador agora! http://br.acesso.yahoo.com/ ___ Mono-list maillist - Mono-list@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-list
RE: [Mono-list] Npgsql.dll (correction)
--- Carl Olsen <[EMAIL PROTECTED]> escreveu: > Please ignore. I have it working now. > Great!! Nice to know you got it working! Regards, Francisco Figueiredo Jr. __ Converse com seus amigos em tempo real com o Yahoo! Messenger http://br.download.yahoo.com/messenger/ ___ Mono-list maillist - Mono-list@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-list
