Re: [web2py] DAL/Postgres not creating a table

2012-07-21 Thread Massimo Di Pierro
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

Re: [web2py] DAL/Postgres not creating a table

2012-07-21 Thread Marek Mollin
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

Re: [web2py] DAL/Postgres not creating a table

2012-07-21 Thread Ovidio Marinho
What is your OS? What is your version web2py? If windows is this the start or web2py.exe web2py.py? the drive is installed psycopg2? Have you ever tried to postgres 8.4, makes this test. Ovidio Marinho Falcao Neto Web Developer ovidio...@gmail.com ov

Re: [web2py] DAL/Postgres not creating a table

2012-07-21 Thread Niphlod
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 poin

Re: [web2py] DAL/Postgres not creating a table

2012-07-21 Thread Massimo Di Pierro
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

Re: [web2py] DAL/Postgres not creating a table

2012-07-21 Thread Marek Mollin
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

Re: [web2py] DAL/Postgres not creating a table

2012-07-20 Thread Ovidio Marinho
Shows the Ticket? Ovidio Marinho Falcao Neto Web Developer ovidio...@gmail.com ovidiomari...@itjp.net.br ITJP - itjp.net.br 83 8826 9088 - Oi 83 9334 0266 - Claro Brasil

Re: [web2py] DAL/Postgres not creating a table

2012-07-20 Thread Bruno Rocha
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 wrote: > Hey, > Problem is as follows. > I start a clean db in psql. Test the connection + delete all the > /databases files to fresh with remot

[web2py] DAL/Postgres not creating a table

2012-07-20 Thread Marek Mollin
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 ta