Re:

serafin segador <rsegador@yahoo.com> writes:
> i ported a small application to postgresql 8.2 originally written to store data in maxdb.  since stored procedures
arenot supported in postgresql and since postgresql functions cannot return cursor to the calling applications, i
rewrotethe 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
thesame session.  this i can no longer do after upgrading to 8.3.  is there any thing i can do to restore this
functionalityi 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