[web2py] pg8000: ProgrammingError: ('ERROR', '42P07', 'relation "auth_user" already exists')

[Johann Spies]

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)