[Mono-list] Npgsql.dll

[Francisco Figueiredo Jr.]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Carl Olsen wrote:
> Hi Francisco,
> 

Hi Carl!

> My web page is running on Apache and Linux using C# as the page language and
> PostgreSQL as the database. I'm executing a stored procedure that creates a
> temporary table and then returns the data from the temporary table to a
> datagrid in the web page. A temporary table only exists while a connection
> is open, so I open and close the connection in the page load event handler.
> The problem I'm having is that when I hit the Refresh button in Internet
> Explorer 6, I get an error message saying that the temporary table already
> exists. I always thought the Refresh button reloaded the page, but
> apparently not. How can I capture the event that occurs when the Refresh
> button is selected? 
> 

Hmmm, this is caused because of connection pooling. While you close the
connection, its underlying connection to server isn't closed.

You could overcome that by checking if the table exists and clean it up
before use, or just drop the table when you are done after getting the data.



> By the way, I thought Npgsql.dll was installed in the global assembly cache
> by default in SUSE 9.2 Professional.  I just used Red Carpet to upgrade to
> Mono 1.1.x, but it appears that Npgsql.dll is installed in the global
> assembly cache.  That's where I copied it from to get it into the bin folder
> of my web application.  I copied the Npgsql.dll file from
> /usr/lib/mono/Npgsql/1.0.5000_0.5d8b90d52f46da7
> 

Hmmmm, this is strange. I don't know details about GAC but I thought it
should be found when in GAC.




- --
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

iQEVAwUBQoYldf7iFmsNzeXfAQLdQAf+PqLMPvm1Uqva1Jw+5u1p8R4/nNhohjYb
HvXVaSX2E2azBOG0GQ2vTIczIJ7YvsbG6wBImWlmo1SzhVt5VtXmVz2PYh0CQyLZ
zrBwoAkHGqhGd+uj4EVAQq4wX2i3uNHUxoo94yjXNpQe01+oQeg1bP8qB7DQlEq4
dGngwRtc5B40UO8eN99Sn4JkzctG0y5usR8crk7jlIAE6KIz/9+MQ7UWbSJsIRf2
J35AgxuXyMEq4dtrNhcnvoiOya98sokUNsYQainoQ5Uv75XKg0Zlwlrr6XXlhSta
03IyJiAuW+qfVYZjrh0DvEfTk3D8A6/C6LBjhsbRkRK8Glsf7IZYOQ==
=wJDC
-----END PGP SIGNATURE-----