You have some of type "reference deliverytype" and table "deliverytype" is not defined.
There could be an order issue in the table and postgres cannot alter a table and add or modify a field which is a reference to a table not defined yet. On Saturday, 21 July 2012 04:55:10 UTC-5, 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 >>> >>> -- >>> >>> >>> >>> >> >> --
