Questions tagged [plpgsql]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
3
votes
1answer
119 views

PostGIS trigger does not work as expected while checking intersections

I'm trying to write a trigger that should prevent saving lines which do not end at building boundaries. ( A PostGIS-Solution for something like the topology-rule "Must be covered by boundary of" in ...
0
votes
1answer
31 views

Trigger to SELECT schema rows based on WHERE condition

I am learning about triggers. Generally it seems triggers are employed on the backend to perform some action on a schema. I was interested if it was possible for a trigger to return data on a SELECT ...
1
vote
0answers
48 views

Trigger history_ How can I define the last updated column?

I am trying to implement a trigger function in PostgreSQL. I've written this trigger history function: CREATE OR REPLACE FUNCTION history_update() RETURNS trigger AS $$ BEGIN INSERT INTO ...
1
vote
0answers
41 views

QGIS plpgsql RAISE MESSAGEs do not appear in QGIS Log Messages Panel | PostGIS Tab

I refer to this post Show "Raise Notice" and "Raise Warning" in QGIS and to the herein referred issue https://issues.qgis.org/issues/12184#change-59414. Using QGIS 2.18.18 LTR I ...