SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
[SA 7.5.492 Pro] - postgresql - DDL of triggers

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
[SA 7.5.492 Pro] - postgresql - DDL of triggers
Author Message
michalk



Joined: 29 Aug 2014
Posts: 211

Post [SA 7.5.492 Pro] - postgresql - DDL of triggers Reply with quote
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)


Code:
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 View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7839

Post Reply with quote
Thank you for your feedback. I will log that in in our bug tracking system
Mon Feb 15, 2016 4:07 pm View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
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


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.