Re: [GENERAL] Partitioned postgres tables don't need update trigger??

2016-06-03 Thread rverghese
Perfect! Thanks for the response! Just wanted to make sure I wasn't missing anything. -- View this message in context: http://postgresql.nabble.com/Partitioned-postgres-tables-don-t-need-update-trigger-tp5906403p5906415.html Sent from the PostgreSQL - general mailing list archive at

Re: [GENERAL] Partitioned postgres tables don't need update trigger??

2016-06-03 Thread David G. Johnston
On Fri, Jun 3, 2016 at 5:03 PM, rverghese wrote: > I am working with partitioned tables. I have partitioned based on date and > I have the INSERT trigger in place, I don't have an Update or Delete > Trigger but both updates and deletes against the master table work >

[GENERAL] Partitioned postgres tables don't need update trigger??

2016-06-03 Thread rverghese
I am working with partitioned tables. I have partitioned based on date and I have the INSERT trigger in place, I don't have an Update or Delete Trigger but both updates and deletes against the master table work correctly. I am not sure how these are working without triggers. Any insight? So, this