Skip site navigation (1) Skip section navigation (2)

Re: HOW TO RETRIEVE VALUE FROM TEMP TABLE ON THE INTERFACE

From: Jaime Casanova <systemguards(at)gmail(dot)com>
To: "Vasudeva, Rahul" <rahul(dot)vasudeva(at)capgemini(dot)com>
Cc: pgsql-cygwin(at)postgresql(dot)org
Subject: Re: HOW TO RETRIEVE VALUE FROM TEMP TABLE ON THE INTERFACE
Date: 2006-01-14 20:14:43
Message-ID: c2d9e70e0601141214wfac9710md5615bc826d0386a@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-cygwin
On 1/10/06, Vasudeva, Rahul <rahul(dot)vasudeva(at)capgemini(dot)com> wrote:
>
>
>
> Hi,
>
>
>
>     I am executing a stored procedure from an ASP page without any input parameters, in that stored procedure two sql queries are executed and the result is stored in a temporary table, now I want to retrieve the recordset of that temp table on the interface.
>
>
>
> There is an error every time on the Interface "Invalid Object"  , although I am dropping the temp table explicitly ..
>
>
>
> Thanks & Regards
>
> Rahul Vasudeva.
>
>

As you have already notice, there are little people looking as this
list... that is because now that we have a native port to windows use
the cygwin version is deprecated... and i am suggesting you to do that
as soon as possible...

There other list you can write here: http://www.postgresql.org/community/lists/

About your question the reason is that temp tables un functions must
be declared within a EXECUTE... something like:


CREATE FUNCTION ffoo() RETURNS void AS $$
DECLARE
         EXECUTE 'CREATE TEMP TABLE tmp_foo (fld int4)'
END;
$$ LANGUAGE 'plpgsql';





--
Atentamente,
Jaime Casanova
(DBA: DataBase Aniquilator ;)

In response to

pgsql-cygwin by date

Next:From: Leong_Kuong_FaiDate: 2006-01-16 23:29:32
Subject: service 'postmaster' failed: signal 12 raised
Previous:From: Roland WalterDate: 2006-01-12 13:18:19
Subject: PG 8.1.2 CYGWIN 1.5.17 VACUUM very slow.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group