Re: Versioning Schema/Stored Procedures

The way I handle this is to version the entire schema and have scripts
that know how to upgrade from one version to another. If you think about
it, you really want/need everything in the database to be designed to
run together anyway. I've yet to find a case where I'd want some of the
stuff in the schema to be older than other stuff.

case where it makes sense to ha
On Fri, Dec 16, 2005 at 02:41:58PM -0800, vishal saberwal wrote:
> 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

--
Jim C. Nasby, Sr. Engineering Consultant jnasby(at)pervasive(dot)com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461