Received: from vmx.mediaparks.lv (vmx.mediaparks.lv [62.85.15.11]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f0OBoQ091024 for ; Wed, 24 Jan 2001 06:50:26 -0500 (EST) (envelope-from sandis@mediaparks.lv) Received: (from mail@localhost) by vmx.mediaparks.lv (8.9.3/8.9.3) id NAA48724 for pgsql-sql@postgresql.org; Wed, 24 Jan 2001 13:50:23 +0200 (EET) (envelope-from sandis@mediaparks.lv) X-Authentication-Warning: vmx.mediaparks.lv: mail set sender to sandis@mediaparks.lv using -f Received: from 195.2.123.209 by 62.85.15.11 id Ecx1SRt7 ; 24 Jan 2001 13:50:09 EET Date: Wed, 24 Jan 2001 13:50:04 +0200 From: Sandis Jerics X-Mailer: The Bat! (v1.48d) Personal Reply-To: Sandis Jerics Organization: Mediaparks X-Priority: 3 (Normal) Message-ID: <13115267721.20010124135004@mediaparks.lv> To: pgsql sql Mailing List Subject: i have a big trouble In-reply-To: <3A6EAEEC.B294361D@ualg.pt> References: <3A6EAEEC.B294361D@ualg.pt> Mime-Version: 1.0 Content-Type: multipart/mixed; boundary="----------39119736E39558" X-Archive-Number: 200101/319 X-Sequence-Number: 991 ------------39119736E39558 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit 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 ------------39119736E39558 Content-Type: text/plain; name="row.txt" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="row.txt" NDUJYQkyCTIwMDAtMDMtMjQgMTc6MDk6NTIrMDIJMjQuMDMuMjAwMAlPTiBU SEUgUkVTVUxUUyBPRiBUSEUgVklTSVQgSU4gQlJVU1NFTFMJVG9kYXkgb24g dGhlIDI0dGggb2YgTWFyY2gsIHRoZSBNaW5pc3RlciBvZiBEZWZlbmNlLCBN ci4gzGlydHMgVmFsZGlzIEtyaXN0b3Zza2lzLCBhbmQgTWluaXN0ZXIgb2Yg Rm9yZWlnbiBBZmZhaXJzLCBNci4gSW5kdWxpcyBC53J6afLwLCBwYXJ0aWNp cGF0ZWQgYXQgdGhlIG1lZXRpbmcgb2YgdGhlIE5vcnRoIEF0bGFudGljIENv dW5jaWwgYW5kIExhdHZpYSwgbGVkIGJ5IHRoZSBOQVRPIFNlY3JldGFyeSBH ZW5lcmFsLCBMb3JkIEdlb3JnZSBSb2JlcnRzb24uIFRoZSBMYXR2aWFuIHJl cHJlc2VudGF0aXZlcyBwcmVzZW50ZWQgdGhlIFByb2dyZXNzIHJlcG9ydCBv biB3aGF0IGhhcyBiZWVuIGFjY29tcGxpc2hlZCBhbmQgYWNoaWV2ZWQgaW4g aW1wbGVtZW50YXRpb24gb2YgdGhlIE1lbWJlcnNoaXAgQWN0aW9uIFBsYW4g KE1BUCkgb2YgTGF0dmlhIGZvciAyMDAwLiANClwNClRoZSBNaW5pc3RlciBv ZiBEZWZlbmNlLCBNci7MaXJ0cyBWYWxkaXMgS3Jpc3RvdnNraXMsIGluIGhp cyBzcGVlY2ggaW5mb3JtZWQgYW1iYXNzYWRvcnMgb2YgdGhlIE5BVE8gbWVt YmVyLWNvdW50cmllcywgb24gd2hhdCBoYXMgYmVlbiBhY2NvbXBsaXNoZWQg aW4gdGhlIGRlZmVuY2Ugc3lzdGVtIG9mIExhdHZpYSB3aXRoaW4gTUFQLiBN ci4gzC5WLktyaXN0b3Zza2lzIG5vdGVkLCB0aGF0IExhdHZpYSdzIGFjdGl2 aXR5ICBhbmQgZnVsbCBkZXRlcm1pbmF0aW9uIHRvIHBhcnRpY2lwYXRlIGlu IHRoZSBwcm9jZXNzLCBpcyBhaW1lZCBhdCBwcmVwYXJpbmcgTGF0dmlhIHRv IGJlIHJlYWR5IHRvIGFjY2VwdCB0aGUgaW52aXRhdGlvbiB0byBqb2luIHRo ZSBOb3J0aCBBdGxhbnRpYyBUcmVhdHkgT3JnYW5pc2F0aW9uIGF0IHRoZSBu ZXh0IHJvdW5kIG9mIGVubGFyZ2VtZW50LiBBdCB0aGUgc2FtZSB0aW1lIE1p bmlzdGVyIG9mIERlZmVuY2UgZW1waGFzaXNlZCwgdGhhdCBhIGxvdCBzdGls bCBoYXMgdG8gYmUgZG9uZSBpbiBpbXByb3ZlbWVudCBvZiB0aGUgc3lzdGVt cyBvZiBwcm9jdXJlbWVudCBhbmQgbWlsaXRhcnkgZWR1Y2F0aW9uLiANClwN CkR1cmluZyB0aGUgbWVldGluZyBpdCB3YXMgbm90ZWQgdGhhdCBMYXR2aWEg aXMgb25lIG9mIHRoZSBiZXN0IE5BVE8gY2FuZGlkYXRlIC0gc3RhdGVzIGFz IGNvbmNlcm5zIHRoZSBleGVjdXRpb24gb2YgdGhlIE1lbWJlcnNoaXAgQWN0 aW9uIFBsYW4uIEl0IHdhcyBhbHNvIGNvbmNsdWRlZCBhdCB0aGUgc2Vzc2lv biwgdGhhdCBNZW1iZXJzaGlwIEFjdGlvbiBQbGFuIG9mIExhdHZpYSBmb3Ig MjAwMCBpcyB3ZWxsIHByZXBhcmVkLCByZWFsaXN0aWMsIGFuZCBmaW5hbmNp YWxseSB3ZWxsIGZvdW5kZWQuIFRoZSBhbWJhc3NhZG9ycyBvZiBOQVRPIG1l bWJlciBjb3VudHJpZXMsIGFja25vd2xlZGdlZCB0aGF0IExhdHZpYSBoYXMg YSBzeXN0ZW1pYyBhbmQgcHVycG9zZWZ1bCBhcHByb2FjaCBpbiBzb2x2aW5n IHN0YXRlIGRlZmVuY2UgcmVsYXRlZCBpc3N1ZXMuICANClwNCkFtYmFzc2Fk b3JzIG9mIHRoZSBOQVRPIG1lbWJlcnMgc3RhdGVzIGFsc28gcG9zaXRpdmVs eSBldmFsdWF0ZWQgTGF0dmlhJ3MgcmVhZGluZXNzIHRvIGNvbnRyaWJ1dGUg dG8gRXVyb3BlYW4gc2VjdXJpdHksIG1vcmUgcHJlY2lzZWx5IC0gdG8gcGFy dGljaXBhdGUgYnkgcHJvdmlkaW5nIG9mZmljZXJzIG9mIHRoZSBMYXR2aWFu IE5hdGlvbmFsIEFybWVkIEZvcmNlcyBmb3IgcGVhY2Uta2VlcGluZyBhbmQg cGVhY2UgLSBzdXBwb3J0IG1pc3Npb25zIGluIEJvc25pYSAtIEhlcmNlZ292 aW5hIGFuZCBLb3Nvdm8sIGFzIHdlbGwgYXMgbm90aW5nIHRoZSBjbG9zZSBj by1vcGVyYXRpb24gYW1vbmcgdGhlIEJhbHRpYyBTdGF0ZXMgdGhlbXNlbHZl cy4gDQpcDQpQYXJ0aWNpcGFudHMgYXQgdGhlIHNlc3Npb24gYWxzbyBkaXNj dXNzZWQgdGhlIG5lZWQgZm9yIExhdHZpYSB0byBlbmxhcmdlIGhlciBkZWZl bmNlIGJ1ZGdldCB0byAyJSBvZiB0aGUgR0RQLCB3aGljaCBpcyB0aGUgYXZl cmFnZSBsZXZlbCBvZiBOQVRPIGNvdW50cmllcy4gVG8gdGhpcyB0aGUgTGF0 dmlhbiByZXByZXNlbnRhdGl2ZXMgcmVzcG9uZGVkIHRoYXQgdGhlIEdvdmVy bm1lbnQgb2YgTGF0dmlhIGhhcyBleHByZXNzZWQgdGhlIHBvbGl0aWNhbCB3 aWxsIGluY3JlYXNpbmcgc3RhdGUgZGVmZW5jZSBleHBlbmRpdHVyZXMuIFRv ZGF5IGF0IHRoZSBzZXNzaW9uIGluIEJydXNzZWxzLCBib3RoIHRoZSBNaW5p c3RlciBvZiBEZWZlbmNlLCDMLlYuS3Jpc3RvdnNraXMsIGFuZCBNaW5pc3Rl ciBvZiBGb3JlaWduIEFmZmFpcnMsIG9uY2UgbW9yZSBzdHJlc3NlZCBMYXR2 aWEncyBzdHJvbmcgZGV0ZXJtaW5hdGlvbiB0byBjb250aW51ZSB0aGUgaW5p dGlhdGVkIHByb2Nlc3Mgb2YgcHJlcGFyYXRpb24gZm9yIGpvaW5pbmcgTkFU Ty4JCQ== ------------39119736E39558--