Type interval error in Postgresql7.1.3

From: "Shabnam Nisha" <nisha(at)is(dot)com(dot)fj>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Type interval error in Postgresql7.1.3
Date: 2002-03-27 21:33:24
Message-ID: 3CA23AA4.000024.83157@lady.is.com.fj
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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(at)redhat(dot)com

Browse pgsql-general by date

  From Date Subject
Next Message tsmets 2002-03-27 22:39:43 Rules on update behavior unexplained ... --> inheritance problem (I believe)
Previous Message pgsql-gen Newsgroup (@Basebeans.com) 2002-03-27 20:40:02 Re: Performance question.