Triggers

SQLServerCentral Article

PostgreSQL Triggers Part 2

  • Article

Article Overview In this article, we will learn how to drop, alter, enable, and disable a PostgreSQL trigger. In the 1st part of this series, we got an overall view of database triggers, PostgreSQL-specific triggers, types of PostgreSQL triggers, and how to create a trigger with basic syntax and examples. If you haven't read it […]

You rated this post out of 5. Change rating

2022-09-23

1,052 reads

External Article

Triggers: Threat or Menace?

  • Article

Triggers are generally over-used in SQL Server. They are only rarely necessary, can cause performance issues, and are tricky to maintain If you use them, it is best to keep them simple, and have only one operation per trigger. Joe Celko describes a feature of SQL that 'gets complicated fast'.

2017-01-03

3,807 reads

Blogs

The 5 Best SQL Course for Beginners – Reviews and Guide

By

In the technologically driven world of 2024, more individuals are finding themselves drawn towards the...

Speaking at SQL Saturday Boston 2023

By

I’m heading to Boston next week for SQL Saturday Boston 2023. I went to...

SQL Prompt Quick Access to Helper Code

By

We’ve been doing some events as part of the Redgate Roadshow, and at one...

Read the latest Blogs

Forums

checkdbcc date for all database

By lan2022nguyen

CREATE TABLE #tempdblogin ( lastcheck nvarchar(100) ) EXEC sp_MSforeachdb 'USE ? insert into #tempdblogin...

Azure Postgres reliability/management experiences

By CreateIndexNonclustered

I am considering implementing an Azure Postgres DB for use in a part of...

Unable to deploy DACPAC

By LearningDBA

Every time the dev team runs their dacpac, they encounter an issue. "This deployment...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers