Could you paste your entire define_table() for this table?
On Tue, Oct 15, 2013 at 9:23 PM, Ovidio Marinho <[email protected]> wrote: > > > Error ticket for "sisventi" Ticket ID > > I'm not managing to identify if there is a mistake in the DAL or is > postgres??? help me > > > 127.0.0.1.2013-10-15.21-20-42.332763ea-1f12-4d73-8379-2e0364347acf > <class 'psycopg2.ProgrammingError'> ERRO: erro de sintaxe em ou próximo a > "array" LINE 10: array VARCHAR(512), ^ Versão web2py™Version > 2.6.4-stable+timestamp.2013.09.22.01.43.37PythonPython 2.7.5: > c:\python27\python.exe (prefix: c:\python27) Traceback > > > > 1. > 2. > 3. > 4. > 5. > 6. > 7. > 8. > 9. > 10. > 11. > 12. > 13. > 14. > 15. > 16. > 17. > 18. > 19. > 20. > 21. > 22. > > > > Traceback (most recent call last): > File "C:\web2py264\gluon\restricted.py", line 217, in restricted > > > > exec ccode in environment > File "C:/web2py264/applications/sisventi/models/db.py" > <http://localhost:8000/admin/default/edit/sisventi/models/db.py>, line 1328, > in <module> > > > > Field('posicion', type='integer', default=0, notnull=False) > > > > File "C:\web2py264\gluon\dal.py", line 7895, in define_table > > > > table = self.lazy_define_table(tablename,*fields,**args) > > > > File "C:\web2py264\gluon\dal.py", line 7932, in lazy_define_table > > > > polymodel=polymodel) > File "C:\web2py264\gluon\dal.py", line 1002, in create_table > > > > self.create_sequence_and_triggers(query,table) > > > > File "C:\web2py264\gluon\dal.py", line 2657, in create_sequence_and_triggers > > > > self.execute(query) > File "C:\web2py264\gluon\dal.py", line 1833, in execute > > > > return self.log_execute(*a, **b) > > > > File "C:\web2py264\gluon\dal.py", line 1827, in log_execute > > > > ret = self.cursor.execute(command, *a[1:], **b) > > > ProgrammingError: ERRO: erro de sintaxe em ou próximo a "array" > LINE 10: array VARCHAR(512), > > > > ^ > > Error snapshot [image: > help]<http://localhost:8000/admin/default/ticket/sisventi/127.0.0.1.2013-10-15.21-20-42.332763ea-1f12-4d73-8379-2e0364347acf#> > > <class 'psycopg2.ProgrammingError'>(ERRO: erro de sintaxe em ou próximo a > "array" LINE 10: array VARCHAR(512), ^ ) > > > > Ovidio Marinho Falcao Neto > ITJP.NET.BR > [email protected] > Brasil > > > -- > Resources: > - http://web2py.com > - http://web2py.com/book (Documentation) > - http://github.com/web2py/web2py (Source code) > - https://code.google.com/p/web2py/issues/list (Report Issues) > --- > You received this message because you are subscribed to the Google Groups > "web2py-users" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/groups/opt_out. > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
