ROLLBACK PREPARED(7) PostgreSQL 9.2.7 Documentation ROLLBACK PREPARED(7)NAME
ROLLBACK_PREPARED - cancel a transaction that was earlier prepared for two-phase commit
SYNOPSIS
ROLLBACK PREPARED transaction_id
DESCRIPTION
ROLLBACK PREPARED rolls back a transaction that is in prepared state.
PARAMETERS
transaction_id
The transaction identifier of the transaction that is to be rolled back.
NOTES
To roll back 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 rolled back immediately.
All currently available prepared transactions are listed in the pg_prepared_xacts system view.
EXAMPLES
Roll back the transaction identified by the transaction identifier foobar:
ROLLBACK PREPARED 'foobar';
COMPATIBILITY
ROLLBACK 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)), COMMIT PREPARED (COMMIT_PREPARED(7))
PostgreSQL 9.2.7 2014-02-17 ROLLBACK PREPARED(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)
Hi,
I have 5 sub processes which are updating and commiting different records of a single table.I have a problem here.I want to rollback all the transaction if any one of processes fails.Can any one of you gurus suggest how to go about it ?
Thanks
Tushar Johri (3 Replies)
Hi,
I am using few ISQL statements to update and delete from a few tables in sybase, now i want to roll back the transaction when any of the statements fail.How i can i capture these errors in the shell scripts.Please advise.
Thanks,
Gopi (4 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 (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)
Hi
I have to delete 18 characters from my file names from back side.
i mean if file name is abcde123456
then i have to delete 6 characters from back and i need file name as abcde.
Please help (4 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)
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)
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)
Can some one help me related to .sql file issue.
I have a .sqlfile and tried to read the file thru unix. In the .sqlfile I have error rows as well and when error comes I dont want to proceed further and need to roll back all the transactions.
sample .sql file below
insert into
test... (2 Replies)
Guys,
I need to roll up data within the file and build a new file with the output and the same format as the original file.
The data should be rolled up for each unique combination of ord,line,date and hour.. The last column appr is always " "
Below is the format
Original File:
... (8 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)