Postgres Pro
Downloads
Home   >   mailing lists

Re: Trying to execute several queries involving temp tables in a PHP script - Mailing list pgsql-general

From Alban Hertroys
Subject Re: Trying to execute several queries involving temp tables in a PHP script
Date
Msg-id CAF-3MvO9Gjck5izmdOhKMj7td5Hy8SAnmFa2CdNr+hYhHG4+FQ@mail.gmail.com
Whole thread Raw
In response to Trying to execute several queries involving temp tables in a PHP script  (Alexander Farber <alexander.farber@gmail.com>)
List pgsql-general
Tree view 
On 13 June 2012 15:12, Alexander Farber <alexander.farber@gmail.com> wrote:
> And when I split my statements into multiple
> prepare()/execute() or query() calls,
> then the temp. tables aren't found anymore.

Did you remember to wrap them in a transaction like you did in your
prepared statement?

--
If you can't see the forest for the trees,
Cut the trees and you'll see there is no forest.

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: PostgreSQL 9.2, SQL functions' named vs numbered parameters.
Next
From: Misa Simic
Date:
Subject: Re: Trying to execute several queries involving temp tables in a PHP script