END(7) PostgreSQL 9.2.7 Documentation END(7)NAME
END - commit the current transaction
SYNOPSIS
END [ WORK | TRANSACTION ]
DESCRIPTION
END commits the current transaction. All changes made by the transaction become visible to others and are guaranteed to be durable if a
crash occurs. This command is a PostgreSQL extension that is equivalent to COMMIT(7).
PARAMETERS
WORK, TRANSACTION
Optional key words. They have no effect.
NOTES
Use ROLLBACK(7) to abort a transaction.
Issuing END when not inside a transaction does no harm, but it will provoke a warning message.
EXAMPLES
To commit the current transaction and make all changes permanent:
END;
COMPATIBILITY
END is a PostgreSQL extension that provides functionality equivalent to COMMIT(7), which is specified in the SQL standard.
SEE ALSO BEGIN(7), COMMIT(7), ROLLBACK(7)PostgreSQL 9.2.7 2014-02-17 END(7)
Check Out this Related 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)
Hi,
I have to always select last portion of a block identified by 2 fixed keywords
which repeats in a file for eg
START
....
...
END
START
....
...
END
START
....
...
END (9 Replies)
I am trying to pass 2 shell variable's ("START" and "END") define earlier in the script to this awk statement, but i can't seem to pass it on. PLs help.
set START = xxxx
set END = yyyy
set selected_file = `awk '/$START/,/$END/' filename` (24 Replies)
I have a command that will produce about 20 lines of output
what is the best way to store some of the results to certain variables?
let's say command output shows
--------------------------------
first 13@home
yahoo 33@never
usa 55 ussr
user logged in... (10 Replies)
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,
I need to create a script that does the following:
1. Read the file for the occurrences of "EXECUTE" and "END" strings.
There will be several occurrences of EXECUTE and END strings on the file.
2. The resulting lines in #1, needs to be searched for the word... (11 Replies)
Hi
I have a flat file looking this
QWER 2:35 7044 00001 ROUT 1188 EA SS
ASD 2:36 7044 00010 ROUT
BSD 2:37 7044 00011 ROUT
END
QWER 3:35 7044 00011 ROUT 1088 EA SS
ASD 3:36 7044 00010 ROUT
BSD 3:37 7044 00011 ROUT... (9 Replies)
i have a file with contents
test123
qwwww
sdsad
asdasd
asdad
adadsw
sasfar
sfaf
a
afasf
OPERATION END
i need to grep all the contents from test123 and OPERATION END.Can somebody help me how to do it ? (7 Replies)
Delete everything comes in between /* & */.
Current File:
====================
create or replace procedure test421
is
begin
/*
---sasasas/*dsdsds
*/
dbms_output.put_line('SAURABH');
END;
To be File:
===================
create or replace procedure test421
is
begin... (10 Replies)
Hi,
There are total 100 files in the backup directory with the name format as below:
prod_bkp_140611_13_30_05.txt
prod_bkp_140611_14_30_05.txt
prod_bkp_140611_15_30_05.txt
prod_bkp_140611_16_30_05.txt
How to use array variables (in perl) to get list of names of the above files ? (13 Replies)
Using awk, is there a way to remove newlines in strings that don't contain 1_ at the beginning, but without setting RS="1_" in the BEGIN section and without using a END section as well?
input:
1_this is line 1
aaaaaaaa
bbbb
1_this is line 2
cccc
1_this is line 3
dddddddddddddd... (7 Replies)
I have the below code which calculates the time difference between src and dst from a large trace file. The code works for a given source and destination. However, I want to automate the code to go over any src and destination. The format of the source is like that: X.Y where x is always =2 and Y... (10 Replies)
I have this END section in an awk script:
END {
for (j in littlebin)
{
print (j, int(log(j)/log(2)) , littlebin)
lbsum+=littlebin
}
for (i in bins)
... (6 Replies)
I want to count lines of a file using AWK (only) and not in the END part like this awk 'END{print FNR}' because I want to use it.
Does anyone know of a way?
Thanks a lot. (7 Replies)