Postgres Pro
Downloads
Home   >   mailing lists

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

From Misa Simic
Subject Re: Trying to execute several queries involving temp tables in a PHP script
Date
Msg-id CAH3i69keywpke69uF_+Rqrzh9a9=Cq8Rd1OrjhNshD_h-_ts3g@mail.gmail.com
Whole thread Raw
In response to Re: Trying to execute several queries involving temp tables in a PHP script  (Leif Biberg Kristensen <leif@solumslekt.org>)
List pgsql-general
Tree view
I agree with approach to have all in functions... In that case there would not be a problem with temp tables because of inside 1 transaction they would work...

suggestion was just to solve problem from php... what would be achiavable just trough 1 query, or to use PDO and then:

$dbh->beginTransaction();
$dbh->exec(query1);
$dbh->exec(query2);
$dbh->exec(query3);
$dbh->commit();

Kind Regards,

Misa

2012/6/13 Leif Biberg Kristensen <leif@solumslekt.org>
 Onsdag 13. juni 2012 15.12.33 skrev Alexander Farber :

> Any ideas please on how to handle this situation
> in PHP scripts, do I really have to encapsulate
> my calls into a pl/PgSQL function?

I believe that Misa Simic's idea that you can do it all in a single query
without temp tables is correct. But anyway, it's always a good idea to
encapsulate multiple interdependent queries in a single pl/pgsql function. I
tend to keep my PHP code as simple as possible, and do most of the work inside
the database.

regards, Leif
http://code.google.com/p/yggdrasil-genealogy/

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

pgsql-general by date:

Previous
From: Leif Biberg Kristensen
Date:
Subject: Re: Trying to execute several queries involving temp tables in a PHP script
Next
From: Misa Simic
Date:
Subject: Re: Create view is not accepting the parameter in postgres functions