Re: timestamp out of range

Perdonen que retome el tema, pero ahora es con el pg_dump

pg_dump: reading dependency data
pg_dump: saving encoding = UTF8
pg_dump: saving standard_conforming_strings = off
pg_dump: saving database definition
pg_dump: SQL command failed
pg_dump: Error message from server: ERROR: timestamp out of range
pg_dump: The command was: FETCH 100 FROM _pg_dump_cursor
pg_dump: *** aborted because of error

----- Original Message -----
From: Calabaza Calabaza
To: pgsql-es-ayuda(at)postgresql(dot)org
Sent: Wednesday, September 19, 2007 11:21 AM
Subject: Re: [pgsql-es-ayuda] timestamp out of range

Te puedo mostrar la prueba que hice:
Ejecutando:

SELECT version()

SELECT current_setting('datestyle');

create table fechas (fecha varchar(10));

insert into fechas values('1984-06-14');
insert into fechas values('1983-02-21');
insert into fechas values('1989-06-13');

Select
fecha::timestamp without time zone
from fechas;

Estos fueron mis resultados:

"PostgreSQL 8.0.3 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC)
3.4.2 (mingw-special)"

"ISO, MDY"

"1984-06-14 00:00:00"
"1983-02-21 00:00:00"
"1989-06-13 00:00:00"

No tengo un 8.2.4 a mano para probarlo, espero que te sirva.
--
§~^Calabaza^~§ from Villa Elisa, Paraguay
--
TIP 8: explain analyze es tu amigo

--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.485 / Virus Database: 269.13.21/1012 - Release Date: 16/09/2007 06:32 p.m.