Re: [web2py] Re: ProgrammingError: there is no unique constraint matching given keys for referenced table "scopus_rou"

2010-01-29 Thread Johann Spies
On 29 January 2010 23:24, Johann Spies wrote: > On 29 January 2010 22:33, mdipierro wrote: >> can we see the definition of db.scopus_rou? What database engine? Your question helped me to remember: This was the table I recreated through psql then web2py did not change the field type (the other t

Re: [web2py] Re: ProgrammingError: there is no unique constraint matching given keys for referenced table "scopus_rou"

2010-01-29 Thread Johann Spies
On 29 January 2010 22:33, mdipierro wrote: > can we see the definition of db.scopus_rou? What database engine? Database Engine: Postgresql. Here is the definition for scopus_rou: db.define_table("scopus_rou", Field("Authors", 'text'), Field("Title", "string", len

[web2py] Re: ProgrammingError: there is no unique constraint matching given keys for referenced table "scopus_rou"

2010-01-29 Thread mdipierro
can we see the definition of db.scopus_rou? What database engine? On Jan 29, 1:00 pm, Johann Spies wrote: > The data of the following table will come from 4 other: > (db.scopus_rou, db.cab_rou, db.pubmed_rou, db.wos_rou) > > In each record I want to indicate from which of those the data of that >