Skip site navigation (1) Skip section navigation (2)

Re: [JDBC] Where are we on stored procedures?

From: Markus Schaber <schabios(at)logi-track(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: [JDBC] Where are we on stored procedures?
Date: 2005-02-25 18:08:45
Message-ID: 421F69AD.1000803@logi-track.com (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-jdbc
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(at)logi-track(dot)com | www.logi-track.com

In response to

Responses

pgsql-hackers by date

Next:From: Marc G. FournierDate: 2005-02-25 18:10:50
Subject: Re: Development schedule
Previous:From: Peter EisentrautDate: 2005-02-25 18:05:18
Subject: Re: [pgsql-hackers] Daily digest v1.4988 (21 messages)

pgsql-jdbc by date

Next:From: Markus SchaberDate: 2005-02-25 18:21:02
Subject: Re: [JDBC] Where are we on stored procedures?
Previous:From: Dave SmithDate: 2005-02-25 16:21:10
Subject: Re: setFetchSize question

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group