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.
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.
markus schaber | dipl. informatiker
logi-track ag | rennweg 14-16 | ch 8001 zürich
phone +41-43-888 62 52 | fax +41-43-888 62 53
mailto:schabios(at)logi-track(dot)com | www.logi-track.com
In response to
pgsql-hackers by date
|Next:||From: Marc G. Fournier||Date: 2005-02-25 18:10:50|
|Subject: Re: Development schedule|
|Previous:||From: Peter Eisentraut||Date: 2005-02-25 18:05:18|
|Subject: Re: [pgsql-hackers] Daily digest v1.4988 (21 messages)|
pgsql-jdbc by date
|Next:||From: Markus Schaber||Date: 2005-02-25 18:21:02|
|Subject: Re: [JDBC] Where are we on stored procedures?|
|Previous:||From: Dave Smith||Date: 2005-02-25 16:21:10|
|Subject: Re: setFetchSize question|