Postgres Pro
Downloads
Home   >   mailing lists

Type interval error in Postgresql7.1.3 - Mailing list pgsql-general

From Shabnam Nisha
Subject Type interval error in Postgresql7.1.3
Date
Msg-id 3CA23AA4.000024.83157@lady.is.com.fj
Whole thread Raw
List pgsql-general
Tree view
 
Hi Iam wondering if you can help me.
 
I have migrated my database from BSD to Red Hat 7.2. 
I am copying time (eg. 919) to an interval field. It is supposed to give me
 
@15mins 31secs, but comes up with an error
 
Error: Copy line 1. Bad interval external representation at '919'
 
In v6.5.3, it is not a problem, and converts blissfully. Is this a bug?
 
Appreciate your ideas.
 Pls help!
 `Nisha.
--
Liam Stewart :: Red Hat Canada, Ltd. :: liams@redhat.com
____________________________________________________
 IncrediMail - Email has finally evolved - Click Here

pgsql-general by date:

Previous
From: pgsql-gen Newsgroup (@Basebeans.com)
Date:
Subject: Re: Performance question.
Next
From:
Date:
Subject: Rules on update behavior unexplained ... --> inheritance problem (I believe)