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 <h...@nightglass.co.uk>
> 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 | h...@nightglass.co.uk
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
_______________________________________________
sqlobject-discuss mailing list
sqlobject-discuss@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
