RE: [Mono-list] Npgsql.dll (correction)

2005-06-18 Thread Carl Olsen
] [mailto:[EMAIL PROTECTED] On Behalf Of Carl Olsen Sent: Friday, June 17, 2005 4:55 PM To: 'Francisco Figueiredo Jr.'; mono-list@lists.ximian.com Subject: RE: [Mono-list] Npgsql.dll (correction) It works just fine after I reboot the server, but stopping and starting PostgreSQL doesn't help. That leads

Re: [Mono-list] Npgsql.dll (correction)

2005-06-18 Thread Francisco Figueiredo Jr.
-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

RE: [Mono-list] Npgsql.dll (correction)

2005-06-18 Thread Carl Olsen
Subject: 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

Re: [Mono-list] Npgsql.dll (correction)

2005-06-17 Thread Francisco Figueiredo Jr.
-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

RE: [Mono-list] Npgsql.dll (correction)

2005-06-17 Thread Carl Olsen
Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Francisco Figueiredo Jr. Sent: Friday, June 17, 2005 1:32 AM To: mono-list@lists.ximian.com Subject: Re: [Mono-list] Npgsql.dll (correction) -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Carl Olsen wrote: I'm having trouble

RE: [Mono-list] Npgsql.dll (correction)

2005-06-15 Thread Chris Aitken
] On Behalf Of Carl Olsen Sent: Tuesday, June 14, 2005 11:26 PM To: [EMAIL PROTECTED]; mono-list@lists.ximian.com Subject: RE: [Mono-list] Npgsql.dll (correction) ERROR: set-valued function called in context that cannot accept a set CONTEXT: PL/pgSQL function sp_getstatelist line 6 at return

RE: [Mono-list] Npgsql.dll (correction)

2005-06-15 Thread Francisco Figueiredo Jr.
--- 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

RE: [Mono-list] Npgsql.dll (correction)

2005-06-15 Thread Carl Olsen
- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Francisco Figueiredo Jr. Sent: Wednesday, June 15, 2005 4:05 PM To: mono-list@lists.ximian.com Subject: RE: [Mono-list] Npgsql.dll (correction) --- Carl Olsen [EMAIL PROTECTED] escreveu: Please ignore. I have it working now

RE: [Mono-list] Npgsql.dll (correction)

2005-06-14 Thread Carl Olsen
ERROR: set-valued function called in context that cannot accept a set CONTEXT: PL/pgSQL function sp_getstatelist line 6 at return next My table is Accounts_StateCodes The fields are Description,StateCode,Region The types are varchar(60),char(2),varchar(60) CREATE TYPE StateCodes AS (