9 More Discussions You Might Find Interesting
1. Programming
#define abc '\xE8' (7 Replies)
Discussion started by: kamlesh33
7 Replies
2. Shell Programming and Scripting
what exactly $? and $# means ? (1 Reply)
Discussion started by: mail2sant
1 Replies
3. Shell Programming and Scripting
Hi,
I have seen in some ksh script, that we are executing shell scripts inside other shell script as
. variable.sh
What is . here? Their is space between . and variabloe. And why we are not executing it like ./variable.sh? I know that . signifies current directory , but what its... (2 Replies)
Discussion started by: jatanig
2 Replies
4. Shell Programming and Scripting
I have a script like
select * from table
!!
what those exclamation marks mean (4 Replies)
Discussion started by: vasuarjula
4 Replies
5. UNIX for Dummies Questions & Answers
I can not find out what the %U means in the following command:
ooffice -calc %U (2 Replies)
Discussion started by: borobudur
2 Replies
6. UNIX for Advanced & Expert Users
:) Hi,
In some script i got these regular expression
like ,
n=$#
and
for i in $*
can anybody let me know, what does it means (5 Replies)
Discussion started by: deb.simply
5 Replies
7. UNIX for Dummies Questions & Answers
Can you please tell me what this means?
use grep to find from the file myfile.txt all lines containing the sequence tt but not more 2 ts?
I have no idea. (2 Replies)
Discussion started by: rushhour
2 Replies
8. Shell Programming and Scripting
hey, what's $$varname in a script? I used to see $varname only. search on google didn't help. thanks. (4 Replies)
Discussion started by: patiobarbecue
4 Replies
9. UNIX for Dummies Questions & Answers
Hi All,
Can you please explain wats the meaning of this
$?
in unix
Thanks (2 Replies)
Discussion started by: mathur
2 Replies
SAVEPOINT(7) SQL Commands SAVEPOINT(7)
NAME
SAVEPOINT - define a new savepoint within the current transaction
SYNOPSIS
SAVEPOINT savepoint_name
DESCRIPTION
SAVEPOINT establishes a new savepoint within the current transaction.
A savepoint is a special mark inside a transaction that allows all commands that are executed after it was established to be rolled back,
restoring the transaction state to what it was at the time of the savepoint.
PARAMETERS
savepoint_name
The name to give to the new savepoint.
NOTES
Use ROLLBACK TO SAVEPOINT [rollback_to_savepoint(7)] to rollback to a savepoint. Use RELEASE SAVEPOINT [release_savepoint(7)] to destroy a
savepoint, keeping the effects of commands executed after it was established.
Savepoints can only be established when inside a transaction block. There can be multiple savepoints defined within a transaction.
EXAMPLES
To establish a savepoint and later undo the effects of all commands executed after it was established:
BEGIN;
INSERT INTO table1 VALUES (1);
SAVEPOINT my_savepoint;
INSERT INTO table1 VALUES (2);
ROLLBACK TO SAVEPOINT my_savepoint;
INSERT INTO table1 VALUES (3);
COMMIT;
The above transaction will insert the values 1 and 3, but not 2.
To establish and later destroy a savepoint:
BEGIN;
INSERT INTO table1 VALUES (3);
SAVEPOINT my_savepoint;
INSERT INTO table1 VALUES (4);
RELEASE SAVEPOINT my_savepoint;
COMMIT;
The above transaction will insert both 3 and 4.
COMPATIBILITY
SQL requires a savepoint to be destroyed automatically when another savepoint with the same name is established. In PostgreSQL, the old
savepoint is kept, though only the more recent one will be used when rolling back or releasing. (Releasing the newer savepoint will cause
the older one to again become accessible to ROLLBACK TO SAVEPOINT and RELEASE SAVEPOINT.) Otherwise, SAVEPOINT is fully SQL conforming.
SEE ALSO
BEGIN [begin(7)], COMMIT [commit(7)], RELEASE SAVEPOINT [release_savepoint(7)], ROLLBACK [rollback(7)], ROLLBACK TO SAVEPOINT [roll-
back_to_savepoint(7)]
SQL - Language Statements 2010-05-14 SAVEPOINT(7)