For postgres you need also to specify the sequence name : sequence_name='tablename_newidname_seq'
On Thu, Nov 25, 2010 at 10:47 AM, Richard Vézina < [email protected]> wrote: > Do you mean that you have a recursive sql request? > > Or you want to rename the default id field name for PK? > > In the second case : > > Field('ouid','id') > > does the tricks... > > Richard > > > On Thu, Nov 25, 2010 at 9:16 AM, Johann Spies <[email protected]>wrote: > >> I want to use a foreign key which does not refer to the id-field of >> another record >> >> eg. >> >> >> >> db.define_table('journal', >> Field('ouid','integer'), >> Field('journal',unique=True), >> Field('issn', length=10), >> Field('notes', type='text'), >> signature, >> format=lambda r: r.journal >> ) >> >> db.define_table('article', >> Field('ouid', type='integer'), >> Field('journal', type='string', length=255), >> Field('journal_id', db.journal, requires = >> IS_IN_DB(db,'journal.ouid')), >> Field('volume', type='string', length=20)) >> >> I want 'journal_id' in 'article' to refer to 'ouid' in 'journal' and not >> to 'id'. How do I do it in web2py. >> >> I am using postgresql as backend. I can define the foreign key in >> Postgresql but how do I do it through DAL? >> >> Regards >> Johann >> >> -- >> May grace and peace be yours in abundance through the full knowledge of >> God and of Jesus our Lord! His divine power has given us everything we need >> for life and godliness through the full knowledge of the one who called us >> by his own glory and excellence. >> 2 Pet. 1:2b,3a >> >> >
