-----BEGIN PGP SIGNED MESSAGE-----
Markus Schaber wrote:
| Hi, Francisco,
| Francisco Figueiredo Jr. schrieb:
|>In fact, I think people keep requesting me support on Npgsql for that
|>because MS Sql server supports it and they are porting their code to use
|>Postgresql and facing that difficult.
|>Indeed, for (a) we could use an approach similar to Ms sql server. We
|>could have a way of the procedure say if it wanted to send the rows
|>affected information or not.
|>And about (b) I think that it is only on trivial cases that people
|>really want to use this feature :)
| As you need to tweak the function/procedure source to implement (a), you
| can also tweak the function/procedure to return the row cound and
| whatever other diagnostics you need.
Yeap, You are right.
| For newly implemented stored procedures, we could create a special
| diagnostics result set that every procedure creates. This usually
| contains some success/error information, but the procedure could add
| additional rows to it.
I think this could be a very good idea. I think you could create an
special tag which would say to create this special resultset or not as,
I think, not every stored procedure would need it.
I think this would be very nice.
Thanks Markus, for feedback.
Francisco Figueiredo Jr.
Membro Fundador do Projeto MonoBrasil - MonoBrasil Project Founder Member
"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
-----END PGP SIGNATURE-----
In response to
pgsql-hackers by date
|Next:||From: Oliver Jowett||Date: 2005-03-01 02:12:21|
|Subject: Re: Execute and PortalSuspended needs explicit transaction|
|Previous:||From: Serguei A. Mokhov||Date: 2005-03-01 02:08:03|
|Subject: Re: [pgsql-advocacy] Development Plans|
pgsql-jdbc by date
|Next:||From: Stéphane RIFF||Date: 2005-03-01 07:56:49|
|Subject: Connection pool problem|
|Previous:||From: Markus Schaber||Date: 2005-02-28 21:53:00|
|Subject: Re: Abandoning PGobject|