tag:blogger.com,1999:blog-6018614372585319965.post3740242501444651922..comments2024-02-25T09:25:41.902+01:00Comments on Valentine's tech log: Table partitioning automation triggers in PostgreSQLAnonymoushttp://www.blogger.com/profile/02521879454303479150noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-6018614372585319965.post-24351605948926113932010-10-31T13:58:24.086+01:002010-10-31T13:58:24.086+01:00This example isn't safe and should NOT be used...This example isn't safe and should NOT be used in production.<br /><br />Creating partitions automatically in a trigger is a big no-no because of deadlocks. You should always create the partitions using some other method. For time-based partitions, cronjobs are handy.Marko Tiikkajahttps://www.blogger.com/profile/10981554077352841785noreply@blogger.comtag:blogger.com,1999:blog-6018614372585319965.post-33068222240329573212009-01-03T17:46:00.000+01:002009-01-03T17:46:00.000+01:00Great article. Helped me a lot! Thank you!Great article. Helped me a lot! <BR/>Thank you!Sergeyhttps://www.blogger.com/profile/03442387143766723207noreply@blogger.com