Hello.
As I know upgrading database structure from one version to another is
usually done by applying some sql-script with a set of ALTER's that do
all the work.
But how do programmers guarantee that ALTER's they have wrote will
always be applied by administrators to the corresponding version of
the database?
Is there a standard way to store some kind of metainformation in DB
(like version of the current definitions of tables) and then check if
it is too old for being upgraded by a given script?
By "database structure" I mean definition of tables an application
uses (data types, constraints, modificators etc), stored procedures
etc.
Thanks.
--
Sergey Samokhin
P.S. If there is other convinient way to do upgrades which I've missed
- please let me know. I'm still a novice in the PostgreSQL/SQL world.