COMMIT PREPARED(7) PostgreSQL 9.2.7 Documentation COMMIT PREPARED(7)NAME
COMMIT_PREPARED - commit a transaction that was earlier prepared for two-phase commit
SYNOPSIS
COMMIT PREPARED transaction_id
DESCRIPTION
COMMIT PREPARED commits a transaction that is in prepared state.
PARAMETERS
transaction_id
The transaction identifier of the transaction that is to be committed.
NOTES
To commit a prepared transaction, you must be either the same user that executed the transaction originally, or a superuser. But you do not
have to be in the same session that executed the transaction.
This command cannot be executed inside a transaction block. The prepared transaction is committed immediately.
All currently available prepared transactions are listed in the pg_prepared_xacts system view.
EXAMPLES
Commit the transaction identified by the transaction identifier foobar:
COMMIT PREPARED 'foobar';
COMPATIBILITY
COMMIT PREPARED is a PostgreSQL extension. It is intended for use by external transaction management systems, some of which are covered by
standards (such as X/Open XA), but the SQL side of those systems is not standardized.
SEE ALSO
PREPARE TRANSACTION (PREPARE_TRANSACTION(7)), ROLLBACK PREPARED (ROLLBACK_PREPARED(7))
PostgreSQL 9.2.7 2014-02-17 COMMIT PREPARED(7)
Check Out this Related Man Page
ROLLBACK(7) SQL Commands ROLLBACK(7)NAME
ROLLBACK - abort the current transaction
SYNOPSIS
ROLLBACK [ WORK | TRANSACTION ]
DESCRIPTION
ROLLBACK rolls back the current transaction and causes all the updates made by the transaction to be discarded.
PARAMETERS
WORK
TRANSACTION
Optional key words. They have no effect.
NOTES
Use COMMIT [commit(7)] to successfully terminate a transaction.
Issuing ROLLBACK when not inside a transaction does no harm, but it will provoke a warning message.
EXAMPLES
To abort all changes:
ROLLBACK;
COMPATIBILITY
The SQL standard only specifies the two forms ROLLBACK and ROLLBACK WORK. Otherwise, this command is fully conforming.
SEE ALSO
BEGIN [begin(7)], COMMIT [commit(7)], ROLLBACK TO SAVEPOINT [rollback_to_savepoint(7)]
SQL - Language Statements 2010-05-14 ROLLBACK(7)
with my script i am trying to read what all the transactions happened that day like create,delete,update,etc. I also need to get the userid of that transaction. Once I login to my test machine, i loginto test env doing
su - env6. So i cannot get id as my login id. Any ideas??
Gundu (2 Replies)
I am getting the following message in /var/adm/messages
Its harm to the system ?? in solaries 5.5.1
unix: WARNING: correctable error from pci0 (upa mid 0) during dvma read transaction.
unix:
unix: AFSR=40a200ff.80800000 AFAR=00000000.0132bee0,
unix: double word offset=4, SIMM DIMM1 id 31.... (1 Reply)
Hi
I am new to this forum.I need a help in the following:
We receve pipe delimited file with
transaction ID,tran_date,Quest_cd,Ans_cd,ans_value.
Same transaction ID can be repeated with different quest_cd and ans_cd.
Basically I need to check if a perticular pair of quest_cd and ans_cd... (1 Reply)
Hi
I am new to this forum.I need a help in the following:
We receve pipe delimited file with
transaction ID,tran_date,Quest_cd,Ans_cd,ans_value.
Same transaction ID can be repeated with different quest_cd and ans_cd.
Basically I need to check if a perticular pair of quest_cd and ans_cd (say... (13 Replies)
Hi guys, I'm hoping you can help me here. I've knocked up a script that looks at a (huge) log file, and pulls from each line the hour of each transaction and how long each transaction took.
The data is stored sequentially as:
07:01 blah blah blah 12456 blah
07:03 blah blah blah 234 blah... (4 Replies)
Hello Folks,
i am facing some weired issues.
case is like this :-
initially i was on AIX 5.3
i have installed filesets related to my application and those were in APPLY state.(COMMIT is set as NO)
Then i have taken lslpp -l| grep -i <apps name>
in that i confirmed whether the filesets are... (1 Reply)
Hi. I do not know how to compare numbers and need help. In my script I have to figure the MAX, MIN, & Avg. Sales amounts.
Please help me.
In the code, "transaction" is a counter.
#!/bin/bash
clear
transaction=0
sales=0
total=0
while test $sales
... (9 Replies)
Wondering if someone can help with my task of identifying missing detail lines in transactions.
I have a flat file that contains transaction header, transaction detail, and transaction trailer lines. These lines are identified with a 5-character line identifier "THEAD", "TDETL", and "TTAIL" at... (2 Replies)
We are getting below error when processing a transaction through ESB.
I work for SOA admin and checked the JCA connection is working fine also code also working fine in other envs.
An unhandled exception has been thrown in the ESB system. The exception reported is:... (1 Reply)
Hi guys, I was wondering if someone can give me a hand in helping me append transaction header line in a file at the end of the transaction detail lines.
Basically, I have a file that looks like this:
FHEAD File1
THEAD TRANS1-blah
TDETL HI1
TDETL HI2
TDETL HI3
TTAIL TRANS1-blah
THEAD... (3 Replies)
i have the following lines
T2345
T3435 - bugfixed and running
T5654 fixed and committed
T34541:- fixed and committed
i need to extract only the T part (eg:T2345) ,ie i dont want any special characters after it.
i have been trying with grep and egrep but with no luck.
pls help (11 Replies)
HI,
Can anyone explain me the concept behind ZFS transactional semantics (either a transaction is entirely commited or it is not)? so data and disk failures are reduced. (5 Replies)
Here is a shell for printing committed person's:
1. Revision number
2. Name
3. Date of commit
4. Files committed.
5. committing comment
6. Date
I just made for my usage. May be helpful for you too.
Do as follows.
create a file
$ vi svn_get_user_committed_files_details.sh
press i... (3 Replies)
Hi,
I have an issue where i need to lookup in a given transaction file and if the same transaction is found in another file, then i need to replace a few columns with some other value.
Finally, the changed and unchanged lines must be printed and stored in the same source file.
for example... (5 Replies)
Hi All,
I have transaction in one file.I want to match that to another file and find the number of time the transaction is available on the other file.I need to take each record from TRANSFILE and match that with SPEND FILE and find the number of counts of the transaction
TRANSFILE:
... (4 Replies)