Yes. I do not think those lines belong in there. I was just suggesting
a workaround.
On Nov 18, 8:06 pm, Richard <richar...@gmail.com> wrote:
> isn't generating that exception every request going to be too much
> overhead?
>
> On Nov 19, 7:37 am, mdipierro <mdipie...@cs.depaul.edu> wrote:
>
> > The fact is, indices must be created only once. If you have the index
> > already that line fails. You handle the exception at the web2py level
> > but the transcation still aborts. Try:
>
> > try:
> > db.executesql("CREATE UNIQUE INDEX indexO ON secretnum
> > (primocod);")
> > except:
> > db.rollback()
>
> > On Nov 18, 2:34 pm, leone <handja...@gmail.com> wrote:
>
> > > Peraphs I found the piece of code that creates the problem.
> > > After table definition I have:
> > > try:
> > > db.executesql("CREATE UNIQUE INDEX indexO ON secretnum
> > > (primocod);")
> > > except:
> > > pass
> > > if I comment these rows all runs, even if DAL and table definition is
> > > in plugin_secretnum.py
>
> > > On 18 Nov, 21:11, leone <handja...@gmail.com> wrote:
>
> > > > If I put DAL and table definition in db.py all is Ok and sql.log
> > > > report:
> > > > CREATE TABLE secretnum(
> > > > id SERIAL PRIMARY KEY,
> > > > primocod VARCHAR(8),
> > > > secondocod VARCHAR(5),
> > > > terzocod VARCHAR(5),
> > > > username VARCHAR(20),
> > > > attivo CHAR(1)
> > > > );
> > > > success!
>
> > > > If I put DAL and table definition in plugin_secretnum.py in models I
> > > > have error:
>
> > > > row = db(db.secretnum.primocod == primocod).select()
> > > > File "/home/eugenio/web2py/web2py/gluon/sql.py", line 2901, in
> > > > select
> > > > rows = response(query)
> > > > File "/home/eugenio/web2py/web2py/gluon/sql.py", line 2896, in
> > > > response
> > > > db._execute(query)
> > > > File "/home/eugenio/web2py/web2py/gluon/sql.py", line 909, in
> > > > <lambda>
> > > > self._execute = lambda *a, **b: self._cursor.execute(*a, **b)
> > > > InternalError: current transaction is aborted, commands ignored until
> > > > end of transaction block
>
> > > > .......and sql.log have no new message.
>
> > > > On 18 Nov, 21:01, mdipierro <mdipie...@cs.depaul.edu> wrote:
>
> > > > > what is in sql.log?
>
> > > > > On Nov 18, 10:54 am, leone <handja...@gmail.com> wrote:
>
> > > > > > Grrr.
> > > > > > I can't uderstand. I have code that runs in sqlite bat non in
> > > > > > postgresql.
> > > > > > Apparently it is very simple.
> > > > > > Where is my error??
>
> > > > > > db.define_table('secretnum',
> > > > > > Field('primocod','string', length=8),
> > > > > > Field('secondocod','string', length=5),
> > > > > > Field('terzocod','string', length=5),
> > > > > > Field('username','string', length=20),
> > > > > > Field('attivo','boolean', default=True),
> > > > > > )
> > > > > > row = db(db.secretnum.primocod == '12345678').select()
>
> > > > > > Error:
> > > > > > File "/home/eugenio/web2py/web2py/gluon/sql.py", line 2901, in
> > > > > > select
> > > > > > rows = response(query)
> > > > > > File "/home/eugenio/web2py/web2py/gluon/sql.py", line 2896, in
> > > > > > response
> > > > > > db._execute(query)
> > > > > > File "/home/eugenio/web2py/web2py/gluon/sql.py", line 909, in
> > > > > > <lambda>
> > > > > > self._execute = lambda *a, **b: self._cursor.execute(*a, **b)
> > > > > > InternalError: current transaction is aborted, commands ignored
> > > > > > until
> > > > > > end of transaction block
>
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To post to this group, send email to web2py@googlegroups.com
To unsubscribe from this group, send email to
web2py+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---
