Re: [GENERAL] A safe way to upgrade table definitions by using ALTER's

2009-08-28 Thread Sergey Samokhin
Hello! On Fri, Aug 28, 2009 at 5:56 PM, Sam Mason wrote: > Not sure if that's the sort of thing that you want/need but I don't > think there's a general solution to the problem.  Determining the > relevant context for this sort of thing is hard. The solutions you and Steve Atkins offered seem wh

Re: [GENERAL] A safe way to upgrade table definitions by using ALTER's

2009-08-28 Thread Sam Mason
On Fri, Aug 28, 2009 at 12:42:59AM +0400, Sergey Samokhin wrote: > But how do programmers guarantee that ALTER's they have wrote will > always be applied by administrators to the corresponding version of > the database? How about using the normal integrity constraints that databases provide? Have

Re: [GENERAL] A safe way to upgrade table definitions by using ALTER's

2009-08-27 Thread Steve Atkins
On Aug 27, 2009, at 1:42 PM, Sergey Samokhin wrote: 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 ap

[GENERAL] A safe way to upgrade table definitions by using ALTER's

2009-08-27 Thread Sergey Samokhin
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