hi all,
We installed a first version (
1.0.0.1) of our schema. then came a few patches we had for a few stored procedures and tables (
1.0.0.2). Then even more (
1.0.0.3) (
1.0.0.4). Some chose to upgrade to version
1.0.0.3 and stick to it, while some others chose to upgrade to
1.0.0.4.
Now when i have some more schema updates, how should i find out what (incremental) updates the client needs?
One way might be to store [ 'version', 'schema', 'Date_time_change', 'User_who_Changed' ] in a table. But i want to store the versions for each table/stored procedures/views. I could create a table to store these components with similar details. But i do not want to duplicate the work. I just want to upgrade the components i need to, so as to avoid downtime for teh applications taht do not need the component.
Is it possible to modify pg_class to have another 'version' column so that i can version each relation and other components?
Is there a better way to do schema versioing to the level of tables, stored procedures and views?
thanks,
vish