Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1XPWaM-0000Y9-Kg for pgsql-admin@arkaria.postgresql.org; Thu, 04 Sep 2014 12:56:22 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1XPWaL-0002eI-Vs for pgsql-admin@arkaria.postgresql.org; Thu, 04 Sep 2014 12:56:22 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1XPWaK-0002e2-L0; Thu, 04 Sep 2014 12:56:20 +0000 Received: from mailfilter.invera.com ([198.168.207.50]) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1XPWaG-0003Dh-KN; Thu, 04 Sep 2014 12:56:18 +0000 Received: from epgate.invera.com (localhost.localdomain [127.0.0.1]) by epgate.invera.com (Postfix-out) with ESMTP id E20853C5BEC; Thu, 4 Sep 2014 08:56:15 -0400 (EDT) X-Propel-Return-Path: Received: from mailfilter.invera.com ([172.20.200.19]) by [127.0.0.1] ([127.0.0.1]) (port 7027) (Abaca EPG outproxy filter 3.1.1.9369 $Rev: 9262 $) id rfTOre94cUf0; Thu, 04 Sep 2014 08:56:15 -0400 Received: from Exch2.invera.com (exch2.invera.com [172.20.35.3]) by epgate.invera.com (Postfix-out) with ESMTP id A6DBF3C5BE6; Thu, 4 Sep 2014 08:56:15 -0400 (EDT) Received: from EXCH2.invera.com (172.20.35.3) by Exch2.invera.com (172.20.35.3) with Microsoft SMTP Server (TLS) id 15.0.913.22; Thu, 4 Sep 2014 08:56:14 -0400 Received: from EXCH2.invera.com ([fe80::3999:28ea:6cf1:1e83]) by Exch2.invera.com ([fe80::3999:28ea:6cf1:1e83%12]) with mapi id 15.00.0913.011; Thu, 4 Sep 2014 08:56:14 -0400 From: Alanoly Andrews To: 'Adrian Klaver' , 'Craig James' CC: "pgsql-admin@postgresql.org" , "pgsql-general@postgresql.org" Subject: Re: [GENERAL] Re: Cannot retrieve images inserted through VB and odbc, after a table reorganization. Thread-Topic: [GENERAL] Re: [ADMIN] Cannot retrieve images inserted through VB and odbc, after a table reorganization. Thread-Index: AQHPx6rCoI/P4HPeh0ugQoAqqnRZf5vw7TDw Date: Thu, 4 Sep 2014 12:56:14 +0000 Message-ID: References: <6909b219ecae4d41b431efdaf6c953a3@Exch2.invera.com> <5407679B.2030906@aklaver.com> In-Reply-To: <5407679B.2030906@aklaver.com> Accept-Language: en-GB, en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [172.20.200.88] Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 MIME-Version: 1.0 X-Propel-ID: rfTOre94cUf0 X-Pg-Spam-Score: -3.5 (---) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org SGkgQWRyaWFuLA0KDQpUaGFua3MgZm9yIHRoYXQgZXhwbGFuYXRpb24gb2Yg aG93IHRoZSAicmVsZmlsZW5vZGUiIGNoYW5nZXMgYWZ0ZXIgYSB0YWJsZSBy ZW9yZ2FuaXphdGlvbi4gSXQgaXMgbm90IHN1cnByaXNpbmcgdGhhdCB0aGlz IGhhcHBlbnMgYmVjYXVzZSB0aGUgdGFibGUgcm93cyBhcmUgYmVpbmcgcGh5 c2ljYWxseSBtb3ZlZCBmcm9tIG9uZSBsb2NhdGlvbiB0byBhbm90aGVyLiBC dXQgc3VjaCBjaGFuZ2VzIGF0IHRoZSBiYWNrZW5kIHNob3VsZCBiZSB0cmFu c3BhcmVudCB0byB0aGUgZW5kIHVzZXIuIFRoZSBWQiBjb2RlIGF0IHRoZSBj bGllbnQgc2lkZSBydW5zIGEgc2ltcGxlIHNxbCBsaWtlICJzZWxlY3QgaW1h Z2UgZnJvbSBpbWFnZV90YWJsZSB3aGVyZSBpbWFnZV9rZXk9c29tZXZhbHVl Ii4gVGhlcmUgaXMgbm8gcmVmZXJlbmNlIHRvIHBvc3RncmVzLXNwZWNpZmlj IGludGVybmFsIHZhcmlhYmxlcyBsaWtlICJvaWQiIGFuZCAicmVsZmlsZW5v ZGUiLiBJIGRvIG5vdCBrbm93IHRoZSBpbm5lciB3b3JraW5ncyBvZiB0aGUg cG9zdGdyZXMgb2RiYyBkcml2ZXI7IGJ1dCBJIHdvdWxkIGJlIHN1cnByaXNl ZCBpZiBpdCB3b3JrcyBhdCB0aGUgZ3JhbnVsYXJpdHkgb2YgIm9pZCIgYW5k ICJyZWxmaWxlbm9kZSIgYW5kIHRoYXQgaXQgd291bGQgc3RvcmUgdGhlIGFj dHVhbCBwaHlzaWNhbCB2YWx1ZXMgb2YgcmVsZmlsZW5vZGUgKHdoaWNoIHdv dWxkIGtlZXAgY2hhbmdpbmcgYWZ0ZXIgZXZlcnkgdGFibGUgcmVsb2FkLCBy ZW9yZyBldGMuKS4NCg0KQWxhbm9seS4NCg0KLS0tLS1PcmlnaW5hbCBNZXNz YWdlLS0tLS0NCkZyb206IEFkcmlhbiBLbGF2ZXIgW21haWx0bzphZHJpYW4u a2xhdmVyQGFrbGF2ZXIuY29tXQ0KU2VudDogV2VkbmVzZGF5LCBTZXB0ZW1i ZXIgMDMsIDIwMTQgMzoxMCBQTQ0KVG86IEFsYW5vbHkgQW5kcmV3czsgJ0Ny YWlnIEphbWVzJw0KQ2M6IHBnc3FsLWFkbWluQHBvc3RncmVzcWwub3JnOyBw Z3NxbC1nZW5lcmFsQHBvc3RncmVzcWwub3JnDQpTdWJqZWN0OiBSZTogW0dF TkVSQUxdIFJlOiBbQURNSU5dIENhbm5vdCByZXRyaWV2ZSBpbWFnZXMgaW5z ZXJ0ZWQgdGhyb3VnaCBWQiBhbmQgb2RiYywgYWZ0ZXIgYSB0YWJsZSByZW9y Z2FuaXphdGlvbi4NCg0KT24gMDkvMDMvMjAxNCAwOToyNiBBTSwgQWxhbm9s eSBBbmRyZXdzIHdyb3RlOg0KPiAqSGkgQ3JhaWcsKg0KPg0KPiAqKg0KPg0K PiAqSeKAmW0gcmVsb2FkaW5nIGludG8gdGhlIHZlcnkgc2FtZSBkYXRhYmFz ZS4gKg0KPg0KPiAqSWYgSSBpbnNlcnQgYSBuZXcgcm93IGludG8gdGhlIHRh YmxlICh0aHJvdWdoIFZCL09EQkMpLCBJ4oCZbSBhYmxlIHRvDQo+IHJldHJp ZXZlIGl0IChhZ2FpbiBmcm9tIFZCKS4gQnV0IGlmIGFmdGVyIGluc2VydGlu ZyB0aGUgbmV3IHJvdywgSSBkbw0KPiBhIHJlb3JnIG9mIHRoZSB0YWJsZSAo ZWcuIHdpdGggYSDigJxjbHVzdGVyIHRhYmxl4oCdKSwgSeKAmW0gbm8gbG9u Z2VyIGFibGUNCj4gdG8gcmV0cmlldmUgdGhhdCBzYW1lIHJvdy4gSW4gc2hv cnQsIGFzIGxvbmcgYXMgdGhlIG5ld2x5IGluc2VydGVkDQo+IHJvd3MgYXJl IG5vdCDigJxyZS13cml0dGVu4oCdIGluIHNvbWUgd2F5LCB0aGV5IGNhbiBi ZSByZXRyaWV2ZWQgdGhyb3VnaA0KPiBWQi9PREJDLiAqDQoNClRvIGZvbGxv dyB1cCBvbiBteSBwcmV2aW91cyBwb3N0IHdpdGggcmVnYXJkcyB0byBPSURz LiBUaGF0IG1heSBoYXZlIGJlZW4gYSB3cm9uZyBmb3JrLiBBIGxpdHRsZSB0 ZXN0aW5nOg0KDQp0ZXN0PSMgQ1JFQVRFIFRBQkxFIGltYWdlICgNCiAgICAg bmFtZSAgICAgICAgICAgIHRleHQsDQogICAgIHJhc3RlciAgICAgICAgICBv aWQNCik7DQoNCnRlc3Q9IyBjcmVhdGUgaW5kZXggaW1nX2lkeCBvbiBpbWFn ZSAocmFzdGVyKTsNCg0KdGVzdD0jIElOU0VSVCBJTlRPIGltYWdlIChuYW1l LCByYXN0ZXIpDQogICAgIFZBTFVFUyAoJ2Fub3RoZXIgYmVhdXRpZnVsIGlt YWdlJywgbG9faW1wb3J0KCcvaG9tZS9ha2xhdmVyL1BpY3R1cmVzL0lNR18w MzU5SlBHJykpOw0KDQp0ZXN0PSMgSU5TRVJUIElOVE8gaW1hZ2UgKG5hbWUs IHJhc3RlcikNCiAgICAgVkFMVUVTICgnYW5vdGhlciBiZWF1dGlmdWwgaW1h Z2UnLCBsb19pbXBvcnQoJy9ob21lL2FrbGF2ZXIvUGljdHVyZXMvSU1HXzAz NjAuSlBHJykpOw0KDQp0ZXN0PSMgSU5TRVJUIElOVE8gaW1hZ2UgKG5hbWUs IHJhc3RlcikNCiAgICAgVkFMVUVTICgnYW5vdGhlciBiZWF1dGlmdWwgaW1h Z2UnLCBsb19pbXBvcnQoJy9ob21lL2FrbGF2ZXIvUGljdHVyZXMvSU1HXzAz NjEuSlBHJykpOw0KDQp0ZXN0PSMgc2VsZWN0IG9pZCwgcmVsZmlsZW5vZGUg ZnJvbSBwZ19jbGFzcyB3aGVyZSByZWxuYW1lID0naW1hZ2UnOw0KICAgb2lk ICAgfCByZWxmaWxlbm9kZQ0KLS0tLS0tLS0rLS0tLS0tLS0tLS0tLQ0KICA1 MzIxNDQgfCAgICAgIDUzMjE3NQ0KDQp0ZXN0PSMgY2x1c3RlciBpbWFnZSB1 c2luZyBpbWdfaWR4Ow0KQ0xVU1RFUg0KdGVzdD0jIHNlbGVjdCBvaWQsIHJl bGZpbGVub2RlIGZyb20gcGdfY2xhc3Mgd2hlcmUgcmVsbmFtZSA9J2ltYWdl JzsNCiAgIG9pZCAgIHwgcmVsZmlsZW5vZGUNCi0tLS0tLS0tKy0tLS0tLS0t LS0tLS0NCiAgNTMyMTQ0IHwgICAgICA1MzIxODINCg0KTm90ZSB0aGUgT0lE IGZvciB0aGUgdGFibGUgc3RheXMgdGhlIHNhbWUgYnV0IHRoZSByZWxmaWxl bm9kZSBjaGFuZ2VzLg0KVGhpcyBhbHNvIGhhcHBlbnMgd2l0aCB0aGUgb3Ro ZXIgc2l0dWF0aW9ucyB5b3UgZGVzY3JpYmUodW5sZXNzIHlvdSB1c2UgLS1v aWRzIHdpdGggcGdfZHVtcCkuDQoNClNvIHRvIHJldmlzZSBteSBwcmV2aW91 cyBzdGF0ZW1lbnQsIG15IGd1ZXNzIGlzIHlvdXIgVkIvT0RCQyBjb2RlIGlz IHVzaW5nIHRoZSByZWxmaWxlbm9kZSB2YWx1ZSB0byByZWZlciB0byB0aGUg dGFibGUgYW5kIHdoZW4gdGhhdCBjaGFuZ2VzIGl0IGNhbm5vdCBmaW5kIGl0 IGFueSBtb3JlLg0KDQo+DQo+ICoqDQo+DQo+ICpBbGFub2x5LioNCj4NCg0K DQoNCi0tDQpBZHJpYW4gS2xhdmVyDQphZHJpYW4ua2xhdmVyQGFrbGF2ZXIu Y29tDQoNCl9fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fDQoNCklm IHlvdSBubyBsb25nZXIgd2lzaCB0byByZWNlaXZlIGFueSBvZiBvdXIgZW1h aWxzLCBjbGljayBvbiBVTlNVQlNDUklCRS48bWFpbHRvOnVuc3Vic2NyaWJl QGludmVyYS5jb20/c3ViamVjdD0qKipVbnN1YnNjcmliZSoqKj4gVGhpcyBl LW1haWwgbWF5IGJlIHByaXZpbGVnZWQgYW5kL29yIGNvbmZpZGVudGlhbCwg YW5kIHRoZSBzZW5kZXIgZG9lcyBub3Qgd2FpdmUgYW55IHJlbGF0ZWQgcmln aHRzIGFuZCBvYmxpZ2F0aW9ucy4gQW55IGRpc3RyaWJ1dGlvbiwgdXNlIG9y IGNvcHlpbmcgb2YgdGhpcyBlLW1haWwgb3IgdGhlIGluZm9ybWF0aW9uIGl0 IGNvbnRhaW5zIGJ5IG90aGVyIHRoYW4gYW4gaW50ZW5kZWQgcmVjaXBpZW50 IGlzIHVuYXV0aG9yaXplZC4gSWYgeW91IHJlY2VpdmVkIHRoaXMgZS1tYWls IGluIGVycm9yLCBwbGVhc2UgYWR2aXNlIG1lIChieSByZXR1cm4gZS1tYWls IG9yIG90aGVyd2lzZSkgaW1tZWRpYXRlbHkuDQoNClNpIHZvdXMgbmUgZMOp c2lyZXogcGx1cyByZWNldm9pciBkZSBub3MgY291cnJpZWxzLCB2ZXVpbGxl eiBhcHB1eWVyIHN1ciBEw4lTQUJPTk5FTUVOVC48bWFpbHRvOnVuc3Vic2Ny aWJlQGludmVyYS5jb20/c3ViamVjdD0qKipVbnN1YnNjcmliZSoqKj4gQ2Ug Y291cnJpZWwgZXN0IGNvbmZpZGVudGllbCBldCBwcm90w6lnw6kuIEwnZXhw w6lkaXRldXIgbmUgcmVub25jZSBwYXMgYXV4IGRyb2l0cyBldCBvYmxpZ2F0 aW9ucyBxdWkgcyd5IHJhcHBvcnRlbnQuIFRvdXRlIGRpZmZ1c2lvbiwgdXRp bGlzYXRpb24gb3UgY29waWUgZGUgY2UgbWVzc2FnZSBvdSBkZXMgcmVuc2Vp Z25lbWVudHMgcXUnaWwgY29udGllbnQgcGFyIHVuZSBwZXJzb25uZSBhdXRy ZSBxdWUgbGUgKGxlcykgZGVzdGluYXRhaXJlKHMpIGTDqXNpZ27DqShzKSBl c3QgaW50ZXJkaXRlLiBTaSB2b3VzIHJlY2V2ZXogY2UgY291cnJpZWwgcGFy IGVycmV1ciwgdmV1aWxsZXogbSdlbiBhdmlzZXIgaW1tw6lkaWF0ZW1lbnQs IHBhciByZXRvdXIgZGUgY291cnJpZWwgb3UgcGFyIHVuIGF1dHJlIG1veWVu Lg0KCi0tIApTZW50IHZpYSBwZ3NxbC1hZG1pbiBtYWlsaW5nIGxpc3QgKHBn c3FsLWFkbWluQHBvc3RncmVzcWwub3JnKQpUbyBtYWtlIGNoYW5nZXMgdG8g eW91ciBzdWJzY3JpcHRpb246Cmh0dHA6Ly93d3cucG9zdGdyZXNxbC5vcmcv bWFpbHByZWYvcGdzcWwtYWRtaW4K