Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

2 distinct connections



We're working on a project using PHP and PostgreSQL, mainly trying to work in an OOP fashion. The project has quite a good amount of code, and a DB Object called DB_Bib that has all the query methods. I also have a generic DB object (DB_Main) which has code to establesh the connection, and from which my DB_bib Inerits the DB connection.

The thing is that I made a new class called DB_Debug which also inherits from DB_Main, and is there to have debugging data inserted into a table in the database.

I noticed that when the two objects are started (they both call the connection method using the same connection string) php doesn't initiate to distinct connections, but 1 connection within commands from both objects get passed to the DB server.

The problem is that query commands from the DB_Debug object and from the DB_Bib object get mixed up in the same connection, making it deficult to know when to make a commit.

Is there a way to fix this without having to change the connection string?

--
 21:50:04 up 2 days,  9:07,  0 users,  load average: 0.92, 0.37, 0.18
---------------------------------------------------------
Lic. Martín Marqués | SELECT 'mmarques' || Centro de Telemática | '@' || 'unl.edu.ar';
Universidad Nacional        |   DBA, Programador,
    del Litoral             |   Administrador
---------------------------------------------------------


Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group