 |
SoftTree Technologies
Technical Support Forums
|
|
Author |
Message |
michalk
Joined: 29 Aug 2014 Posts: 211
|
|
[SA 7.5.492 Pro] - postgresql - DDL of triggers |
|
First of all thanks for new version and splitting table Object DDL script. I think it's good direction.
I'm going to successively report found issues in thread-per-issue manner.
Let's start with triggers.
'Show DDL' and 'Edit DDL' sometimes show trigger function DDL while another time it's trigger DDL.
I found this behaviour is probably related to trigger function name. If it is the same as trigger name, then function source code is displayed, otherwise trigger ddl.
By the way, I would improve triggers list by 2 things:
- add action type to attributes listing (BEFORE, AFTER)
- sort names by action timing and name (since in postgresql triggers are executed in alphabetical order)
 |
 |
SELECT "trigger_name", 'TR', event_manipulation, '', action_timing
FROM information_schema.triggers
WHERE event_object_schema = :SCHEMA_NAME
AND event_object_table = :OBJECT_NAME
ORDER BY action_timing DESC, "trigger_name" |
|
|
Mon Feb 15, 2016 12:40 pm |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7948
|
|
|
|
Thank you for your feedback. I will log that in in our bug tracking system
|
|
Mon Feb 15, 2016 4:07 pm |
|
 |
|
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
|
|