Bad date external representation Was :[problems using pg_dump and datestyle format] - Mailing list pgsql-admin

From Leandro Rodrigo Saad Cruz
Subject Bad date external representation Was :[problems using pg_dump and datestyle format]
Date
Msg-id 3BA0BCCD.74040F2F@ibnetwork.com.br
Whole thread Raw
In response to problems using pg_dump and datestyle format  (Leandro Rodrigo Saad Cruz <leandro@ibnetwork.com.br>)
List pgsql-admin
Hi, I searched the mailing list and I am stuck.

INFO :

> monitorar=# SHOW DateStyle ;
> NOTICE:  DateStyle is SQL with European conventions
> SHOW VARIABLE
>
> monitorar=# SELECT oid from reservas where data_comp = '20/08/2001';
>  oid
> --------
> 254376
> (1 row)
>
> monitorar=# \d reservas
>                   Table "reservas"
>     Attribute     |         Type          | Modifier
> -------------------+-----------------------+----------
>  flag              | smallint              |
>  num_org           | character varying(6)  |
>  nome_org          | character varying(30) |
>  tipo_reserva      | character varying(3)  |
>  num_reserva       | bigint                | not null
>  sequencia         | character varying(4)  | not null
>  cod_material      | character varying(20) |
>  desc_material     | character varying(30) |
>  unidade           | character varying(2)  |
>  quant_total       | integer               |
>  quant_atendida_ac | integer               |
>  quant_dia         | integer               |
>  quant_pendente    | integer               |
>  data_integracao   | date                  |
>  data_necessidade  | date                  |
>  data_separacao    | date                  |
>  data_nf           | date                  |
>  data_envio        | date                  |
>  data_entrega      | date                  |
>  num_nf            | character varying(10) |
>  num_conhecimento  | character varying(10) |
>  nome_trans        | character varying(30) |
>  data_comp         | date                  |
> Indices: data_comp_reservas_key,
>          reservas_pkey


PROBLEM :

> monitorar=# SELECT oid from reservas where data_comp < '20/08/2001';
> ERROR:  Bad date external representation '08/20/2001'

--
Leandro Rodrigo Saad Cruz
IT - Inter Business Tecnologia e Servicos (IB)

Attachment

pgsql-admin by date:

Previous
From: Leandro Rodrigo Saad Cruz
Date:
Subject: Bad date external representation Was :[problems using pg_dump and datestyle format]
Next
From: "Tauren Mills"
Date:
Subject: Problem with database: FATAL 1: cannot find attribute 24 of relation