Opened 12 years ago
Closed 9 years ago
#1648 closed defect (fixed)
Fallo usando el driver de postgres
Reported by: | Pedro Gea | Owned by: | Jorge |
---|---|---|---|
Priority: | high | Milestone: | Mantainance |
Component: | Database | Version: | 3.1 |
Severity: | critical | Keywords: | |
Cc: |
Description
El driver de postgres devuelve errores al hacer determinadas consultas que involucran fechas.
Una consulta del tipo:
Real DBOpen(<alias>, <user>, <password>, [[ "postgres", "tracdb", <server> ]]); Serie DBSeries(" SELECT date_trunc('day', to_timestamp(time)), Count(*) FROM mmssch.ticket GROUP BY date_trunc('day', to_timestamp(time)) ORDER BY date_trunc('day', to_timestamp(time)) ", C, [[ "auxiliar" ]])[1]; Real DBClose(<alias>);
devuelve multitud de errores como:
ERROR: [] la función 'postgres_GetAsDate' en el módulo PostgreSQL ha fallado. Warning: [] (Funcion DBSeries) Fecha no válida en el registro ...
Esto no ocurre si la conexión es abierta a través de una conexión ODBC:
Real DBOpen(<aliasODBC>, <user>, <password>); Serie <QUERY>; Real DBClose(<aliasODBC>);
Change History (2)
comment:1 Changed 12 years ago by
comment:2 Changed 9 years ago by
Resolution: | → fixed |
---|---|
Status: | new → closed |
Note: See
TracTickets for help on using
tickets.
Quizá relacionado con #1267.