pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Sandis Jerics <sandis@mediaparks.lv>
To: pgsql sql Mailing List <pgsql-sql@postgresql.org>
Subject: i have a big trouble
Date: Wed, 24 Jan 2001 13:50:04 +0200
Message-ID: <13115267721.20010124135004@mediaparks.lv> (raw)
In-Reply-To: <3A6EAEEC.B294361D@ualg.pt>
References: <3A6EAEEC.B294361D@ualg.pt>

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

Attachments:

row.txt (text/plain, 2.4K) download 45 a 2 2000-03-24 17:09:52+02 24.03.2000 ON THE RESULTS OF THE VISIT IN BRUSSELS Today on the 24th of March, the Minister of Defence, Mr. Ìirts Valdis Kristovskis, and Minister of Foreign Affairs, Mr. Indulis Bçrziòð, participated at the meeting of the North Atlantic Council and Latvia, led by the NATO Secretary General, Lord George Robertson. The Latvian representatives presented the Progress report on what has been accomplished and achieved in implementation of the Membership Action Plan (MAP) of Latvia for 2000. \ The Minister of Defence, Mr.Ìirts Valdis Kristovskis, in his speech informed ambassadors of the NATO member-countries, on what has been accomplished in the defence system of Latvia within MAP. Mr. Ì.V.Kristovskis noted, that Latvia's activity and full determination to participate in the process, is aimed at preparing Latvia to be ready to accept the invitation to join the North Atlantic Treaty Organisation at the next round of enlargement. At the same time Minister of Defence emphasised, that a lot still has to be done in improvement of the systems of procurement and military education. \ During the meeting it was noted that Latvia is one of the best NATO candidate - states as concerns the execution of the Membership Action Plan. It was also concluded at the session, that Membership Action Plan of Latvia for 2000 is well prepared, realistic, and financially well founded. The ambassadors of NATO member countries, acknowledged that Latvia has a systemic and purposeful approach in solving state defence related issues. \ Ambassadors of the NATO members states also positively evaluated Latvia's readiness to contribute to European security, more precisely - to participate by providing officers of the Latvian National Armed Forces for peace-keeping and peace - support missions in Bosnia - Hercegovina and Kosovo, as well as noting the close co-operation among the Baltic States themselves. \ Participants at the session also discussed the need for Latvia to enlarge her defence budget to 2% of the GDP, which is the average level of NATO countries. To this the Latvian representatives responded that the Government of Latvia has expressed the political will increasing state defence expenditures. Today at the session in Brussels, both the Minister of Defence, Ì.V.Kristovskis, and Minister of Foreign Affairs, once more stressed Latvia's strong determination to continue the initiated process of preparation for joining NATO.

view thread (2+ messages)  latest in thread

Message-ID: <13115267721.20010124135004@mediaparks.lv>
Permalink:  ../13115267721.20010124135004@mediaparks.lv/
Also on:    postgresql.org/message-id/13115267721.20010124135004@mediaparks.lv

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-sql@postgresql.org
  Cc: sandis@mediaparks.lv
  Subject: Re: i have a big trouble
  In-Reply-To: <13115267721.20010124135004@mediaparks.lv>
  References: <3A6EAEEC.B294361D@ualg.pt> <13115267721.20010124135004@mediaparks.lv>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox