serafin segador <rsegador@xxxxxxxxx> 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/
