agora inbox for pgsql-hackers@postgresql.org
help / color / mirror / Atom feedFrom: Markus Schaber <schabios@logi-track.com>
To: pgsql-hackers@postgresql.org
Cc: pgsql-jdbc@postgresql.org
Subject: Re: [JDBC] Where are we on stored procedures?
Date: Fri, 25 Feb 2005 19:08:45 +0100
Message-ID: <421F69AD.1000803@logi-track.com> (raw)
In-Reply-To: <421F39E0.9000706@yahoo.com.br>
References: <20050224214935.57272.qmail@web60703.mail.yahoo.com>
<28071.1109284368@sss.pgh.pa.us>
<421F39E0.9000706@yahoo.com.br>
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.
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
--
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@logi-track.com | www.logi-track.com
Attachments:
[application/pgp-signature] signature.asc (255B, ../421F69AD.1000803@logi-track.com/2-signature.asc)
download
view thread (15+ messages) latest in thread
Message-ID: <421F69AD.1000803@logi-track.com>
Permalink: ../421F69AD.1000803@logi-track.com/
Also on: postgresql.org/message-id/421F69AD.1000803@logi-track.com
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: schabios@logi-track.com, pgsql-jdbc@postgresql.org
Subject: Re: [JDBC] Where are we on stored procedures?
In-Reply-To: <421F69AD.1000803@logi-track.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox