X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id D14A553403 for ; Tue, 29 Mar 2005 12:50:06 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 13253-06 for ; Tue, 29 Mar 2005 11:50:01 +0000 (GMT) Received: from metasoftworks.com (unknown [61.107.33.24]) by svr1.postgresql.org (Postfix) with ESMTP id 10511533A9 for ; Tue, 29 Mar 2005 12:50:00 +0100 (BST) Received: from Spooler by metasoftworks.com (Mercury/32 v3.21c) ID MO00198B; 29 Mar 05 20:54:23 +0900 Received: from spooler by metasoftworks.com (Mercury/32 v3.21c); 29 Mar 05 20:54:08 +0900 Received: from notebook04 (61.107.33.45) by metasoftworks.com (Mercury/32 v3.21c) ID MG00198A; 29 Mar 05 20:54:07 +0900 Message-ID: <008b01c53455$6992a590$2d216b3d@notebook04> From: =?ks_c_5601-1987?B?wLG1v7z2?= To: Subject: when using a bound cursor, error found... Date: Tue, 29 Mar 2005 20:49:49 +0900 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0088_01C534A0.D961E390" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.2527 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2527 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=2.075 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, HTML_MESSAGE, MIME_BASE64_TEXT, UPPERCASE_25_50 X-Spam-Level: ** X-Archive-Number: 200503/374 X-Sequence-Number: 20853 This is a multi-part message in MIME format. ------=_NextPart_000_0088_01C534A0.D961E390 Content-Type: text/plain; charset="ks_c_5601-1987" Content-Transfer-Encoding: base64 SSAnbGwgdXNlIGEgYm91bmQgY3Vyc29yIHdpdGggcGFyYW1ldGVycy4NCkJ1dCB3aGVuIEkgdXNl IHN1Y2ggYSBjdXJzb3IsIEkgZm91bmQgYSBlcnJvci4NCkkgZG9uJ3Qga25vdyBlcnJvciBtZXNz YWdlLg0KSG93IGNhbiBJIHVzZSBhIGJvdW5kIGN1cnNvci4NCmluIGZvbGxvd2luZyBzYW1wbGUs ICBuZWFyIGEgJ2ZvciBsb29wJyAsIGVycm9yIGZvdW5kLg0KLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t DQpDUkVBVEUgT1IgUkVQTEFDRSBGVU5DVElPTiBjdXJzb3JfdGVzdCgNCg0KICAgICAgICAgIHZw X3BhcmFtMSAgICAgICAgICAgICAgIFZBUkNIQVINCiAgICAgICAgICx2cF9wYXJhbTIgICAgICAg ICAgICAgICBWQVJDSEFSDQoNCikNCg0KUkVUVVJOUyBWQVJDSEFSIEFTICRCT0RZJA0KDQpERUNM QVJFDQoNCiAgcF9wYXJhbTEgICAgICAgICAgICAgICAgICAgICAgICBWQVJDSEFSOw0KICBwX3Bh cmFtMSAgICAgICAgICAgICAgICAgICAgICAgIFZBUkNIQVI7DQoNCiAgY3VyX3Rlc3QgQ1VSU09S IChjX3BhcmFtIFZBUkNIQVIpIElTIA0KICAgIFNFTEVDVCBjb2xfMSwgY29sXzIsIGNvbF8zIEZS T00gdGFiXzEgV0hFUkUgY29sXzEgPSBjX3BhcmFtOw0KDQogIHJlY190ZXN0IFJFQ09SRDsNCg0K ICB2X2NvdW50ICAgICAgICAgICAgICAgICAgICAgICAgICAgIE5VTUVSSUM7DQoNCg0KQkVHSU4N Cg0KICAgIHBfcGFyYW0xICAgICAgICA6PSBudWxsaWYodnBfcGFyYW0xICwgJycpOw0KICAgIHBf cGFyYW0yICAgICAgICA6PSBudWxsaWYodnBfcGFyYW0yICwgJycpOw0KDQogICAgSUYgcF9wYXJh bTEgPSAndHhuJyBUSEVODQoNCiAgICAgICAtLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tDQogICAgICAgLS0gY3Vyc29yDQogICAgICAgLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQ0KICAgICAgIE9QRU4gY3VyX3Rl c3QocF9wYXJhbTIpOw0KDQogICAgICAgZm9yIHJlY190ZXN0IGluIGN1cl90ZXN0IGxvb3ANCg0K ICAgICAgICAgLS1GRVRDSCBjdXJfdGVzdCBJTlRPIHJlY190ZXN0Ow0KICAgICAgICAgDQogICAg ICAgICBTRUxFQ1QgY291bnQoKikgSU5UTyB2X2NvdW50IEZST00gdGFiXzIgV0hFUkUgY29sXzEg PSByZWNfdGVzdC5jb2xfMSBhbmQgY29sXzIgPSByZWNfdGVzdC5jb2xfMiA7DQogICAgICAgICAN CiAgICAgICAgIElGICB2X2NvdW50ID4wICBUSEVODQogICAgICAgICANCiAgICAgICAgICAgaW5z ZXJ0IGludG8gdGFiXzINCiAgICAgICAgICAgKCAgDQogICAgICAgICAgICAgY29sXzENCiAgICAg ICAgICAgLCBjb2xfMg0KICAgICAgICAgICAsIGNvbF8zDQogICAgICAgICAgICkNCiAgICAgICAg ICAgdmFsdWVzDQogICAgICAgICAgICgNCiAgICAgICAgICAgICByZWNfdGVzdC5jb2xfMQ0KICAg ICAgICAgICAsIHJlY190ZXN0LmNvbF8yDQogICAgICAgICAgICwgcmVjX3Rlc3QuY29sXzMNCiAg ICAgICAgICAgKTsNCiAgICAgICAgIA0KICAgICAgICAgRU5EIElGOyAgICAgICAgIA0KICAgICAg ICAgDQogICAgICAgZW5kIGxvb3A7IC0tIGN1cl90ZXN0ICANCg0KICAgICAgIENMT1NFIGN1cl90 ZXN0OyANCg0KICAgIEVORCBJRjsNCiAgICANCiAgICBSRVRVUk4gJ3R4biBPSyc7DQoNCkVORDsN CiRCT0RZJCBMQU5HVUFHRSBwbHBnc3FsOyAgICA= ------=_NextPart_000_0088_01C534A0.D961E390 Content-Type: text/html; charset="ks_c_5601-1987" Content-Transfer-Encoding: base64 PCFET0NUWVBFIEhUTUwgUFVCTElDICItLy9XM0MvL0RURCBIVE1MIDQuMCBUcmFuc2l0aW9uYWwv L0VOIj4NCjxIVE1MPjxIRUFEPg0KPE1FVEEgaHR0cC1lcXVpdj1Db250ZW50LVR5cGUgY29udGVu dD0idGV4dC9odG1sOyBjaGFyc2V0PWtzX2NfNTYwMS0xOTg3Ij4NCjxNRVRBIGNvbnRlbnQ9Ik1T SFRNTCA2LjAwLjI5MDAuMjYwNCIgbmFtZT1HRU5FUkFUT1I+DQo8U1RZTEU+PC9TVFlMRT4NCjwv SEVBRD4NCjxCT0RZIGJnQ29sb3I9I2ZmZmZmZj4NCjxESVY+PEZPTlQgc2l6ZT0yPg0KPERJVj48 Rk9OVCBzaXplPTI+SSAnbGwgdXNlIGEgYm91bmQgY3Vyc29yIHdpdGggcGFyYW1ldGVycy48L0ZP TlQ+PC9ESVY+DQo8RElWPjxGT05UIHNpemU9Mj5CdXQgd2hlbiBJIHVzZSBzdWNoIGEgY3Vyc29y LCBJIGZvdW5kIGEgZXJyb3IuPC9GT05UPjwvRElWPg0KPERJVj48Rk9OVCBzaXplPTI+SSBkb24n dCBrbm93IGVycm9yIG1lc3NhZ2UuPC9GT05UPjwvRElWPg0KPERJVj48Rk9OVCBzaXplPTI+SG93 IGNhbiBJIHVzZSBhIGJvdW5kIGN1cnNvci48L0ZPTlQ+PC9ESVY+DQo8RElWPjxGT05UIHNpemU9 Mj5pbiBmb2xsb3dpbmcgc2FtcGxlLCZuYnNwOyBuZWFyIGEgJ2ZvciBsb29wJyAsIGVycm9yIA0K Zm91bmQuPC9GT05UPjwvRElWPg0KPERJVj48Rk9OVCANCnNpemU9Mj4tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS08L0ZPTlQ+PC9ESVY+DQo8RElWPjxGT05UIHNpemU9Mj5DUkVBVEUgT1IgUkVQTEFDRSBG VU5DVElPTiBjdXJzb3JfdGVzdCg8L0ZPTlQ+PC9ESVY+DQo8RElWPiZuYnNwOzwvRElWPg0KPERJ Vj48Rk9OVCBzaXplPTI+Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7 Jm5ic3A7Jm5ic3A7IA0KdnBfcGFyYW0xJm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5i c3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7IA0KVkFS Q0hBUjxCUj4mbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsg DQosdnBfcGFyYW0yJm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5i c3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7IA0KVkFSQ0hBUjwvRk9OVD48 L0RJVj4NCjxESVY+Jm5ic3A7PC9ESVY+DQo8RElWPjxGT05UIHNpemU9Mj4pPC9GT05UPjwvRElW Pg0KPERJVj4mbmJzcDs8L0RJVj4NCjxESVY+PEZPTlQgc2l6ZT0yPlJFVFVSTlMgVkFSQ0hBUiBB UyAkQk9EWSQ8L0ZPTlQ+PC9ESVY+DQo8RElWPiZuYnNwOzwvRElWPg0KPERJVj48Rk9OVCBzaXpl PTI+REVDTEFSRTwvRk9OVD48L0RJVj4NCjxESVY+Jm5ic3A7PC9ESVY+DQo8RElWPjxGT05UIHNp emU9Mj4mbmJzcDsgDQpwX3BhcmFtMSZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNw OyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZu YnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyANClZBUkNIQVI7 PEJSPiZuYnNwOyANCnBfcGFyYW0xJm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7 Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5i c3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7IA0KVkFSQ0hBUjs8 L0ZPTlQ+PC9ESVY+DQo8RElWPiZuYnNwOzwvRElWPg0KPERJVj48Rk9OVCBzaXplPTI+Jm5ic3A7 IGN1cl90ZXN0IENVUlNPUiAoY19wYXJhbSBWQVJDSEFSKSBJUyANCjxCUj4mbmJzcDsmbmJzcDsm bmJzcDsgU0VMRUNUIGNvbF8xLCBjb2xfMiwgY29sXzMgRlJPTSB0YWJfMSBXSEVSRSBjb2xfMSA9 IA0KY19wYXJhbTs8L0ZPTlQ+PC9ESVY+DQo8RElWPiZuYnNwOzwvRElWPg0KPERJVj48Rk9OVCBz aXplPTI+Jm5ic3A7IHJlY190ZXN0IFJFQ09SRDs8L0ZPTlQ+PC9ESVY+DQo8RElWPiZuYnNwOzwv RElWPg0KPERJVj48Rk9OVCBzaXplPTI+Jm5ic3A7IA0Kdl9jb3VudCZuYnNwOyZuYnNwOyZuYnNw OyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZu YnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNw OyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyANCk5VTUVSSUM7PC9GT05UPjwvRElWPg0K PERJVj4mbmJzcDs8L0RJVj48Rk9OVCBzaXplPTI+DQo8RElWPjxCUj5CRUdJTjwvRElWPg0KPERJ Vj4mbmJzcDs8L0RJVj4NCjxESVY+Jm5ic3A7Jm5ic3A7Jm5ic3A7IHBfcGFyYW0xJm5ic3A7Jm5i c3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7IDo9IA0KbnVsbGlmKHZwX3BhcmFtMSAs ICcnKTs8QlI+Jm5ic3A7Jm5ic3A7Jm5ic3A7IA0KcF9wYXJhbTImbmJzcDsmbmJzcDsmbmJzcDsm bmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsgOj0gbnVsbGlmKHZwX3BhcmFtMiAsIA0KJycpOzwvRElW Pg0KPERJVj4mbmJzcDs8L0RJVj4NCjxESVY+Jm5ic3A7Jm5ic3A7Jm5ic3A7IElGIHBfcGFyYW0x ID0gJ3R4bicgVEhFTjwvRElWPg0KPERJVj4mbmJzcDs8L0RJVj4NCjxESVY+Jm5ic3A7Jm5ic3A7 Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7IA0KLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLTxCUj4mbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJz cDsgDQotLSBjdXJzb3I8QlI+Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7IA0K LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLTxCUj4mbmJz cDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsgDQpPUEVOIGN1cl90ZXN0KHBfcGFyYW0y KTs8L0RJVj4NCjxESVY+Jm5ic3A7PC9ESVY+DQo8RElWPiZuYnNwOyZuYnNwOyZuYnNwOyZuYnNw OyZuYnNwOyZuYnNwOyBmb3IgcmVjX3Rlc3QgaW4gY3VyX3Rlc3QgbG9vcDwvRElWPg0KPERJVj4m bmJzcDs8L0RJVj4NCjxESVY+Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5i c3A7Jm5ic3A7IC0tRkVUQ0ggY3VyX3Rlc3QgSU5UTyANCnJlY190ZXN0OzxCUj4mbmJzcDsmbmJz cDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsgDQo8QlI+Jm5ic3A7Jm5ic3A7 Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7IFNFTEVDVCBjb3VudCgqKSBJTlRP IA0Kdl9jb3VudCBGUk9NIHRhYl8yIFdIRVJFIGNvbF8xID0gcmVjX3Rlc3QuY29sXzEgYW5kIGNv bF8yID0gcmVjX3Rlc3QuY29sXzIgDQo7PEJSPiZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNw OyZuYnNwOyZuYnNwOyZuYnNwOyANCjxCUj4mbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsm bmJzcDsmbmJzcDsmbmJzcDsgSUYmbmJzcDsgdl9jb3VudCANCiZndDswJm5ic3A7IFRIRU48QlI+ Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7IA0KPEJSPiZu YnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNw OyBpbnNlcnQgaW50byANCnRhYl8yPEJSPiZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZu YnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyAoJm5ic3A7IA0KPEJSPiZuYnNwOyZuYnNwOyZu YnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNw OyANCmNvbF8xPEJSPiZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZu YnNwOyZuYnNwOyZuYnNwOyAsIA0KY29sXzI8QlI+Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5i c3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7ICwgDQpjb2xfMzxCUj4mbmJzcDsmbmJz cDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsgDQopPEJS PiZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZu YnNwOyANCnZhbHVlczxCUj4mbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJz cDsmbmJzcDsmbmJzcDsmbmJzcDsgDQooPEJSPiZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNw OyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyANCnJlY190ZXN0LmNv bF8xPEJSPiZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZu YnNwOyZuYnNwOyAsIA0KcmVjX3Rlc3QuY29sXzI8QlI+Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7 Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7ICwgDQpyZWNfdGVzdC5jb2xfMzxC Uj4mbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsm bmJzcDsgDQopOzxCUj4mbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsm bmJzcDsgDQo8QlI+Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5i c3A7IEVORCANCklGOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZu YnNwOyANCjxCUj4mbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJz cDsgDQo8QlI+Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7IGVuZCBsb29wOyAt LSBjdXJfdGVzdCZuYnNwOyA8L0RJVj4NCjxESVY+Jm5ic3A7PC9ESVY+DQo8RElWPiZuYnNwOyZu YnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyBDTE9TRSBjdXJfdGVzdDsgPC9ESVY+DQo8RElW PiZuYnNwOzwvRElWPg0KPERJVj4mbmJzcDsmbmJzcDsmbmJzcDsgRU5EIElGOzxCUj4mbmJzcDsm bmJzcDsmbmJzcDsgPEJSPiZuYnNwOyZuYnNwOyZuYnNwOyANClJFVFVSTiAndHhuIE9LJzs8L0RJ Vj4NCjxESVY+Jm5ic3A7PC9ESVY+DQo8RElWPkVORDs8QlI+JEJPRFkkIExBTkdVQUdFIHBscGdz cWw7Jm5ic3A7Jm5ic3A7Jm5ic3A7IA0KPC9GT05UPjwvRElWPjwvRk9OVD48L0RJVj48L0JPRFk+ PC9IVE1MPg0K ------=_NextPart_000_0088_01C534A0.D961E390--