From: | Paramveer(dot)Singh(at)trilogy(dot)com |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | postgres error handling mechanism |
Date: | 2004-08-15 02:32:14 |
Message-ID: | OFE784396A.DE610B0A-ON86256EF1.000D7DA3@trilogy.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi!
I was looking into the postgres error handling mechanism, and the
documentation states that the present mechanism is primitive.
I quote "whenever the parser, planner/optimizer or executor decide that a
statement cannot be processed any longer,
the whole transaction gets aborted and the system jumps back into the main
loop to get the next command from the client application."
Also, it states " it is possible that the database server is in an
inconsistent state at this point so returning to the upper executor or
issuing
more commands might corrupt the whole database"
(Postgres 7.4.3 docs, 37.9 Errors and messages)
Since postgres aborts the transaction compeletely, why would it be ever
left in an inconsistant state in such an event?
thanks
paraM
From | Date | Subject | |
---|---|---|---|
Next Message | CSN | 2004-08-15 04:17:09 | Re: idle processes |
Previous Message | Chris Smith | 2004-08-15 01:16:17 | Re: PostgreSQL 8.0 Feature List? |