If Not True Then False

PHP Script to Generate PostgreSQL Table Partitioning (Part 2) - Comment Page: 1

As Part 1 (Howto create PostgreSQL table partitioning) shows, making of PostgreSQL partitioning needs a lot of SQL commands. So this Part 2 explains how SQL commands for PostgreSQL partitioning can be made with a simple PHP script. This example script make SQL for child tables, indexes, trigger function and parent table trigger. This example script can make PostgreSQL table partitioning with...
Categories:

3 Comments

Leave a Comment

Your email address will not be published. Required fields are marked *

Input your comment.
help

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

Input your name.

Candra Nur Ihsan

Can we use with catch exception let say when undefined_table create newtableYEARMONTH will it work. so new inheritance table will be created automatically ?

reply Reply
JR

Hi Candra Nur Ihsan,

Yes it should work, but it’s always good to test it properly. I think that you don’t want to lose any data when this situation occurs.

reply Reply