i have a big trouble
От | Sandis Jerics |
---|---|
Тема | i have a big trouble |
Дата | |
Msg-id | 13115267721.20010124135004@mediaparks.lv обсуждение исходный текст |
Ответ на | Use of INNER JOIN and others ??!? (Luis Sousa <llsousa@ualg.pt>) |
Ответы |
Re: i have a big trouble
|
Список | 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 ArmedForces. 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 ArmedForces. 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
Вложения
В списке pgsql-sql по дате отправления: