update trigger

Special Forums UNIX and Linux Applications update trigger

09-17-2010

Registered User

1, 0

Join Date: Sep 2010

Last Activity: 17 September 2010, 10:03 AM EDT

Posts: 1

Thanks Given: 0

Thanked 0 Times in 0 Posts

update trigger

hi all,

i hope i am posting this /beginner) question in the right forum:
i want to create an update trigger, which rolls back a transaction if a record of a table is updated. the table has - amongst others - a field 'statusid' - if a record in this table has the statusid X and it is attempted to update this field to Y, the trigger should rollback the transaction.

thanks for every hint or advise in advance!
k

---------- Post updated at 09:03 AM ---------- Previous update was at 08:23 AM ----------

I was able to help myself

kalinkula

View Public Profile for kalinkula

Find all posts by kalinkula

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

To trigger script on particular instance

Hi Guys, I have a main_script.sh which runs every day and scheduled in crontab. in the main script i read data from config file test.config apple mango orange main_script.sh for i in `cat test.config` do if then echo 'Apple'

2. Shell Programming and Scripting

Help not trigger the trap

mainpid=$$ (trap "echo timeout" SIGTERM SIGKILL SIGINT; sleep 5; kill $mainpid) & watchdogpid=$! sleep 10 #do something kill $watchdogpid I design a timeout function script I don't see the echo "timeout" is on the screen

3. Programming

MYSQL - trigger update on record insert or update

Right I have a MYSQL database with table1 with 3 columns, colA, colB and colC. I want to combine the data in the 3 columns into a 4th column names col_comb. Here's the SQL command that works: UPDATE table1 SET `col_comb` = CONCAT( `colA` , ' - ', `colB` , ', ', `colC` ); So now I want this...

4. OS X (Apple)

AC to DC trigger pulse for AudioScope.sh.

Hi all... Has _below_ ever been done in UNIX shell scripting before? (I have done this easily in Python but this is using purely the shell.) The DEMO version IS built and has been tested. Pre-amble... I now need at least one control pulse for the AudioScope.sh when in PURELY audio I/O mode,...

5. Programming

MYSQL - trigger to track changes to fields on update

So I have a php web application that allows updating of records. I would like to track the changes of only the fields that have changed. There are plenty of how to's that involve recreating the original row in a separate table with an additional time/date stamp column but I think this is a big...

6. Shell Programming and Scripting

Trigger functionality in Unix

Hi, I want a script , which searches the log for the term/phrase "JFSnapshotService::systemSnapshot: Starting data capture. This may take awhile depending upon system workload." and if there is some logging like this, it has to mail me that this data capture process is happening., Below is...

7. Shell Programming and Scripting

Update trigger for unix file (solaris)

Hello, from log error file of process that i's updating in append mode, i need to capture the new entries for every day. How i can know and save only the new errors? This it's a sample of error log file (oas report server engine) thanks and regards Fran

8. HP-UX

Control-M Job trigger

Hi, I'm totally new in Control-M and I really need some help. Here's my problem. I need to make job X from a server trigger job Y from a different server where job X must receive a confirmation first before execution. :confused: I really have no idea on how to do that so can you please give...

9. Shell Programming and Scripting

Trigger with condition

If test.ksh is successful then I have a sequence of script which needs to execute automatically. Is it possible to capture the return code to execute the next script automatically? what is better way of doing this.

10. Shell Programming and Scripting

Trigger Enter

Hello, I need to trigger every time enter has been clicked while some one on terminal i tried to googleit but with out result any idea ?? thanks in advance

LEARN ABOUT SUSE

create_constraint_trigger

CREATE CONSTRAINT 
TRIGGER(7)					   SQL Commands 				      CREATE CONSTRAINT TRIGGER(7)

NAME

       CREATE CONSTRAINT TRIGGER - define a new constraint trigger

SYNOPSIS

       CREATE CONSTRAINT TRIGGER name
	   AFTER event [ OR ... ]
	   ON table_name
	   [ FROM referenced_table_name ]
	   { NOT DEFERRABLE | [ DEFERRABLE ] { INITIALLY IMMEDIATE | INITIALLY DEFERRED } }
	   FOR EACH ROW
	   EXECUTE PROCEDURE funcname ( arguments )

DESCRIPTION

       CREATE  CONSTRAINT TRIGGER creates a constraint trigger. This is the same as a regular trigger except that the timing of the trigger firing
       can be adjusted using SET CONSTRAINTS [set_constraints(7)].  Constraint triggers must be AFTER ROW triggers. They can be  fired	either	at
       the  end of the statement causing the triggering event, or at the end of the containing transaction; in the latter case they are said to be
       deferred. A pending deferred-trigger firing can also be forced to happen immediately by using SET CONSTRAINTS.

PARAMETERS

       name   The name of the constraint trigger. This is also the name to use when modifying the trigger's behavior using SET	CONSTRAINTS.   The
	      name cannot be schema-qualified -- the trigger inherits the schema of its table.

       event  One of INSERT, UPDATE, or DELETE; this specifies the event that will fire the trigger. Multiple events can be specified using OR.

       table_name
	      The (possibly schema-qualified) name of the table in which the triggering events occur.

       referenced_table_name
	      The  (possibly schema-qualified) name of another table referenced by the constraint. This option is used for foreign-key constraints
	      and is not recommended for general use.

       DEFERRABLE

       NOT DEFERRABLE

       INITIALLY IMMEDIATE

       INITIALLY DEFERRED
	      The default timing of the trigger.  See the CREATE TABLE [create_table(7)] documentation for details of these constraint options.

       funcname
	      The function to call when the trigger is fired. See CREATE TRIGGER [create_trigger(7)] for details.

       arguments
	      Optional argument strings to pass to the trigger function. See CREATE TRIGGER [create_trigger(7)] for details.

COMPATIBILITY

       CREATE CONSTRAINT TRIGGER is a PostgreSQL extension of the SQL standard.

SEE ALSO

       CREATE TRIGGER [create_trigger(7)], DROP TRIGGER [drop_trigger(7)], SET CONSTRAINTS [set_constraints(7)]

SQL - Language Statements					    2010-05-14					      CREATE CONSTRAINT TRIGGER(7)

UNIX and Linux Applications