libpq bug? (I guess not)

From: "Yasuo Ohgaki" <yasuo_ohgaki(at)hotmial(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: libpq bug? (I guess not)
Date: 2001-04-01 09:05:24
Message-ID: 9a6r0n$2imr$1@news.tht.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general

Hello all,

I need feedback from you!
I would like to make sure no one on this list did not experience following
problem in order to find what's wrong with my system.

OS: RedHat 7.0.1/ja (+ RedHat's glibc,gcc update RPM)
PostgreSQL: 7.0.3 (no additional patches, compiled from source. 32KB page size)
PHP: 4.0.4pl1 as Apache 1.3.19 DSO (These are compiled from source) TCP
connection to PostgreSQL Server.

I believe PHP4 uses libpq, so I would like to know if anyone experiences
following problem with libpq (or others like psql)

A query is executed multiple times, even if it suppose to do it once.

I have a PHP code to execute query like

$db = pg_pconnect('db=my_db host=localhost user=username');
$query = "INSERT INTO new_user (username, email, ............) VALUES ('ABC',
'foo(at)example(dot)com', ..........);";
pg_exec($db, $query); // Execute query using database connection $db.

in my script. The script seems executing the query 4 times whenever it's called,
since I get 4 newly inserted records everytime execute the script. Usually, PHP4
will not do that. It executes query exactly once as it should be.
(There is no loop, of course. It's a rather simple registration script and have
no loop around pg_exec(). I even checked by printing letters to see if code
around pg_exec() is executed multiple times. PHP does not call print() multiple
times, so the problem should be at the line where pg_exec() is executed)

Does anyone have this problem with libpq? psql? or others?
If you do, please let me know.
(If you know what could be the cause, please let me know too)

Thanks a lot.
--
Yasuo Ohgaki

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Christopher Kings-Lynne 2001-04-02 01:31:43 RE: [HACKERS] Error in the date field (with NULL value...).Thanks!
Previous Message Bruce Momjian 2001-04-01 00:58:17 Re: Re: [SQL] Re: pg_dump potential bug -UNIQUE INDEX on PG_SHADOW Dont!! HELP

Browse pgsql-general by date

  From Date Subject
Next Message Justin Clift 2001-04-01 10:38:12 Re: Need PostgreSQL startup scripts
Previous Message Pluto 2001-04-01 08:38:35 Re: Data access permission?