Skip site navigation (1) Skip section navigation (2)

Re: timestamp out of range

From: Guillermo Muñoz <guillermo(dot)munoz(at)grupotekne(dot)com(dot)ar>
To: pgsql-es-ayuda(at)postgresql(dot)org
Subject: Re: timestamp out of range
Date: 2007-09-20 18:37:19
Message-ID: 00ad01c7fbb5$471ca360$2601010a@gg07030802 (view raw or flat)
Thread:
Lists: pgsql-es-ayuda
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.

In response to

pgsql-es-ayuda by date

Next:From: =?iso-8859-1?Q?Jos=E9_Ferm=EDn_Francisco_Ferreras?=Date: 2007-09-20 18:40:36
Subject: RE: select for update
Previous:From: LIZETH ANGHELA SIRPA CACERESDate: 2007-09-20 17:38:08
Subject: Re: URGENTE

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group