serafin segador <[EMAIL PROTECTED]> writes:
> i ported a small application to postgresql 8.2 originally written to store
> data in maxdb. since stored procedures are not supported in postgresql and
> since postgresql functions cannot return cursor to the calling applications,
> i rewrote the maxdb stored procedures into functions that store rows in temp
> tables and return the temp table name to the application ( saves on coding
> the select string in the application) , and retrieve the rows from the temp
> table within the same session. this i can no longer do after upgrading to
> 8.3. is there any thing i can do to restore this functionality i can get in
> 8.2, like configuration tweaking, apart from recoding the select string in
> the application.
Er ... say what?
> stored procedures are not supported in postgresql
This is a false statement, unless perhaps for a very narrow definition
of "stored procedure", which you didn't specify.
> and since postgresql functions cannot return cursor to the
> calling applications,
Likewise a false statement.
> i rewrote the maxdb stored procedures into
> functions that store rows in temp tables and return the temp table
> name to the application ( saves on coding the select string in the
> application) , and retrieve the rows from the temp table within the
> same session. this i can no longer do after upgrading to 8.3.
I do not know any reason why a feature in this vicinity would have
disappeared in 8.3.
If you want help, you need to be a lot more specific about exactly what
you did and exactly what failure you saw. And a bit less FUD-spouting
would probably make people more inclined to assist you.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
