Re: Trying to execute several queries involving temp tables in a PHP script

From: Alban Hertroys <haramrae(at)gmail(dot)com>
To: Alexander Farber <alexander(dot)farber(at)gmail(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Trying to execute several queries involving temp tables in a PHP script
Date: 2012-06-13 14:07:08
Message-ID: CAF-3MvO9Gjck5izmdOhKMj7td5Hy8SAnmFa2CdNr+hYhHG4+FQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 13 June 2012 15:12, Alexander Farber <alexander(dot)farber(at)gmail(dot)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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Misa Simic 2012-06-13 15:01:16 Re: Trying to execute several queries involving temp tables in a PHP script
Previous Message Tom Lane 2012-06-13 13:54:52 Re: PostgreSQL 9.2, SQL functions' named vs numbered parameters.