[Mono-list] Npgsql.dll

Francisco Figueiredo Jr. fxjrlists at yahoo.com.br
Sat May 14 12:21:09 EDT 2005

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.

- --

Francisco Figueiredo Jr.
Npgsql Lead Developer
MonoBrasil Project Founder Member

- -------------
"Science without religion is lame;
religion without science is blind."

                  ~ Albert Einstein
Version: GnuPG v1.2.6 (GNU/Linux)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org


More information about the Mono-list mailing list