X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 678A49DCC61 for ; Wed, 22 Mar 2006 08:33:11 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 33704-05 for ; Wed, 22 Mar 2006 08:33:13 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from nproxy.gmail.com (nproxy.gmail.com [64.233.182.199]) by postgresql.org (Postfix) with ESMTP id CD7279DCC0D for ; Wed, 22 Mar 2006 08:33:08 -0400 (AST) Received: by nproxy.gmail.com with SMTP id c29so94322nfb for ; Wed, 22 Mar 2006 04:33:11 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=bzvilyJOrdoD6MtxQLpvhFNtOeB+5ywnup7X2nwzNljgroWU4wZ6NembQ7swaMB+lUjBxtHDCGA51Gepf54f6+1+JVsTdp+8kqAYCjafGCBa2wbya6J+LeAtgRWUV2WBkzZ4mOPHPMG/4QuVOUWxfZ44Zt4hst4yXMK6qZMGp0k= Received: by 10.48.202.16 with SMTP id z16mr199400nff; Wed, 22 Mar 2006 04:33:11 -0800 (PST) Received: by 10.48.163.2 with HTTP; Wed, 22 Mar 2006 04:33:11 -0800 (PST) Message-ID: Date: Wed, 22 Mar 2006 20:33:11 +0800 From: JSP To: Luckys Subject: Re: COPY tablename FROM and null values Cc: marchesini@unipg.it, "Achilleus Mantzios" , pgsql-sql@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_7696_32032780.1143030791307" References: <1143026331.4730.23.camel@geologia5.agora.ing.unipg.it> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.001 required=5 tests=[HTML_MESSAGE=0.001] X-Spam-Score: 0.001 X-Spam-Level: X-Archive-Number: 200603/350 X-Sequence-Number: 24696 ------=_Part_7696_32032780.1143030791307 Content-Type: text/plain; charset=ISO-8859-7 Content-Transfer-Encoding: base64 Content-Disposition: inline eXVwLi4uIFJlcGxhY2UgdGhlIGVtcHR5IHNwYWNlcyBpbiB0aGUgZmlsZSB3aXRoIHNvbWUgb3Ro ZXIgdmFsdWUuLi4KCnJlcGxhY2UgbnVsbCB2YWx1ZXMgd2l0aCBcTgoKdGhlbiB0cnkgQ09QWWlu ZyBhZ2FpbgoKT24gMy8yMi8wNiwgTHVja3lzIDxwbHBnc3FsQGdtYWlsLmNvbT4gd3JvdGU6Cj4K Pgo+Cj4gT24gMy8yMi8wNiwgQWNoaWxsZXVzIE1hbnR6aW9zIDxhY2hpbGxAbWF0cml4LmdhdGV3 YXluZXQuY29tPiB3cm90ZToKPiA+Cj4gPiBPIGl2YW4gbWFyY2hlc2luaSDd4/Hh+OUg8/Tp8iBN YXIgMjIsIDIwMDYgOgo+ID4KPiA+ID4gRGVhciB1c2VycywKPiA+ID4gSSdtIHdvcmtpbmcgb24g YSBQb3N0Z3JlcyA3LjQgc2VydmVyCj4gPiA+Cj4gPiA+IEkgaGF2ZSBhIC50eHQgZmlsZSwgY29u dGFpbmluZyBzb21lIHRhYnVsYXIgZGF0YSwgd2hlcmUgZGF0YSBhcmUKPiA+ID4gZGVsaW1pdGVk IGJ5IFRBQnMuCj4gPiA+IHRoZXJlIGFyZSAzIGNvbHVtbnM6Cj4gPiA+Cj4gPiA+IGNvbHVtbjEg aW50NCwgY29sdW1uMiBmbG9hdDgsIGNvbHVtbjMgZmxvYXQ4Cj4gPiA+Cj4gPiA+IHRoZSBwcm9i bGVtIGlzIHRoYXQgY29sdW1uMyBjb250YWlucyBhbHNvIG51bGwgdmFsdWVzICggaS5lLiBzb21l dGltZXMKPiA+IGlzCj4gPiA+IGVtcHR5KQo+ID4gPgo+ID4gPiBzbyB3aGVuIEkgdHJ5IHRvIHVz ZSBDT1BZIHRhYmxlbmFtZSBGUk9NICdmaWxlbmFtZS50eHQnIEkgb2J0YWluIGFuCj4gPiA+IGVy cm9yCj4gPiA+Cj4gPiA+IEkgaGF2ZSB0cmllZCBhbHNvIHVzaW5nICIgV0lUSCBOVUxMIEFTICcg JyAiIGJ1dCB3aXRob3V0IGdvb2QKPiA+IHJlc3VsdHMuLi4KPiA+ID4KPiA+ID4gY2FuIHNvbWVv bmUgZXhwbGFpbiBtZSBob3cgdG8gc29sdmUgdGhpcyBwcm9ibGVtPz8/Cj4gPgo+ID4gYmF0Y2gg ZWRpdCB5b3VyIGZpbGUgKHdpdGggc2VkLGF3ayxwZXJsLEMsamF2YSwuLi4pIGFuZCBidWlsZCB5 b3VyCj4gPiBleHBsaWNpdCBJTlNFUlQgc3RhdGVtZW50cyBpbiBzb21lIHZlcnNpb24gb2YgeW91 ciBmaWxlLgo+Cj4KPiBvciBSZXBsYWNlIHRoZSBlbXB0eSBzcGFjZXMgaW4gdGhlIGZpbGUgd2l0 aCBzb21lIG90aGVyIHZhbHVlICgwLjApCj4KPiA+Cj4gPiA+IHRoYW5rIHlvdSB2ZXJ5IG11Y2gK PiA+ID4KPiA+ID4gSXZhbgo+ID4gPgo+ID4gPgo+ID4gPgo+ID4gPgo+ID4gPgo+ID4KPiA+IC0t Cj4gPiAtQWNoaWxsZXVzCj4gPgo+ID4KPiA+IC0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLShl bmQgb2YgYnJvYWRjYXN0KS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQo+ID4gVElQIDU6IGRv bid0IGZvcmdldCB0byBpbmNyZWFzZSB5b3VyIGZyZWUgc3BhY2UgbWFwIHNldHRpbmdzCj4gPgo+ Cj4KCgotLQoKCiJUaGUgdHJvdWJsZSB3aXRoIHRoZSByYXQgcmFjZSBpcyB0aGF0IGV2ZW4gaWYg eW91IHdpbiwgeW91J3JlIHN0aWxsIGEgcmF0LiIKLS0tIExpbHkgVG9tbGluCg== ------=_Part_7696_32032780.1143030791307 Content-Type: text/html; charset=ISO-8859-7 Content-Transfer-Encoding: base64 Content-Disposition: inline eXVwLi4uIFJlcGxhY2UgdGhlIGVtcHR5IHNwYWNlcyBpbiB0aGUgZmlsZSB3aXRoIHNvbWUgb3Ro ZXIgdmFsdWUuLi4gPGJyPgo8YnI+CnJlcGxhY2UgbnVsbCB2YWx1ZXMgd2l0aCBcTjxicj4KPGJy Pgp0aGVuIHRyeSBDT1BZaW5nIGFnYWluPGJyPjxicj48ZGl2PjxzcGFuIGNsYXNzPSJnbWFpbF9x dW90ZSI+T24gMy8yMi8wNiwgPGIgY2xhc3M9ImdtYWlsX3NlbmRlcm5hbWUiPkx1Y2t5czwvYj4g Jmx0OzxhIGhyZWY9Im1haWx0bzpwbHBnc3FsQGdtYWlsLmNvbSI+cGxwZ3NxbEBnbWFpbC5jb208 L2E+Jmd0OyB3cm90ZTo8L3NwYW4+PGJsb2NrcXVvdGUgY2xhc3M9ImdtYWlsX3F1b3RlIiBzdHls ZT0iYm9yZGVyLWxlZnQ6IDFweCBzb2xpZCByZ2IoMjA0LCAyMDQsIDIwNCk7IG1hcmdpbjogMHB0 IDBwdCAwcHQgMC44ZXg7IHBhZGRpbmctbGVmdDogMWV4OyI+CjxkaXYgc3R5bGU9ImRpcmVjdGlv bjogbHRyOyI+PGJyPjxicj4KPGRpdj48L2Rpdj48ZGl2IHN0eWxlPSJkaXJlY3Rpb246IGx0cjsi PjxzcGFuIGNsYXNzPSJxIj48c3BhbiBjbGFzcz0iZ21haWxfcXVvdGUiPk9uIDMvMjIvMDYsIDxi IGNsYXNzPSJnbWFpbF9zZW5kZXJuYW1lIj5BY2hpbGxldXMgTWFudHppb3M8L2I+ICZsdDs8YSBo cmVmPSJtYWlsdG86YWNoaWxsQG1hdHJpeC5nYXRld2F5bmV0LmNvbSIgdGFyZ2V0PSJfYmxhbmsi IG9uY2xpY2s9InJldHVybiB0b3AuanMuT3BlbkV4dExpbmsod2luZG93LGV2ZW50LHRoaXMpIj4K YWNoaWxsQG1hdHJpeC5nYXRld2F5bmV0LmNvbTwvYT4mZ3Q7IHdyb3RlOjwvc3Bhbj4KPGJsb2Nr cXVvdGUgY2xhc3M9ImdtYWlsX3F1b3RlIiBzdHlsZT0iYm9yZGVyLWxlZnQ6IDFweCBzb2xpZCBy Z2IoMjA0LCAyMDQsIDIwNCk7IG1hcmdpbjogMHB4IDBweCAwcHggMC44ZXg7IHBhZGRpbmctbGVm dDogMWV4OyI+TyBpdmFuIG1hcmNoZXNpbmkg3ePx4fjlIPP06fIgTWFyIDIyLCAyMDA2IDo8YnI+ PGJyPiZndDsgRGVhciB1c2Vycyw8YnI+Jmd0OyBJJ20gd29ya2luZyBvbiBhIFBvc3RncmVzIAo3 LjQKIHNlcnZlcjxicj4mZ3Q7PGJyPiZndDsgSSBoYXZlIGEgLnR4dCBmaWxlLCBjb250YWluaW5n IHNvbWUgdGFidWxhciBkYXRhLCB3aGVyZSBkYXRhIGFyZTxicj4mZ3Q7IGRlbGltaXRlZCBieSBU QUJzLjxicj4mZ3Q7IHRoZXJlIGFyZSAzIGNvbHVtbnM6PGJyPiZndDs8YnI+Jmd0OyBjb2x1bW4x IGludDQsIGNvbHVtbjIgZmxvYXQ4LCBjb2x1bW4zIGZsb2F0ODxicj4mZ3Q7PGJyPiZndDsgdGhl IHByb2JsZW0gaXMgdGhhdCBjb2x1bW4zIGNvbnRhaW5zIGFsc28gbnVsbCB2YWx1ZXMgKAppLmUu IHNvbWV0aW1lcyBpczxicj4mZ3Q7IGVtcHR5KTxicj4mZ3Q7PGJyPiZndDsgc28gd2hlbiBJIHRy eSB0byB1c2UgQ09QWSB0YWJsZW5hbWUgRlJPTSAnZmlsZW5hbWUudHh0JyBJIG9idGFpbiBhbjxi cj4mZ3Q7IGVycm9yPGJyPiZndDs8YnI+Jmd0OyBJIGhhdmUgdHJpZWQgYWxzbyB1c2luZyAmcXVv dDsgV0lUSCBOVUxMIEFTICcgJyAmcXVvdDsgYnV0IHdpdGhvdXQgZ29vZCByZXN1bHRzLi4uCjxi cj4mZ3Q7PGJyPiZndDsgY2FuIHNvbWVvbmUgZXhwbGFpbiBtZSBob3cgdG8gc29sdmUgdGhpcyBw cm9ibGVtPz8/PGJyPjxicj5iYXRjaCBlZGl0IHlvdXIgZmlsZSAod2l0aCBzZWQsYXdrLHBlcmws QyxqYXZhLC4uLikgYW5kIGJ1aWxkIHlvdXI8YnI+ZXhwbGljaXQgSU5TRVJUIHN0YXRlbWVudHMg aW4gc29tZSB2ZXJzaW9uIG9mIHlvdXIgZmlsZS48L2Jsb2NrcXVvdGU+CjxkaXY+Jm5ic3A7PC9k aXY+PC9zcGFuPjwvZGl2PjxkaXYgc3R5bGU9ImRpcmVjdGlvbjogbHRyOyI+CjxkaXY+b3IgUmVw bGFjZSB0aGUgZW1wdHkgc3BhY2VzIGluIHRoZSBmaWxlIHdpdGggc29tZSBvdGhlciB2YWx1ZSAo MC4wKTwvZGl2PjwvZGl2PjxkaXYgc3R5bGU9ImRpcmVjdGlvbjogbHRyOyI+PHNwYW4gY2xhc3M9 InEiPjxicj4KPGJsb2NrcXVvdGUgY2xhc3M9ImdtYWlsX3F1b3RlIiBzdHlsZT0iYm9yZGVyLWxl ZnQ6IDFweCBzb2xpZCByZ2IoMjA0LCAyMDQsIDIwNCk7IG1hcmdpbjogMHB4IDBweCAwcHggMC44 ZXg7IHBhZGRpbmctbGVmdDogMWV4OyI+Jmd0Ozxicj4mZ3Q7IHRoYW5rIHlvdSB2ZXJ5IG11Y2g8 YnI+Jmd0Ozxicj4mZ3Q7IEl2YW48YnI+Jmd0Ozxicj4mZ3Q7PGJyPiZndDs8YnI+Jmd0Ozxicj4m Z3Q7Cjxicj48YnI+LS08YnI+Ci1BY2hpbGxldXM8YnI+PGJyPjxicj4tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0oZW5kIG9mIGJyb2FkY2FzdCktLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS08 YnI+VElQIDU6IGRvbid0IGZvcmdldCB0byBpbmNyZWFzZSB5b3VyIGZyZWUgc3BhY2UgbWFwIHNl dHRpbmdzPGJyPjwvYmxvY2txdW90ZT48L3NwYW4+PC9kaXY+PGRpdiBzdHlsZT0iZGlyZWN0aW9u OiBsdHI7Ij48L2Rpdj4KPGJyPgo8L2Rpdj48L2Jsb2NrcXVvdGU+PC9kaXY+PGJyPjxiciBjbGVh cj0iYWxsIj48YnI+LS0gPGJyPjxicj48YnI+JnF1b3Q7VGhlIHRyb3VibGUgd2l0aCB0aGUgcmF0 IHJhY2UgaXMgdGhhdCBldmVuIGlmIHlvdSB3aW4sIHlvdSdyZSBzdGlsbCBhIHJhdC4mcXVvdDsg LS0tIExpbHkgVG9tbGluCg== ------=_Part_7696_32032780.1143030791307--