Re: Altering a (populated) database column

   Hi, Oleg,

   Thanks for the prompt reply.

On Tue, Oct 24, 2017 at 09:37:57PM +0200, Oleg Broytman wrote:
> On Tue, Oct 24, 2017 at 08:00:13PM +0100, Hugo Mills <[email protected]> wrote:
> >    Is there any way that I can modify an existing database column,
> > with data in it, without losing the data in it? All I need to be able
> > to do is increase the size of a StringCol.
> > 
> >    I can see addColumn and delColumn methods of the sqlmeta object,
> > but not an alterColumn or anything similar.
> 
>    Probably yes (depends on the backend) but not with SQLObject.
> SQLObject can CREATE/DROP tables, columns and indices but cannot ALTER
> them.
>    You need to execute ALTER TABLE connecting directly or call
> connection.execute("ALTER TABLE ...")
> 
>    What us your backend? MySQL?

   It's Postgres. If there's no other way than connection.execute(),
then I've got no real problem with working that out. I was just hoping
that there was a less... raw approach.

   Hugo.

> >    Thanks,
> >    Hugo.
> > 

-- 
Dr Hugo Mills                           | [email protected]
Chief Technologist                      | 
Nightglass Medical Rostering Ltd        | +44 207 040 4054


------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot