Olexandr Melnyk wrote: > > There are several potential problems I don't know how to solve yet. > > First one is combining PostgreSQL's multi-process > nature with Mono. Should Mono runtime be initialised every time a (Mono-based) > stored procedure is invoked in PostgreSQL? How good will this work > from performance stand point?
The runtime should be initialized once. > Second one is handling transactions. If we want to allow sending > queries back to > the database from managed code, one way would be to create a connection in > the opposite > direction. However, this will not work with transactions as two > connections are isolated from each > other. Another possible solution is to pass connection resource from > PostgreSQL through PL/Mono to managed code, and ask ADO.NET to reuse it. > Any thoughts on this? Let's have a look at PL/Java's code: it comes with its own JDBC driver around Pg's SPI API. This probably means that there is no no way to pass a connection from inside a procedure to a driver. Same for PL/Perl. You may want to ask this question on PostgreSQL's mailing lists as well. Robert _______________________________________________ Mono-list maillist - [email protected] http://lists.ximian.com/mailman/listinfo/mono-list
