On Thu, Dec 24, 2015 at 2:30 PM, Tim Streater <tim at clothears.org.uk> wrote: > On 24 Dec 2015 at 15:26, Bernardo Sulzbach <mafagafogigante at gmail.com> > wrote: > >> want a more versatile alter table for convenience. However, I don't >> know if alter table is used at all in production anywhere (why would >> it be? the column names and ordering should not be part of the data). > > If I distribute an app with a certain schema, and later make a new version > with added features that needs more columns in the database, I have to detect > the user's version, and run an extra function that updates the schema. If the > user skipped a few versions, several such functions may run. Generally this > does not affect things particularly, but I suppose after a few versions the > order of the columns could become sub-optimal. >
But this is not a blocker, right? You could also create another table with the desired schema and insert from the old one then drop it. It is a convenience in the end. -- Bernardo Sulzbach