[Babase] Altering Boolean column in Schema Pop-bio

Lacey Maryott Roerish lkm9 at duke.edu
Thu Aug 26 11:23:26 EDT 2010


Karl,

    Susan asked that I alter some data-types in a table called popbio.gene.
Basically the majority of the columns contain boolean data, and they need to
be changed to varchar.  I tried before emptying the table, and it wouldn't
alter. I then dumped the data, emptied the table, and it still won't work.
 I did empty the default column, which currently reads 'false' for each of
these boolean columns.  I Don't know why it is not letting me alter these.
Is there a way to force it?

Thanks!
Lacey

-- 
- -
Lacey K. Maryott Roerish
Alberts Lab
Department of Biology
Duke University
ph: 919-660-7306
fax: 919-660-7293
Lacey.Maryott at duke.edu
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://eeblistserv.Princeton.EDU/pipermail/babase/attachments/20100826/49fdbf7e/attachment.html


More information about the Babase mailing list