I just test the trunk, the problem it gone! Thank a lot.
Regard Richard 2010/8/20 Richard Vézina <[email protected]> > I will have a look at it and coming back to close the thread. > > Thanks > > Richard > > 2010/8/19 mdipierro <[email protected]> > > It is a bug. Now fixed in trunk. Please give it a try. >> >> On Aug 19, 4:38 pm, Richard Vézina <[email protected]> >> wrote: >> > Here the w2p model : >> > >> > db.define_table('table1', >> > Field('table1_id','id'), >> > Field('field1'), >> > migrate=False, >> > sequence_name='table1_table1_id_seq') >> > >> > Here the postgresql SQL creation script : >> > >> > CREATE TABLE table1 >> > ( >> > table1_id serial NOT NULL, >> > field1 character varying, >> > CONSTRAINT table1_id PRIMARY KEY (table1_id) >> > ) >> > WITH ( >> > OIDS=FALSE >> > >> > I just test it, the importation with table1.table1_id in SQLite works... >> I >> > mean I don't exactly know what is in sqlite... >> > >> > But it not workin with postgresql except if you change table1.table1_id >> for >> > table1.id >> > >> > Regards >> > >> > Richard >> > >> > 2010/8/19 mdipierro <[email protected]> >> > >> > > Can you post the model and the first two lines of the generated csv >> > > file? >> > >> > > On Aug 19, 3:34 pm, Richard Vézina <[email protected]> >> > > wrote: >> > > > Web2py admin interface exported csv file... Try to import the exact >> > > exported >> > > > csv file it fails. >> > >> > > > Richard >> > >> > > > 2010/8/19 mdipierro <[email protected]> >> > >> > > > > Does table1 have a column called "table1_id"? Seems strange. Who >> > > > > created the csv file? >> > >> > > > > On Aug 19, 2:06 pm, Richard Vézina <[email protected]> >> > > > > wrote: >> > > > > > I got it... Wrong model definition caused by a search an >> replace... >> > > > > Sorry! >> > >> > > > > > But there is still a problem with the importation as detailed in >> the >> > > PS.: >> > > > > > section of my intial emai. >> > >> > > > > > Here a copy : >> > >> > > > > > PS.: There is a problem on importation of exported csv file from >> the >> > > > > admin >> > > > > > interface... The id field of exported csv is : table1.table1_id >> that >> > > > > > correct, but the importation fail if I am not changing the >> > > > > *table1.table1_id >> > > > > > * header for *table1.id* >> > >> > > > > > 2010/8/19 Richard Vézina <[email protected]> >> > >> > > > > > > Ok, the problem is not coming from the postgresql manipulation >> as I >> > > > > thought >> > > > > > > it >> > > > > > > was... >> > >> > > > > > > I did the manipulation on an other table and got no problem. >> The >> > > > > problem >> > > > > > > seems to be >> > > > > > > presente since some time, but I didn't detected it.. >> > >> > > > > > > Richard >> > >> > > > > > > 2010/8/19 Richard Vézina <[email protected]> >> > >> > > > > > > Hello, >> > >> > > > > > >> I am stuck on a problem about which I don't have a clue how >> to >> > > > > solve... >> > >> > > > > > >> I explain what I did : >> > >> > > > > > >> I would reload my entire database tables with fresh manually >> > > generated >> > > > > > >> data, so I flush out all the data that were in the database. >> I >> > > would >> > > > > have >> > > > > > >> the Postgresql sequence to be reseted so I ALTER SEQUENCE >> > > > > > >> table1_table1_id_seq RESTART WITH 1; >> > >> > > > > > >> I import my newly generated data from csv file with the admin >> > > > > interface. >> > > > > > >> No problem until there... >> > >> > > > > > >> I can add new data to the table with my app form... >> > >> > > > > > >> But when I link table1_id from other table FK I get this >> error >> > > ticket >> > > > > : >> > >> > > > > > >> Traceback (most recent call last): >> > >> > > > > > >> File "/version_183-2/web2py/gluon/restricted.py", line 186, >> in >> > > > > restricted >> > >> > > > > > >> exec ccode in environment >> > >> > > > > > >> File >> > > "/version_183-2/web2py/applications/app/controllers/default.py" >> > > > > <http://admin/default/edit/devGUImdg1/controllers/lotns.py>, line >> 261, >> > > in >> > > > > <module> >> > >> > > > > > >> File "/version_183-2/web2py/gluon/globals.py", line 96, in >> > > <lambda> >> > >> > > > > > >> self._caller = lambda f: f() >> > >> > > > > > >> File "/version_183-2/web2py/gluon/tools.py", line 2219, in >> f >> > >> > > > > > >> return action(*a, **b) >> > >> > > > > > >> File >> > > "/version_183-2/web2py/applications/app/controllers/default.py" >> > > > > <http://admin/default/edit/devGUImdg1/controllers/lotns.py>, line >> 17, >> > > in >> > > > > create >> > >> > > > > > >> if form.accepts(request.vars, session): >> > >> > > > > > >> File "/version_183-2/web2py/gluon/sqlhtml.py", line 1049, >> in >> > > accepts >> > >> > > > > > >> self.vars.id = self.table.insert(**fields) >> > >> > > > > > >> File "/version_183-2/web2py/gluon/sql.py", line 2009, in >> insert >> > >> > > > > > >> self._db._execute("select currval('%s')" % >> > > self._sequence_name) >> > >> > > > > > >> File "/version_183-2/web2py/gluon/sql.py", line 1010, in >> > > <lambda> >> > >> > > > > > >> self._execute = lambda *a, **b: self._cursor.execute(*a, >> **b) >> > >> > > > > > >> OperationalError: ERREUR: la valeur courante (currval) de la >> > > séquence >> > > > > « table1_table1_id_seq » n'est pas encore définie >> > >> > > > > > >> dans cette session >> > >> > > > > > >> I use the to define my postgresql sequence name in my model >> that >> > > way >> > > > > sequence_name='table1_table1_id_seq' for the field : >> > > > > Field('table1_id','id'), >> > >> > > > > > >> I try to clean my app without succes, try to restart, etc. >> > >> > > > > > >> Thanks for any suggestion! >> > >> > > > > > >> Richard >> > >> > > > > > >> PS.: There is a problem on importation of exported csv file >> from >> > > the >> > > > > admin interface... The id field of exported csv is : >> table1.table1_id >> > > that >> > > > > correct, but the importation fail if I am not changing the >> > > > > *table1.table1_id* header for *table1.id* >> > >
