Re: [web2py] sqlite and 'unique'

2010-04-15 Thread Keith Edmunds
On Thu, 15 Apr 2010 15:25:56 -0500, thade...@thadeusb.com said: > sqlite does not enforce types/length, or uniqueness. I understand about types/lengths, but the uniqueness part doesn't match with what I'm seeing: $ sqlite3 /dev/shm/test.db SQLite version 3.5.9 Enter ".help" for instructions sqli

Re: [web2py] sqlite and 'unique'

2010-04-15 Thread Thadeus Burgess
sqlite does not enforce types/length, or uniqueness. You can insert a string into an integer field for all sqlite is concerned. -- Thadeus On Thu, Apr 15, 2010 at 3:17 PM, Keith Edmunds wrote: > I have the following (sqlite) table definition: > > db.define_table('companies', >    Field('nam

[web2py] sqlite and 'unique'

2010-04-15 Thread Keith Edmunds
I have the following (sqlite) table definition: db.define_table('companies', Field('name', length=512, default='', unique=True), Field('oncontract', 'boolean', default=False) ) >From the admin app, I am prevented from adding duplicate company names. However, from the shell, a sequence of: