Linux and UNIX Man Pages

Linux & Unix Commands - Search Man Pages

commit_prepared(7) [centos man page]

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)
Man Page

15 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

user id

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)
Discussion started by: gundu
2 Replies

2. IP Networking

WARNING: correctable error from pci0 (upa mid 0) during dvma read transaction.

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)
Discussion started by: visveswaran
1 Replies

3. Shell Programming and Scripting

Need help in file validation by shell script

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)
Discussion started by: srichakra
1 Replies

4. UNIX for Dummies Questions & Answers

Need help in Unix shell script

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)
Discussion started by: srichakra
13 Replies

5. Shell Programming and Scripting

Speeding up processing a file

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)
Discussion started by: dlam
4 Replies

6. AIX

Upgrade from AIX 5.3 to 6.1

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)
Discussion started by: harsh_mulay
1 Replies

7. Shell Programming and Scripting

Where to being Comparing numbers?

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)
Discussion started by: Ccccc
9 Replies

8. Shell Programming and Scripting

Help identifying transactions with no detail lines

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)
Discussion started by: rookie12
2 Replies

9. UNIX and Linux Applications

Got Errors while sending a transaction through ESB

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)
Discussion started by: KuldeepSinghTCS
1 Replies

10. Shell Programming and Scripting

Append transaction header lines to same transaction's detail lines

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)
Discussion started by: rookie12
3 Replies

11. Shell Programming and Scripting

help with grep command

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)
Discussion started by: born
11 Replies

12. Solaris

Concept of ZFS transaction semantics

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)
Discussion started by: Revathi@1
5 Replies

13. Shell Programming and Scripting

gets all files details committed to svn by a particular user [or all users] since a particular date

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)
Discussion started by: linuxadmin
3 Replies

14. Shell Programming and Scripting

Lookup in another file and conditionally modify it inline

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)
Discussion started by: mansoorcfc
5 Replies

15. UNIX for Beginners Questions & Answers

Match file and find count

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)
Discussion started by: arunkumar_mca
4 Replies