i have a big trouble

From: Sandis Jerics <sandis(at)mediaparks(dot)lv>
To: pgsql sql Mailing List <pgsql-sql(at)postgresql(dot)org>
Subject: i have a big trouble
Date: 2001-01-24 11:50:04
Message-ID: 13115267721.20010124135004@mediaparks.lv
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hello list,

i expirienced that postgres seems doesn't want to eat it's own
dump... why? even freshly created!
whats wrong with me?

www_mod_lv=> \copy news from '/home/sites/www.mod.lv/web/news.sql'
\.
ERROR: copy: line 2, pg_atoi: error in "
At the international humanitarian mission of KFOR the Latvian unit participates with 10 soldiers from the National Armed Forces. The KFOR Latvian contingent - Military Police and medical units - will operate within the contingent of UK. "
: can't parse "
At the international humanitarian mission of KFOR the Latvian unit participates with 10 soldiers from the National Armed Forces. The KFOR Latvian contingent - Military Police and medical units - will operate within the contingent of UK. "
PQendcopy: resetting connection

i tried to do \copy from stdin, than throw in a one row of data, ended
with \., it doesnt work also.

This is my table:

CREATE TABLE news(
id SERIAL PRIMARY KEY,
flag CHAR(1) NOT NULL,
rubrika CHAR(1) NOT NULL,
datums_ TIMESTAMP NOT NULL,
datums VARCHAR(30) NOT NULL,
virsraksts VARCHAR(200) NOT NULL,
teksts TEXT,
url VARCHAR(30),
url_txt VARCHAR(50)
);

an example row of data (tab separated) attached.

anyone may have an idea?

--
Sandis
7777609
9237502

Attachment Content-Type Size
row.txt text/plain 2.4 KB

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Som 2001-01-24 11:53:12 Some queries
Previous Message Oliver Elphick 2001-01-24 10:54:35 Re: DATE