The following bug has been logged online:
Bug reference: 3848
Logged by: Ion
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.3
Operating system: Windows XP SP2
Description: function pg_catalog.substring(date, integer, integer)
does not exist
Details:
Hello,
I tested PostgreSQL 8.3 beta4 with tinyerp and I have this problem:
pg_catalog.substring(date, integer, integer) does not exist
The traceback of python 2.4 :
======================================================
Traceback (most recent call last):
File "D:\erp\tinyerp-server-4.2.1\bin\netsvc.py", line 200, in _dispatch
r=m(*params)
File "D:\erp\tinyerp-server-4.2.1\bin\service\web_services.py", line 422,
in execute
return self._execute(db, uid, wiz_id, datas, action, context)
File "D:\erp\tinyerp-server-4.2.1\bin\service\web_services.py", line 402,
in _execute
return wiz.execute(db, uid, self.wiz_datas[wiz_id], action, context)
File "D:\erp\tinyerp-server-4.2.1\bin\wizard\__init__.py", line 160, in
execute
res = self.execute_cr(cr, uid, data, state, context)
File "D:\erp\tinyerp-server-4.2.1\bin\wizard\__init__.py", line 75, in
execute_cr
action_res = action(self, cr, uid, data, context)
File
"D:\erp\tinyerp-server-4.2.1\bin\addons\base_setup\wizard\wizard_base_setup.
py", line 220, in _update
(db, pool)=pooler.restart_pool(cr.dbname, update_module=True)
File "D:\erp\tinyerp-server-4.2.1\bin\pooler.py", line 64, in
restart_pool
return get_db_and_pool(db_name, force_demo,
update_module=update_module)
File "D:\erp\tinyerp-server-4.2.1\bin\pooler.py", line 53, in
get_db_and_pool
addons.load_modules(db, force_demo, status, update_module)
File "D:\erp\tinyerp-server-4.2.1\bin\addons\__init__.py", line 274, in
load_modules
load_module_graph(cr, graph, status, report=report)
File "D:\erp\tinyerp-server-4.2.1\bin\addons\__init__.py", line 204, in
load_module_graph
init_module_objects(cr, m, modules)
File "D:\erp\tinyerp-server-4.2.1\bin\addons\__init__.py", line 181, in
init_module_objects
obj.init(cr)
File
"D:\erp\tinyerp-server-4.2.1\bin\addons\report_analytic_line\report_analytic
_line.py", line 48, in init
cr.execute("""
File "D:\erp\tinyerp-server-4.2.1\bin\sql_db.py", line 75, in execute
res = self.obj.execute(sql)
ProgrammingError: ERROR: function pg_catalog.substring(date, integer,
integer) does not exist at character 134
HINT: No function matches the given name and argument types. You might need
to add explicit type casts.
1
======================================================
I have not this problem with postgresql 8.2.5.
Thanks.
I happy New Year !
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
