Search Postgresql Archives

temp table in 8.3

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




hello list,

i am a newbie in postgresql.

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.

regards and any help is highly appreciated,

raffy segador



--
Using Opera's revolutionary e-mail client: http://www.opera.com/mail/


---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux