| Lists: | pgsql-php |
|---|
| From: | "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk> |
|---|---|
| To: | "Jack -" <jackhappy6(at)hotmail(dot)com>, <pgsql-php(at)postgresql(dot)org> |
| Subject: | Re: Maintaining a transaction across multiple HTTP requests |
| Date: | 2004-06-18 16:37:39 |
| Message-ID: | E7F85A1B5FF8D44C8A1AF6885BC9A0E407B366@ratbert.vale-housing.co.uk |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-php |
> -----Original Message-----
> From: Jack - [mailto:jackhappy6(at)hotmail(dot)com]
> Sent: Fri 6/18/2004 5:08 PM
> To: Dave Page
> Subject: Maintaining a transaction across multiple HTTP requests
>
> could u store of a connection handle in a session variable - but on the
> server side have the session information stored on a shared database
> instead of a file?
Hi Jack,
I considered that approach, but the problem is that the handle is only valid for the apache process that it was opened under. If the second request is processed by a different apache process, then it'll all go horribly wrong :-(
Regards, Dave
| From: | Aaron Dummer <aaron(at)dummer(dot)info> |
|---|---|
| To: | pgsql-php(at)postgresql(dot)org |
| Subject: | Determining transaction status |
| Date: | 2005-05-02 16:34:38 |
| Message-ID: | 1115051678.31523.7.camel@localhost |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-php |
Hey guys,
Is there any way to determine transaction status without using
pg_transaction_status() (which hasn't been officially released yet)?
I'm using PostgreSQL 8.0.2/PHP 5.0.4.
Thanks!
--
Aaron Dummer
aaron(at)dummer(dot)info
| From: | Volkan YAZICI <volkan(dot)yazici(at)gmail(dot)com> |
|---|---|
| To: | Aaron Dummer <aaron(at)dummer(dot)info> |
| Cc: | pgsql-php(at)postgresql(dot)org |
| Subject: | Re: Determining transaction status |
| Date: | 2005-05-02 17:06:39 |
| Message-ID: | 7104a737050502100665a8c51a@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-php |
Hi,
On 5/2/05, Aaron Dummer <aaron(at)dummer(dot)info> wrote:
> Is there any way to determine transaction status without using
> pg_transaction_status() (which hasn't been officially released yet)?
You can patch your ext/pgsql/pgsql.c from CVS. pg_transaction_status()
is added in revision 1.315.
[http://cvs.php.net/php-src/ext/pgsql/pgsql.c]
Regards.
| From: | Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> |
|---|---|
| To: | Aaron Dummer <aaron(at)dummer(dot)info> |
| Cc: | pgsql-php(at)postgresql(dot)org |
| Subject: | Re: Determining transaction status |
| Date: | 2005-05-03 01:22:44 |
| Message-ID: | 4276D264.6090103@familyhealth.com.au |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-php |
> Is there any way to determine transaction status without using
> pg_transaction_status() (which hasn't been officially released yet)?
No.
Chris