Transaction on start of session ? - Mailing list pgsql-general

From Paul
Subject Transaction on start of session ?
Date
Msg-id a6fq6k$26jk$1@jupiter.hub.org
Whole thread Raw
List pgsql-general
The problem:

I want to create a function that returns the result as many tuples (many
rows of records). Unlike MSSQL, Oracle, etc PostgreSQL couldnt do it. So, I
decided the only way to do it is to return result data into temporary table.

But:

- If I create table into stored procedure, I got the error from the second
call of this procedure inside the same session. It's because Plpgsql makes
precompilation of the query at the first call of this procedure inside the
session. And when I delete the result temporary table that this procedure
returned me and call this procedure second time, the query with "INSERT"
(that is already precompiled) uses the table that was already deleted, but
not the table that was just created. :(

- I couldnt check is some temporary table exist inside the session. :(

The way I could decide this problem is:

- At each start of session some stored procedure must run (as some kind of
transaction). And in this stored procedure I want to create all temporary
tables that I want to use to store resulting rows from other stored
procedures. And I shall not need to create any temporary table inside these
procedures.





pgsql-general by date:

Previous
From: "Marshall Spight"
Date:
Subject: Re: PostgreSQL the right choice?
Next
From: Arian Prins
Date:
Subject: Re: Stored procedure in PostgreSQL