is it possible to create trigger without execute procedure in postgresql?

Question

i want to create procedure with BL in its body. i find the same example in SQL but not in postgresql.

No, this is not possible in Postgres (btw: what do you mean with "example in SQL"? - triggers are different for every DBMS, "SQL" is just a query language, not a DBMS product) — user330315
– user330315, Commented Jan 26, 2015 at 11:50
PostgreSQL only allows the execution of a user-defined function for the triggered action. The standard allows the execution of a number of other SQL commands, such as CREATE TABLE, as the triggered action. This limitation is not hard to work around by creating a user-defined function that executes the desired commands. postgresql.org/docs/current/static/sql-createtrigger.html — pozs
– pozs, Commented Jan 26, 2015 at 11:55
i mean i did same thing in sql but now am working in postgresql and am not able to do in postgresql and can't find example like that so is it possible? — user3555572
– user3555572, Commented Jan 26, 2015 at 11:58
Again: what do you mean with "in SQL"? SQL is just a query language. But the bottom line is: you simply can't do that in Postgres. See the examples in the manual: postgresql.org/docs/current/static/plpgsql-trigger.html — user330315
– user330315, Commented Jan 26, 2015 at 12:02

M Faisal Hameed · Accepted Answer · 2015-01-26 12:40:37Z

21

Every RDBMS have their own SQL language. You can't create trigger in PostgreSQL as you can create in Oracle/MS SQL etc. In order to create trigger in PostgreSQL you have to

Create a function in PostgreSQL with you BL
Create a trigger and associate your function with this trigger.

answered Jan 26, 2015 at 12:40

M Faisal Hameed

7131 gold badge8 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Pavel Stehule · Accepted Answer · 2015-01-26 12:25:36Z

8

It is not possible - PostgreSQL doesn't support SQL triggers - every trigger needs a related trigger function. Other databases supports SQL triggers only, but not PostgreSQL.

answered Jan 26, 2015 at 12:25

Pavel Stehule

46.6k6 gold badges103 silver badges102 bronze badges

Collectives™ on Stack Overflow

is it possible to create trigger without execute procedure in postgresql?

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related