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 |
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 |