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
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 |
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? |