inserting timestamp values

From: Alex Guryanow <gav(at)nlr(dot)ru>
To: pgsql-general(at)postgreSQL(dot)org
Subject: inserting timestamp values
Date: 2000-01-20 17:33:01
Message-ID: 13856.000120@nlr.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I have troubles inserting the timestamp values. I use postgresql 6.5.3
on RedHat 6.1 (kernel 2.2.13). I do the following

sample==> create table t1 (d timestamp);
CREATE
sample==> create index t1_d on t1 using btree (d datetime_ops);
CREATE
sample==> insert into t1 (d) values ('1999-01-01 14:00:00+03');
INSERT 4668876 1
sample==> insert into t1 (d) values ('1999-01-01 14:00:00+03');
pqReadData() -- backend closed the channel unexpectedly.
This possible means the backend terminated abnormally
before or while processing the request.
We have lost the connection to the backend, so further processing is
impossible. Terminating.

Can anybody help me to solve this problem ?

Best regards,
Alex

P.S. Before this experiment I have the database in postgresql 6.5.3
too. One of tables in this database contains the timestamp field. I
used the pg_dump utility to backup this database and received the flat
file where all values of this field are in the format
'YYYY-mm-dd HH:MM:SS+04'. When I try to restore the database using
this backup-file:

psql mydata < <backup-file>

I receive the error as above.

Browse pgsql-general by date

  From Date Subject
Next Message Sarah Officer 2000-01-20 17:38:59 psql parsing and variable problems
Previous Message Sevo Stille 2000-01-20 16:39:17 Re: [GENERAL] R-trees - any documentation?