Hi! I defined/changed field type to smallint by hands using pgAdmin, it works OK (with web2py integer type). If you want to do it under DAL only, you can try Custom Field types <http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#Custom-Field-types--experimental-> or make some post DB initialization using db.executesql('ALTER TABLE ... ALTER COLUMN ...') , the latter is more tricky because should be performed only when it's really necessary
On Thursday, December 7, 2017 at 2:37:50 AM UTC+3, lucas wrote: > > hey one and all, > > i would like to make some fields of type smallint, which postgresql > allows. is there a way to do this under the DAL in the model file, under > the Field designator? > > thank you in advance, lucas > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
