auth_user is created with Auth.

However if you just changed the driver then it tries to recreate the tables
that are already in the database.

This already exist issue gives me a lot of problems, it would be nice if it
detects that it exists it just doesn't try create it.

On Tue, Mar 13, 2012 at 11:57 PM, Johann Spies <[email protected]>wrote:

> When I try pg8000 I get the error message in the subject line.
>
> I have this in the model (which works without a problem with the psycopg2
> driver):
>
> db.define_table('auth_user',
>     Field('id','id',
>           represent=lambda id:SPAN(id,'
> ',A('view',_href=URL('auth_user_read',args=id)))),
>     Field('username', type='string',
>           label=T('Username')),
>     Field('first_name', type='string',
>           label=T('First Name')),
>     Field('last_name', type='string',
>           label=T('Last Name')),
>     Field('email', type='string',
>           label=T('Email')),
>     Field('password', type='password',
>           readable=False,
>           label=T('Password')),
>     Field('created_on','datetime',default=request.now,
>           label=T('Created On'),writable=False,readable=False),
>     Field('modified_on','datetime',default=request.now,
>           label=T('Modified On'),writable=False,readable=False,
>           update=request.now),
>     Field('registration_key',default='',
>           writable=False,readable=False),
>     Field('reset_password_key',default='',
>           writable=False,readable=False),
>     Field('registration_id', length=64, default=lambda:str(uuid.uuid4()),
>           writable=False,readable=False),
>     format='%(username)s')
>
>
> Regards
> Johann
>
>
> --
> Because experiencing your loyal love is better than life itself,
> my lips will praise you.  (Psalm 63:3)
>
>


-- 
-- 
Regards,
Bruce Wade
http://ca.linkedin.com/in/brucelwade
http://www.wadecybertech.com
http://www.warplydesigned.com
http://www.fitnessfriendsfinder.com

Reply via email to