| <class 'psycopg2.ProgrammingError'> | Python 2.7.9: /usr/bin/python Wed Jan 28 09:58:11 2026 |
A problem occurred in a Python script. Here is the sequence of function calls leading up to the error, in the order they occurred.
| /var/www/ficnx/ficfac.py in |
| 418 fc_usocfdi char(3) default 'P01' )" |
| 419 |
| => 420 ficsql.fSql(mquery1) |
| 421 """ |
| 422 mquery1="CREATE TABLE "+tTmp+" (LIKE fnfact INCLUDING DEFAULTS);" |
| ficsql = <module 'ficsql' from '/var/www/ficnx/ficsql.py'>, ficsql.fSql = <function fSql>, mquery1 = "CREATE TABLE df1345e-05 ( fc_serial ... '99',\t fc_usocfdi\tchar(3) default 'P01'\t)" |
| /var/www/ficnx/ficsql.py in fSql(lsql="CREATE TABLE df1345e-05 ( fc_serial ... '99',\t fc_usocfdi\tchar(3) default 'P01'\t)", lTst=True, lcur=0) |
| 420 """ |
| 421 if lcur==0: |
| => 422 return cur.execute(lsql) |
| 423 else: |
| 424 return curdic.execute(lsql) |
| global cur = <cursor object at 0x7f75516a9af8; closed: 0>, cur.execute = <built-in method execute of psycopg2._psycopg.cursor object>, lsql = "CREATE TABLE df1345e-05 ( fc_serial ... '99',\t fc_usocfdi\tchar(3) default 'P01'\t)" |
<class 'psycopg2.ProgrammingError'>: syntax error at or near "-"
LINE 1: CREATE TABLE df1345e-05 ( fc_serial serial, ...
^
args =
('syntax error at or near "-"\nLINE 1: CREATE TABLE... serial, ...\n ^\n',)
cursor =
<cursor object at 0x7f75516a9af8; closed: 0>
diag =
<psycopg2._psycopg.Diagnostics object>
message =
'syntax error at or near "-"\nLINE 1: CREATE TABLE... serial, ...\n ^\n'
pgcode =
'42601'
pgerror =
'ERROR: syntax error at or near "-"\nLINE 1: CREA... serial, ...\n ^\n'