Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1XPvVt-0007ar-4D for pgsql-admin@arkaria.postgresql.org; Fri, 05 Sep 2014 15:33:25 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1XPvVs-0001Bf-6U for pgsql-admin@arkaria.postgresql.org; Fri, 05 Sep 2014 15:33:24 +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 1XPvVp-0001BS-Sl; Fri, 05 Sep 2014 15:33:22 +0000 Received: from mailfilter.invera.com ([198.168.207.50]) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1XPvVl-0007O9-HK; Fri, 05 Sep 2014 15:33:19 +0000 Received: from epgate.invera.com (localhost.localdomain [127.0.0.1]) by epgate.invera.com (Postfix-out) with ESMTP id 1798D3C595A; Fri, 5 Sep 2014 11:33:18 -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 rfTOre95fxi0; Fri, 05 Sep 2014 11:33:18 -0400 Received: from Exch2.invera.com (exch2.invera.com [172.20.35.3]) by epgate.invera.com (Postfix-out) with ESMTP id E75493C51D7; Fri, 5 Sep 2014 11:33:17 -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; Fri, 5 Sep 2014 11:33:15 -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; Fri, 5 Sep 2014 11:33:15 -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: AQHPyEWn651jeMw1wkiR38sR358T2ZvxEOxwgACjNQCAAPcr8A== Date: Fri, 5 Sep 2014 15:33:14 +0000 Message-ID: <8dd4e9c35f6441b6b9d20b1eb659688e@Exch2.invera.com> References: <6909b219ecae4d41b431efdaf6c953a3@Exch2.invera.com> <5407679B.2030906@aklaver.com> <54086B77.9090102@aklaver.com> <5408CED2.10302@aklaver.com> In-Reply-To: <5408CED2.10302@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.35.89] Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 MIME-Version: 1.0 X-Propel-ID: rfTOre95fxi0 X-Pg-Spam-Score: -3.6 (---) 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 SGkgQWRyaWFuLA0KDQoxLiBXZSBhcmUgc3RvcmluZyBvdXIgbGFyZ2Ugb2Jq ZWN0cyBpbiBhIHRhYmxlIGNvbHVtbiB3aG9zZSBkYXRhdHlwZSBpcyAibG8i ICh3aGljaCwgSSB1bmRlcnN0YW5kLCB1bHRpbWF0ZWx5IGlzIGluIGZhY3Qg ImJ5dGVhIikuDQoyLiBUaGUgZXJyb3IgbWVzc2dlIHJldHVybmVkIHRvIHRo ZSBWQiBpcywgeWVzLCB2ZXJ5IGdlbmVyaWMuIEFuZCB0aGUgYmFja2VuZCBw b3N0Z3JlcyBzZXJ2ZXIgZG9lcyBub3QgaGF2ZSBhbnkgbWVzc2FnZXMgcmVs ZXZhbnQgdG8gdGhpcyBpc3N1ZS4NCjMuIFdlIHNldCB0aGUgdHJhY2Ugb24g aW4gdGhlIG9kYmMgZHJpdmVyIGFuZCBnb3QgYSBsYXJnZSBsb2cgZmlsZSwg ZnJvbSB3aGljaCBJIGdpdmUgYmVsb3cgdGhlIHBhcnQgdGhhdCBJIHRoaW5r IGlzIHNpZ25pZmljYW50LiBJdCByZWZlcnMgdG8gdGhlICJidWZmZXIgc2l6 ZSBiZWluZyB0b28gc21hbGwiLiBXaGVyZSwgaW4gdGhlIG9kYyBzZXR0aW5n cywgZG8gd2Ugc2V0IHRoZSBidWZmZXIgc2l6ZT8NCg0KDQpTVEVMaW1hZ2VW aWV3T24gODM0LWZlYyAgICAgICAgICBFWElUICBTUUxHZXREYXRhICB3aXRo IHJldHVybiBjb2RlIDEgKFNRTF9TVUNDRVNTX1dJVEhfSU5GTykNCiAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgSFNUTVQgICAgICAgICAgICAg ICAweDAwMkJGQzcwDQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg IFVXT1JEICAgICAgICAgICAgICAgICAgICAgICAgMg0KICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICBTV09SRCAgICAgICAgICAgICAgICAgICAg ICAgIDEgPFNRTF9DX0NIQVI+DQogICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgIFBUUiAgICAgICAgICAgICAgICAgMHgwMDE4RUVDRiBbICAgICAg IDBdICIiDQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIFNRTExF TiAgICAgICAgICAgICAgICAgICAgIDANCiAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgU1FMTEVOICogICAgICAgICAgICAweDAwMThFRUE0ICg2 KQ0KDQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIERJQUcgWzAx MDA0XSBUaGUgYnVmZmVyIHdhcyB0b28gc21hbGwgZm9yIHRoZSBHZXREYXRh LiAoLTIpDQoNClNURUxpbWFnZVZpZXdPbiA4MzQtZmVjICAgICAgICAgIEVO VEVSIFNRTEdldERhdGENCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgSFNUTVQgICAgICAgICAgICAgICAweDAwMkJGQzcwDQogICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgIFVXT1JEICAgICAgICAgICAgICAgICAg ICAgICAgMg0KICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBTV09S RCAgICAgICAgICAgICAgICAgICAgICAgLTIgPFNRTF9DX0JJTkFSWT4NCiAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgUFRSICAgICAgICAgICAg ICAgICA8dW5rbm93biB0eXBlPg0KICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICBTUUxMRU4gICAgICAgICAgICAgICAgICAgICAwDQogICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgIFNRTExFTiAqICAgICAgICAgICAg MHgwMDE4RUU1NA0KDQpTVEVMaW1hZ2VWaWV3T24gODM0LWZlYyAgICAgICAg ICBFWElUICBTUUxHZXREYXRhICB3aXRoIHJldHVybiBjb2RlIDEgKFNRTF9T VUNDRVNTX1dJVEhfSU5GTykNCiAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgSFNUTVQgICAgICAgICAgICAgICAweDAwMkJGQzcwDQogICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgIFVXT1JEICAgICAgICAgICAgICAg ICAgICAgICAgMg0KICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBT V09SRCAgICAgICAgICAgICAgICAgICAgICAgLTIgPFNRTF9DX0JJTkFSWT4N CiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgUFRSICAgICAgICAg ICAgICAgICA8dW5rbm93biB0eXBlPg0KICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICBTUUxMRU4gICAgICAgICAgICAgICAgICAgICAwDQogICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgIFNRTExFTiAqICAgICAgICAg ICAgMHgwMDE4RUU1NCAoNDYxNjUpDQoNCiAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgRElBRyBbMDEwMDRdIFRoZSBidWZmZXIgd2FzIHRvbyBz bWFsbCBmb3IgdGhlIEdldERhdGEuICgtMikNCg0KU1RFTGltYWdlVmlld09u IDgzNC1mZWMgICAgICAgICAgRU5URVIgU1FMR2V0RGF0YQ0KICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICBIU1RNVCAgICAgICAgICAgICAgIDB4 MDAyQkZDNzANCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgVVdP UkQgICAgICAgICAgICAgICAgICAgICAgICAyDQogICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgIFNXT1JEICAgICAgICAgICAgICAgICAgICAgICAt MiA8U1FMX0NfQklOQVJZPg0KICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICBQVFIgICAgICAgICAgICAgICAgIDx1bmtub3duIHR5cGU+DQogICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgIFNRTExFTiAgICAgICAgICAg ICAgICAgMzI3NjgNCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg U1FMTEVOICogICAgICAgICAgICAweDAwM0NFMjg0DQoNClNURUxpbWFnZVZp ZXdPbiA4MzQtZmVjICAgICAgICAgIEVYSVQgIFNRTEdldERhdGEgIHdpdGgg cmV0dXJuIGNvZGUgLTEgKFNRTF9FUlJPUikNCiAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgSFNUTVQgICAgICAgICAgICAgICAweDAwMkJGQzcw DQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIFVXT1JEICAgICAg ICAgICAgICAgICAgICAgICAgMg0KICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICBTV09SRCAgICAgICAgICAgICAgICAgICAgICAgLTIgPFNRTF9D X0JJTkFSWT4NCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgUFRS ICAgICAgICAgICAgICAgICA8dW5rbm93biB0eXBlPg0KICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICBTUUxMRU4gICAgICAgICAgICAgICAgIDMy NzY4DQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIFNRTExFTiAq ICAgICAgICAgICAgMHgwMDNDRTI4NA0KDQogICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgIERJQUcgW1MxMDAwXSBFcnJvciByZWFkaW5nIGZyb20g bGFyZ2Ugb2JqZWN0LiAoMSkNCg0KLS0tLS1PcmlnaW5hbCBNZXNzYWdlLS0t LS0NCkZyb206IEFkcmlhbiBLbGF2ZXIgW21haWx0bzphZHJpYW4ua2xhdmVy QGFrbGF2ZXIuY29tXQ0KU2VudDogVGh1cnNkYXksIFNlcHRlbWJlciAwNCwg MjAxNCA0OjQzIFBNDQpUbzogQWxhbm9seSBBbmRyZXdzOyAnQ3JhaWcgSmFt ZXMnDQpDYzogcGdzcWwtYWRtaW5AcG9zdGdyZXNxbC5vcmc7IHBnc3FsLWdl bmVyYWxAcG9zdGdyZXNxbC5vcmcNClN1YmplY3Q6IFJlOiBbR0VORVJBTF0g UmU6IFtBRE1JTl0gQ2Fubm90IHJldHJpZXZlIGltYWdlcyBpbnNlcnRlZCB0 aHJvdWdoIFZCIGFuZCBvZGJjLCBhZnRlciBhIHRhYmxlIHJlb3JnYW5pemF0 aW9uLg0KDQpPbiAwOS8wNC8yMDE0IDA4OjAzIEFNLCBBbGFub2x5IEFuZHJl d3Mgd3JvdGU6DQo+IFRoYW5rcywgQWRyaWFuIGZvciB0aGUgcmVzcG9uc2Uu DQo+DQo+IFllcywgd2UgYXJlIHVzaW5nIHRoZSAibGFyZ2Ugb2JqZWN0IiBh cyBwZXIgdGhlIHNwZWNpZmljYXRpb25zIGluIHRoZQ0KPiBzcGVjaWFsICJs byIgbW9kdWxlIHRoYXQgd2UgaW5zdGFsbGVkIG9uIHRoZSBiYWNrZW5kIHNl cnZlci4gVGhlIHRhYmxlDQo+IGlzIGNyZWF0ZWQgdXNpbmcgdGhlICJsbyIg ZGF0YXR5cGUgZm9yIHRoZSBpbWFnZSBmaWVsZCBhbmQgdGhlIHRhYmxlDQo+ IGlzIGJlaW5nIHJlZ3VsYXJseSB1c2VkIGZvciBpbnNlcnRpb25zIGFuZCBy ZXRyaWV2YWxzIHVzaW5nIHV0aWxpdGllcw0KPiBvdGhlciB0aGFuIG9uZXMg dXNpbmcgb2RiYy4gVGhlIG9kYmMgY29ubmVjdGlvbiwgdG9vLCB3b3JrcyB3 ZWxsIG9uDQo+IHRoZSB0YWJsZSwgYXMgbG9uZyBhcyB0aGUgdGFibGUgZGF0 YSBpcyBub3QgcmVvcmdhbml6ZWQgYWZ0ZXIgaW5zZXJ0aW9uKHMpLg0KPg0K PiBIZXJlIGFyZSB0aHJlZSBwYWdlcyBvZiBvdXIgcG9zdGdyZXMgb2RiYyBk cml2ZXIgc2V0dGluZ3MuIFNvcnJ5LCB0aGV5DQo+IGFyZSBzY3JlZW4gY2Fw dHVyZXMsICBub3QgcGxhaW4gdGV4dCENCg0KSG1tLCB0byBtZSBhdCBsZWFz dCBub3RoaW5nIHNlZW1zIG91dCBvZiBwbGFjZS4gVGhvdWdoIHRvIGJlIGhv bmVzdCBJIGFtIG5vdCBzdXJlIHdoYXQgJ0J5dGVhIGFzIExPJyBkb2VzIGlu IHRoaXMgc2l0dWF0aW9uLg0KDQpBcmUgeW91IGFjdHVhbGx5IHRyeWluZyB0 byBzdG9yZSBhbnkgbGFyZ2Ugb2JqZWN0cyBpbiBieXRlYSBjb2x1bW5zPw0K DQpJIHNlYXJjaGVkIG9uIHRoZSBlcnJvciBtZXNzYWdlIHlvdSBvcmlnaW5h bGx5IHBvc3RlZCwgYnV0IGlzIGZhaXJseSBnZW5lcmljIGFuZCBjb3ZlcnMg YSBsb3Qgb2YgZGlmZmVyZW50IGVycm9yIHNvdXJjZXMuDQoNClNvLCBpcyB0 aGVyZSBhbnkgbW9yZSBzcGVjaWZpYyBlcnJvciBpbmZvcm1hdGlvbiBpbiBl aXRoZXIgdGhlIFBvc3RncmVzIG9yIE9EQkMgbG9ncz8NCg0KPg0KPiBBbGFu b2x5Lg0KDQoNCi0tDQpBZHJpYW4gS2xhdmVyDQphZHJpYW4ua2xhdmVyQGFr bGF2ZXIuY29tDQoNCl9fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19f DQoNCklmIHlvdSBubyBsb25nZXIgd2lzaCB0byByZWNlaXZlIGFueSBvZiBv dXIgZW1haWxzLCBjbGljayBvbiBVTlNVQlNDUklCRS48bWFpbHRvOnVuc3Vi c2NyaWJlQGludmVyYS5jb20/c3ViamVjdD0qKipVbnN1YnNjcmliZSoqKj4g VGhpcyBlLW1haWwgbWF5IGJlIHByaXZpbGVnZWQgYW5kL29yIGNvbmZpZGVu dGlhbCwgYW5kIHRoZSBzZW5kZXIgZG9lcyBub3Qgd2FpdmUgYW55IHJlbGF0 ZWQgcmlnaHRzIGFuZCBvYmxpZ2F0aW9ucy4gQW55IGRpc3RyaWJ1dGlvbiwg dXNlIG9yIGNvcHlpbmcgb2YgdGhpcyBlLW1haWwgb3IgdGhlIGluZm9ybWF0 aW9uIGl0IGNvbnRhaW5zIGJ5IG90aGVyIHRoYW4gYW4gaW50ZW5kZWQgcmVj aXBpZW50IGlzIHVuYXV0aG9yaXplZC4gSWYgeW91IHJlY2VpdmVkIHRoaXMg ZS1tYWlsIGluIGVycm9yLCBwbGVhc2UgYWR2aXNlIG1lIChieSByZXR1cm4g ZS1tYWlsIG9yIG90aGVyd2lzZSkgaW1tZWRpYXRlbHkuDQoNClNpIHZvdXMg bmUgZMOpc2lyZXogcGx1cyByZWNldm9pciBkZSBub3MgY291cnJpZWxzLCB2 ZXVpbGxleiBhcHB1eWVyIHN1ciBEw4lTQUJPTk5FTUVOVC48bWFpbHRvOnVu c3Vic2NyaWJlQGludmVyYS5jb20/c3ViamVjdD0qKipVbnN1YnNjcmliZSoq Kj4gQ2UgY291cnJpZWwgZXN0IGNvbmZpZGVudGllbCBldCBwcm90w6lnw6ku IEwnZXhww6lkaXRldXIgbmUgcmVub25jZSBwYXMgYXV4IGRyb2l0cyBldCBv YmxpZ2F0aW9ucyBxdWkgcyd5IHJhcHBvcnRlbnQuIFRvdXRlIGRpZmZ1c2lv biwgdXRpbGlzYXRpb24gb3UgY29waWUgZGUgY2UgbWVzc2FnZSBvdSBkZXMg cmVuc2VpZ25lbWVudHMgcXUnaWwgY29udGllbnQgcGFyIHVuZSBwZXJzb25u ZSBhdXRyZSBxdWUgbGUgKGxlcykgZGVzdGluYXRhaXJlKHMpIGTDqXNpZ27D qShzKSBlc3QgaW50ZXJkaXRlLiBTaSB2b3VzIHJlY2V2ZXogY2UgY291cnJp ZWwgcGFyIGVycmV1ciwgdmV1aWxsZXogbSdlbiBhdmlzZXIgaW1tw6lkaWF0 ZW1lbnQsIHBhciByZXRvdXIgZGUgY291cnJpZWwgb3UgcGFyIHVuIGF1dHJl IG1veWVuLg0KCi0tIApTZW50IHZpYSBwZ3NxbC1hZG1pbiBtYWlsaW5nIGxp c3QgKHBnc3FsLWFkbWluQHBvc3RncmVzcWwub3JnKQpUbyBtYWtlIGNoYW5n ZXMgdG8geW91ciBzdWJzY3JpcHRpb246Cmh0dHA6Ly93d3cucG9zdGdyZXNx bC5vcmcvbWFpbHByZWYvcGdzcWwtYWRtaW4K