BUG #3848: function pg_catalog.substring(date, integer, integer) does not exist

From: "Ion" <sorry_not_for_spam(at)yahoo(dot)fr>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #3848: function pg_catalog.substring(date, integer, integer) does not exist
Date: 2008-01-01 20:11:01
Message-ID: 200801012011.m01KB1A8097450@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 3848
Logged by: Ion
Email address: sorry_not_for_spam(at)yahoo(dot)fr
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 !

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Sam Mason 2008-01-01 21:14:07 Re: BUG #3848: function pg_catalog.substring(date, integer, integer) does not exist
Previous Message Tom Lane 2008-01-01 19:17:58 Re: BUG #3847: plpython trigger caches table structure - doesn't see new / changed columns