temp table in 8.3

From: "serafin segador" <rsegador(at)mydestiny(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: temp table in 8.3
Date: 2008-02-20 04:37:23
Message-ID: op.t6s24lk4ewxm4l@gd-mis.mydestiny.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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/

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2008-02-20 04:44:12 Re: How to make update rapidly?
Previous Message hewei 2008-02-20 04:03:20 Re: How to make update rapidly?