ALTER TRIGGER(7) PostgreSQL 9.2.7 Documentation ALTER TRIGGER(7)NAME
ALTER_TRIGGER - change the definition of a trigger
SYNOPSIS
ALTER TRIGGER name ON table_name RENAME TO new_name
DESCRIPTION
ALTER TRIGGER changes properties of an existing trigger. The RENAME clause changes the name of the given trigger without otherwise changing
the trigger definition.
You must own the table on which the trigger acts to be allowed to change its properties.
PARAMETERS
name
The name of an existing trigger to alter.
table_name
The name of the table on which this trigger acts.
new_name
The new name for the trigger.
NOTES
The ability to temporarily enable or disable a trigger is provided by ALTER TABLE (ALTER_TABLE(7)), not by ALTER TRIGGER, because ALTER
TRIGGER has no convenient way to express the option of enabling or disabling all of a table's triggers at once.
EXAMPLES
To rename an existing trigger:
ALTER TRIGGER emp_stamp ON emp RENAME TO emp_track_chgs;
COMPATIBILITY
ALTER TRIGGER is a PostgreSQL extension of the SQL standard.
SEE ALSO
ALTER TABLE (ALTER_TABLE(7))
PostgreSQL 9.2.7 2014-02-17 ALTER TRIGGER(7)
Check Out this Related Man Page
DROP TRIGGER(7) SQL Commands DROP TRIGGER(7)NAME
DROP TRIGGER - remove a trigger
SYNOPSIS
DROP TRIGGER name ON table [ CASCADE | RESTRICT ]
INPUTS
name The name of an existing trigger.
table The name (optionally schema-qualified) of a table.
CASCADE
Automatically drop objects that depend on the trigger.
RESTRICT
Refuse to drop the trigger if there are any dependent objects. This is the default.
OUTPUTS
DROP TRIGGER
The message returned if the trigger is successfully dropped.
ERROR: DropTrigger: there is no trigger name on relation "table"
This message occurs if the trigger specified does not exist.
DESCRIPTION
DROP TRIGGER will remove an existing trigger definition. To execute this command the current user must be the owner of the table for which
the trigger is defined.
EXAMPLES
Destroy the if_dist_exists trigger on table films:
DROP TRIGGER if_dist_exists ON films;
COMPATIBILITY
SQL92 There is no DROP TRIGGER statement in SQL92.
SQL99 The DROP TRIGGER statement in PostgreSQL is incompatible with SQL99. In SQL99, trigger names are not local to tables, so the command
is simply DROP TRIGGER name.
SEE ALSO
CREATE TRIGGER [create_trigger(7)]
SQL - Language Statements 2002-11-22 DROP TRIGGER(7)
This is my first posting. I am not a very sophisticated UNIX user.
I am trying to have an existing control string trigger another process at 4:00 p.m. My command looks like this on System V.4 UNIX.
at -f /scriptname 16:00
I have added the users to /etc/cron.d/at.allow and at.deny is... (5 Replies)
Hello -
I have a file that has the something like the following :
REM CREATE TABLE lots of text
REM table specifc creation text ;
REM ALTER TABLE lots of text
REM text specific to the the alter command
REM could be more lines of text;
What I need is to get all the lines for the ALTER... (2 Replies)
I am running the example from the following webpage:
MySQL :: MySQL 5.0 Reference Manual :: 12.1.11 CREATE TRIGGER Syntax
and the problem is that triggers cannot be defined for some reason:
CREATE DATABASE IF NOT EXISTS triggertest;
USE triggertest;
CREATE TABLE test1(a1 INT);
CREATE TABLE... (3 Replies)
hi
I have posted it earlier but i was unable to put my exact problem.This time posting in parts.
I have a text file which i had transferred to UNIX.It has strings like:
alter table table_name add (column_name);
as well as modify options.
now i need to read the table name between alter... (3 Replies)
I want to copy column no 3 to the end of column
example :
alter table RECOVER_USR.MPULKIXD rename to
alter table RECOVER_USR.CS_ADV_PROMO rename to
alter table RECOVER_USR.BCH_HISTORY_TABLE rename to
alter table BILLOPS.HISHAM_DATAPLUS_FINAL rename to
alter table... (8 Replies)
Hello Team,
I have a script in which more than 500 trigger statemetns are written.
i need to filter all lines from that script file which containts "CREATE TRIGGER" word in each line
is it possible using linux commands??
example:
CREATE TRIGGER S1.T1
.................. (10 Replies)
How do you grep 'select * from table_name' string from a script if the select * and from table_name are on 2 different lines ? like
select *
from table_name
Any help would be greatly appreciated !!!
Thanks
RDR (4 Replies)
currently I have process from a raw file to this stage
ALTER TABLE "EXCEL_ADMIN"."TC_TXN_VOID" ADD CONSTRAINT "PK_TC_TXN_VOID" PRIMARY KEY ("TC_TXN_IID")
ALTER TABLE "EXCEL_ADMIN"."TC_TXN_AMT" ADD CONSTRAINT "PK_TC_TXN_AMT" PRIMARY KEY ("TC_TXN_AMT_IID")
ALTER TABLE... (10 Replies)
Hi,
I have a trigger file which looks like this abcdefgh_YYYYMMDD.trg The YYYYMMDD is the year, month and the date. So for example today the trigger file would be abcdefgh_20130703.trg similarly tomorrow it would be abcdefgh_20130704.trg
I need to write a script to check if the trigger file... (2 Replies)
I have a below command
ALTER TABLE `abc` ADD PARTITION ( PARTITION 20130613 VALUES less than (DAY('13')));
Below is requirement
It runs in Loop
as DAY start with 13 and end with 100 along with this of counter "20130613" also increases per command
as the next command should be
... (8 Replies)
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... (5 Replies)
Hi Experts,
We are developing a script which will wait for the trigger file(with datetime in the trigger file name).
But the problem is when I use 'while' loop to wait for the file, it waits for the filename with wilcard in it that is wait for 'Trigger*.done' file. :eek:
Below is the script
... (4 Replies)
Hi guys,
I have written a script that waits for a trigger file.
Then checks the time of the trigger.
if the trigger finished between 8pm and midnight then runs a job.
else it waits till 1am then runs a different job.
I am still very new to scripting so any suggestions to improve my... (4 Replies)
Hi Guys,
I am having a sql script file which does below operations
ALTER TABLE M1
EXCHANGE PARTITION FOR (TO_DATE('&1','dd-MON-yyyy'))
WITH TABLE &2
INCLUDING INDEXES;
i need to pass variables in such a way that if i pass start date and end date as parameter , something like my... (2 Replies)