Opened 13 years ago
Closed 10 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 13 years ago by
comment:2 Changed 10 years ago by
| Resolution: | → fixed |
|---|---|
| Status: | new → closed |
Note: See
TracTickets for help on using
tickets.

Quizá relacionado con #1267.