| From: | "Luis Guevara" <luisguevaraa(at)hotmail(dot)com> |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | BUG #1752: Problema al insertar TIME |
| Date: | 2005-07-04 19:48:52 |
| Message-ID: | 20050704194852.28C2AF0B09@svr2.postgresql.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 1752
Logged by: Luis Guevara
Email address: luisguevaraa(at)hotmail(dot)com
PostgreSQL version: 8.0
Operating system: Linux Suxe
Description: Problema al insertar TIME
Details:
Usando el cliente EMS Postgesql ejecuto lo siguiente:
INSERT INTO "public"."expediente" ("expe_id", "expe_origen", "expe_tipo",
"expe_fecha", "expe_hora") VALUES (8,2,0,'08/06/2005','09:20:13 a.m.');
Y obtengo el siguiente error:
/* Error : "ERROR: invalid input syntax for type time: "09:20:13 a.m."" */
Si ejecuto lo mismo pero en un servidor postgres 8.0 instalado en windowsXP
todo funciona correctamente e inserta los datos.
Cual puede ser el problema?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Hans Olav Eggestad | 2005-07-04 22:05:06 | extract epoch bug |
| Previous Message | Bruce Momjian | 2005-07-04 19:05:57 | Re: libecpg (8.0 and CVS) hits a gcc bug on powerpc |