Data dodania Pytanie
2018-01-21 08:01 How to create a trigger on after insert without returning NEW in postgres? »
Why do it after insertion? How write something like this: CREATE FUNCTION update_auto_dates() RETURNS trigger AS $update_auto_dates$ BEGIN ...
(1) odpowiedzi
2018-01-08 18:01 Triggers on PostgreSQL Streaming Replication Standby »
I have a primary and a standby PostgreSQL 9.4 database. They replicate via streaming replication. I would like to have the standby database notify an ...
(0) odpowiedzi
2018-01-06 18:01 Table is mutating. Trigger may not see it (Even on different tables) »
I have two tables: Group and Schedule. The Group table consists of columns: Group_Name, No_of_member. The Schedule table consists of column: Group_Na...
(1) odpowiedzi
2018-01-05 20:01 Why isn't this trigger good? »
The problem is as follows: a maximum of 50 employees is allowed in any department My teacher said that the trigger below isn't the solution but I did...
(1) odpowiedzi
2017-12-28 13:12 A unhandled exception in a "after create" trigger preventing create »
I have an AFTER CREATE trigger on my schema that raises an exception; I'm trying to create a table. I understand that an unhandled exception could cau...
(3) odpowiedzi
2017-12-26 18:12 A checkbox click event is interrupted to run code, but $.trigger('click') will only be recognized in Chrome, not Firefox. Why? »
I have a convoluted scheme to interrupt a checkbox click event, so I can run some javascript/jQuery code before the click event is completed (ie. box ...
(1) odpowiedzi
2017-12-24 12:12 Do DB trigger conditions improve performance? »
I know that a DB trigger condition can only be a SQL expression and that it cannot include a subquery. However, inside the trigger code it is possible...
(1) odpowiedzi
2017-12-04 11:12 How to write a MySQL before insert trigger to insert data in a table? »
I need to create a trigger for when I insert data in the first table to be able to insert in the second some data related to the first one. CREATE TR...
(1) odpowiedzi
2017-11-25 01:11 PL/SQL ORACLE: Trigger updates on delete »
I am trying to make a trigger that increases the booked value and decreases the available value whenever new record is inserted inside the table ticke...
(1) odpowiedzi
2017-11-21 11:11 Select data from db table 1 and insert it into another db table 2 in php »
I have two different Databases, names: dbtest: Table 1 dbtest2: Table 2 I want to select all the data and new entries from dbtest Table 1 to dbt...
(4) odpowiedzi
2017-11-16 22:11 What is the proper way to create an update trigger with a variable getting value from the same table? »
I'm creating a update trigger where an employee can never have a salary that is greater than the president's. However I need to subquery the president...
(2) odpowiedzi
2017-10-23 17:10 Sql Oracle 12c Trigger »
I need some help. I'm trying to create a Trigger that execute a procedure whenever insert, delete or update operations are done on a specific table. T...
(1) odpowiedzi
2017-09-07 05:09 DataTables with FixedColumns extension breaks jQuery trigger in table header »
How do you get jQuery triggers to work in the column header when using the FixedColumns extension for DataTables? I'm using DataTables with the Fixed...
(1) odpowiedzi
2017-08-26 14:08 How to enable trigger over all tables that has foreign key reference to another table in oracle 11g? »
In the database i have one base table, named Organization that most of tables has foreign key to that. assume this below ERD: As you seen Organizat...
(1) odpowiedzi
2017-08-25 17:08 Accessing current row values in a trigger »
I created a function will insert a value into a json for each row inserted in a table. But when I execute the insert, it says me that the column does...
(1) odpowiedzi
2017-08-20 16:08 Audit trigger (Statement Level) storing identifier of inserted/updated/deleted rows »
I have the following small MVWE for a basic micro-auditing system which works fine but lacks a functionality: DROP TABLE IF EXISTS audit CASCADE; CRE...
(0) odpowiedzi
2017-08-05 15:08 Trigger behaving strangely »
I'm making a Database that needs to store data for a school system and for certain activities minors need a permit. I have this trigger that checks th...
(1) odpowiedzi
2017-07-17 13:07 How can I create constraint using subquery in sql? »
Here is my table game : create table game ( h_team number, a_team number, p_date date ); Condition to be followed: Every team plays ...
(1) odpowiedzi
2017-07-13 16:07 Trigger to update week of the year »
I want to write a trigger so that when decom_date is inserted or updated the week of the year is updated to the corresponding value. This is what I h...
(1) odpowiedzi
2017-07-09 20:07 Oracle Audit table using trigger »
I need to create a trigger in oracle 11g for auditing a table . I have a table with 16 columns that need to be audited. For every new insert into a ...
(1) odpowiedzi
2017-07-04 09:07 How to create a trigger that wont hold the entire transaction till it complete? »
There is a procedure which have insert operation in middle for a table. The table contain a trigger and because of that the entire transaction getting...
(2) odpowiedzi
2017-06-07 23:06 PostgreSQL trigger prevents another one to work »
Suppose we have: create table T ( id bigserial primary key , a int , b int , c int ); I want c to be always equals to a+b and I want t...
(1) odpowiedzi
2017-05-22 11:05 postgres trigger creates index: BEFORE INSERT ON hides one row »
I have a trigger AFTER INSERT ON mytable that calls a function CREATE OR REPLACE FUNCTION myfunction() RETURNS trigger AS $BODY$ DECLARE ...
(1) odpowiedzi
2017-05-21 18:05 PL/SQL ORACLE triggers »
I'm trying to create a trigger that when you insert an employee in the company, assign a commission of 0.10 if it is from department 80. This is what ...
(1) odpowiedzi
2017-05-21 12:05 Trying to create a trigger based on day and time »
I'm trying to create a trigger which would prevent insertions, updates and deletions if done outside office hours(i.e, other than 8-18 hours or sunday...
(1) odpowiedzi
2017-05-19 20:05 Using ETag with Database data based on Trigger »
I have MySQL database with table named grades that has only {gradeId,gradeValue} and web service that retrieves grades from DB. I want user to get da...
(0) odpowiedzi
2017-05-19 16:05 How implement Delete Trigger in sql server »
I want write a delete trigger in sql actually i have two tables "products" and "productdetail" and using the primary key of products as a foreign key ...
(2) odpowiedzi
2017-05-13 20:05 How to get age in PostgreSQL »
I'm new to the SQL and I want to create a trigger in PostgreSQL that checks if a person is adult from string "personalNumber" which is in format 'yymm...
(1) odpowiedzi
2017-05-08 15:05 Oracle PL/SQL Trigger: Reset column value automatically after an update statement »
For testing purpose I would like to have the following scenario to be automated: Set column Status of my table to the value closed (using an update ...
(2) odpowiedzi
2017-05-06 21:05 Oracle SQL: Anyone can help me with Error(2,32): PLS-00049: bad bind variable 'WORKED_HOURS' »
Anyone can help me with Error(2,32): PLS-00049: bad bind variable 'WORKED_HOURS' CREATE OR REPLACE TRIGGER uprava_prac_casu BEFORE UP...
(1) odpowiedzi
2017-05-04 14:05 Why is my WPF PasswordBox style trigger not working? »
So I have this PasswordBox in my app. XAML <PasswordBox Name="PB_PASSWORD" Padding="100,0,34,0" FontSize="20" Width="384" Height="34" PasswordCha...
(1) odpowiedzi
2017-04-28 00:04 Triggers in Oracle, before/after, statement level/ row level »
I thought these concepts were clear to me and now I am not so sure. I am new to SQL and have searched for answers, yet seem to be too dumb to underst...
(2) odpowiedzi
2017-04-24 04:04 How to create a trigger to allow both manual and auto primary key in sql developer with oracle 11g »
I am attempting to create a trigger (using SQL Developer with Oracle 11g) that will allow manual insertions onto the primary key, and if a record is c...
(1) odpowiedzi
2017-04-23 16:04 SQL Triggers, how to copy a value from one column to another while updating the first one »
let's say this is our table of PRICES curP | oldP | ID +------------------+ |210 | null | 1 | +------------------+ I would like to create a t...
(2) odpowiedzi
2017-04-23 12:04 PostgreSQL Trigger after update of a specific column »
I'm on my way of exploring triggers and want to create one that fires after an Update event on a game_saved column. As I have read in PostgreSQL docs ...
(1) odpowiedzi