Can I also see your databases/...._xauth.table (unpickled)?
On May 30, 10:34 pm, Carlos <carlosgali...@gmail.com> wrote:
> Hi,
>
> I'm using latest trunk, with 'xuser' instead of auth_user (which is not the
> issue because I was getting no errors up until very recently).
>
> Note that everything was working ok (no errors) up until 4 changesets ago,
> i.e. up until changeset # e33d3578be33 (fixed problem with load and string
> args).
>
> If I update to that changeset (e33d3578be33), everything works ok again.
>
> web2py™ Version 1.96.0 (2011-05-30 21:04:39)
> Python Python 2.6.4: C:\Python26\python.exe
>
> File "C:\web2py\gluon\dal.py", line 4212, in define_table
> polymodel=polymodel)
> File "C:\web2py\gluon\dal.py", line 641, in create_table
> fake_migrate=fake_migrate)
> File "C:\web2py\gluon\dal.py", line 729, in migrate_table
> self.execute(sub_query)
> File "C:\web2py\gluon\dal.py", line 1222, in execute
> return self.log_execute(*a, **b)
> File "C:\web2py\gluon\dal.py", line 1217, in log_execute
> ret = self.cursor.execute(*a,**b)
> ProgrammingError: there is no unique constraint matching given keys for
> referenced table "xuser"
>
> def log_execute(self,*a,**b):
> self.db._lastsql = a[0]
> t0 = time.time()
> ret = self.cursor.execute(*a,**b)
> self.db._timings.append((a[0],time.time()-t0))
> return ret
>
> Variables
> a ('ALTER TABLE xuser ADD xupdated_by__tmp INTEGER REFERENCES
> xuser(first_name) ON DELETE SET NULL;',)
> b {}
> self <gluon.dal.PostgreSQLAdapter object at 0x03872450>
> ret undefined
> self.cursor <cursor object at 0x0390A990; closed: 0>
> self.cursor.execute <built-in method execute of psycopg2._psycopg.cursor
> object at 0x0390A990>
>
> Thanks,
>
> Carlos
