I think it is, but it is in the last section of chapter 6.
On Saturday, 21 July 2012 13:04:15 UTC-5, Marek Mollin wrote:
>
> Again web2py-users doesnt disappoint.
> I forgot that opposed to sqlite postgres has strong typing of fields so
> you have to have existing tables for fk.
> (I thought that 'reference table' instead of db.table - overrides that, at
> the app level it does at least)
>
> I think this should perhaps go to book about db gotchas.
> Since most people start rumbling on sqlite and then migrate... worth
> reminding I guess.
>
> Thanks again.
>
>
>
> W dniu sobota, 21 lipca 2012 16:08:29 UTC+2 użytkownik Niphlod napisał:
>>
>> on sql.log in your databases folder there is the excerpt of the
>> statements used to create the table.
>>
>> I'm guessing that you implemented your app adding here and there tables
>> but never defining them "in order" .
>>
>> This seems the kind of problem when you try to create a table with
>> foreign keys pointing to a table that doesn't yet exist (i.e.
>> Field('detail_id', db.details) without the db.details be defined already).
>>
>>
>> On Saturday, July 21, 2012 11:55:10 AM UTC+2, Marek Mollin wrote:
>>>
>>> other info:
>>> I am using postgres 9.1
>>>
>>> No migrate is not set to false. + it creates all other tables it just
>>> stops at certain point and skips a few of them.
>>>
>>> error stack:
>>>
>>> Traceback (most recent call last):
>>> File "G:\mac-backup\CLIENTS 2\paczkon\web2py\gluon\restricted.py", line
>>> 205, in restricted
>>> exec ccode in environment
>>> File "G:/mac-backup/CLIENTS
>>> 2/paczkon/web2py/applications/menzo/models/db.py"
>>> <http://127.0.0.1:8000/admin/default/edit/menzo/models/db.py>, line 212, in
>>> <module>
>>> format=lambda r: '%s %s %s' % (r.user.email, r.status, r.price)
>>> File "G:\mac-backup\CLIENTS 2\paczkon\web2py\gluon\dal.py", line 6320, in
>>> define_table
>>> polymodel=polymodel)
>>> File "G:\mac-backup\CLIENTS 2\paczkon\web2py\gluon\dal.py", line 719, in
>>> create_table
>>> self.create_sequence_and_triggers(query,table)
>>> File "G:\mac-backup\CLIENTS 2\paczkon\web2py\gluon\dal.py", line 1954, in
>>> create_sequence_and_triggers
>>> self.execute(query)
>>> File "G:\mac-backup\CLIENTS 2\paczkon\web2py\gluon\dal.py", line 1392, in
>>> execute
>>> return self.log_execute(*a, **b)
>>> File "G:\mac-backup\CLIENTS 2\paczkon\web2py\gluon\dal.py", line 1386, in
>>> log_execute
>>> ret = self.cursor.execute(*a, **b)
>>> ProgrammingError: relation "delivery_type" does not exist
>>>
>>>
>>> W dniu piątek, 20 lipca 2012 23:30:00 UTC+2 użytkownik rochacbruno
>>> napisał:
>>>>
>>>>
>>>> are you sure the migrate is not False in db = DAL(...) ?
>>>>
>>>> try including migrate=True in your define_table
>>>>
>>>> On Fri, Jul 20, 2012 at 6:17 PM, Marek Mollin <[email protected]> wrote:
>>>>
>>>>> Hey,
>>>>> Problem is as follows.
>>>>> I start a clean db in psql. Test the connection + delete all the
>>>>> /databases files to fresh with remote db.
>>>>> When I launch index page tables start getting created then I get error
>>>>> regarding some table is missing. I check sql.log and it did not even
>>>>> start
>>>>> creating the table (this + a few more get ommited).
>>>>>
>>>>> I have check_reserved in my DAL declaration. Table is not ill named:
>>>>>
>>>>> db.define_table('delivery_type',
>>>>> Field('name','string'),
>>>>> Field('price','double'),
>>>>> format=lambda r: r.name
>>>>> )
>>>>>
>>>>> but there are others not getting created
>>>>> version 1.99.7
>>>>>
>>>>> --
>>>>>
>>>>>
>>>>>
>>>>>
>>>>
>>>>
--
