On 2013-01-14 10:45, John R Pierce wrote:
On 1/14/2013 12:15 AM, Condor wrote:
When I call the function from php everything it's seems to work,
but some time modify records just disappear. I don't have any ideas
for the moment
what is the problem in my postgresql or in my php code. I'm sure
there was a recording was made.
I run in middle night vacuum, reindex on tables and vacuum analyze;
I check my postgresql logs, but no any errors. I check the php logs,
but no errors.
My vacuum also did not log any error messages. This problem happened
one or two times per month
and I can't track him. Is not happened very often. My question is:
Is there any chance this function
to stay opened or some thing like that and on the night when vacuum
is started to rollback changes ?
Also any other suggestions are welcome.
are you calling these functions within the context of a larger
transaction, or just as standalone statements without an epxlicit
BEGIN TRANSACTION ? if they are being called from within a
transaction, and something else in that transaction triggers a
rollback, then ALL of the changes made in that transaction go away.
once a transaction is committed, nothing can undo it, other than
restoring a backup or changing the data explicitly in another
transaction, or something.
It's a standalone statements without BEGIN TRANSACTION. An update is
easy to explain with another
but insert with missing row and there is no DELETE command in whole
code and no one other have access to server.
No any error logs, only access log system insert that user make the
changes (no info what changes).
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
