X-Original-To: pgsql-interfaces-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 03964D1B52D for ; Thu, 30 Oct 2003 14:45:03 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 61170-08 for ; Thu, 30 Oct 2003 10:44:34 -0400 (AST) Received: from mail.netbcg.com (ip-216-46-80-134.dsl.ewr.megapath.net [216.46.80.134]) by svr1.postgresql.org (Postfix) with SMTP id B20D8D1B561 for ; Thu, 30 Oct 2003 10:44:24 -0400 (AST) Received: (qmail 4815 invoked from network); 30 Oct 2003 14:44:11 -0000 Received: from ip-216-46-80-134.dsl.ewr.megapath.net (HELO genesis) (216.46.80.134) by 0 with SMTP; 30 Oct 2003 14:44:11 -0000 From: "creid" To: Subject: PGEASY Date: Thu, 30 Oct 2003 09:44:31 -0500 Message-ID: MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="----=_NextPart_000_0000_01C39ECA.6B71AC20" X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0) X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 Importance: Normal X-MS-TNEF-Correlator: X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200310/57 X-Sequence-Number: 4546 This is a multi-part message in MIME format. ------=_NextPart_000_0000_01C39ECA.6B71AC20 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit I am experimenting with LIBPGEASY Problem: When I access a "varchar(30)" column using "DECLARE.....FOR SELECT column from schema.table WHERE pkey='KEY'" When I fetch to a declared variable to return to a calling procedure, my program does a (segmentation error) unless I declare the char variable to some much higher value than it is seemingly necessary. Moreover, the problem does not occur when I manipulate the result in the called procedure. In fact, in my experimentation, I have noticed that I can declare a char variable array less than what the result is and it still works. The crash only occurs in the calling procedure. What might I be doing wrong? Thanks Cliff ------=_NextPart_000_0000_01C39ECA.6B71AC20 Content-Type: application/ms-tnef; name="winmail.dat" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="winmail.dat" eJ8+Ih8OAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcA GAAAAElQTS5NaWNyb3NvZnQgTWFpbC5Ob3RlADEIAQ2ABAACAAAAAgACAAEG gAMADgAAANMHCgAeAAkALAAAAAQAOwEBA5AGANgGAAAlAAAACwACAAEAAAAL ACMAAAAAAAMAJgAAAAAACwApAAAAAAADADYAAAAAAB4AcAABAAAABwAAAFBH RUFTWQAAAgFxAAEAAAAWAAAAAcOe9FPfu6VrDIs1RPqoh4o3U1HS8QAAAgEd DAEAAAAWAAAAU01UUDpDUkVJREBORVRCQ0cuQ09NAAAACwABDgAAAABAAAYO AHg5QfSewwECAQoOAQAAABgAAAAAAAAAbZUzlWoEi0Ka9YaFW00/VcKAAAAL AB8OAQAAAAIBCRABAAAAeAIAAHQCAABaAwAATFpGdSZaZ6wDAAoAcmNwZzEy NRYyAPgLYG4OEDAzM08B9wKkA+MCAGNoCsBzsGV0MCAHEwKAfQqBknYIkHdr C4BkNAxgDmMAUAsDC7UgSSBh4G0gZXhwBnEHgAIwCQuAZyAD8HRoIEwASUJQ R0VBU1k3CqIKhAqAUANgAmBlbTA6IFdoCfATwmNjwweQBCBhICJ2CsAQ4kAo MzApIiAI4XUabQOgdQCQFNEiREVAQ0xBUkUuGmJGpE9SBgBFTBoAVBkG3QNS IATwF0AAwC4BkRbgCRcgSEUaQCBwa2UAeT0nS0VZJyIbFeoXNWYRMBDgIHRv 7xgBBYELYAlxIBhBBzAcsrsfkQlwdAhwA6Afk2MHQFpsFMJwA2AXwGQIcGVw LCBteSJiCcAT8WRWbweRGBAoESBnFIJhlxSwAiAUEHIDYHIpGXD+bhbgBBET 0B/lH4AXQBkA2xDxIGtzA3Ac0G0SwBUw+GhpZxdAJxIKQSaRA5G/FRApoAQg ESAW8BTBbCMwjm4FkBfRCsB5LiAF0PEFsGVvdgSQIwAmoiJxsxbSI8RubwVA IpBjCHCvFPAXRAOBBSB1C2B0JoT9CXBzLoApwSGBJrIiASBB2yJ3K0FJG7EA 0HQjAC+R/yMhFCgkwyMAE9AQ8CvALRL/DeAgQSlhBUAT0CHwA6AmJv8h0Sb7 CsAjkCMwJbMpYy3A3zRBLuoX8RKAKaJzFLAiENMU8AWwa3MrQVQmsiOQ/nMV MAIgKoEtYwQgL5kiO74uHgw0QSpAKLA0UmIc0O8j0BTDA2APID8V6jnQAHD7 OYAV5EMiIAEgFeorUBXkBRHhAEKQCwABgAggBgAAAAAAwAAAAAAAAEYAAAAA A4UAAAAAAAADAAOACCAGAAAAAADAAAAAAAAARgAAAAAQhQAAAAAAAAMAB4AI IAYAAAAAAMAAAAAAAABGAAAAAFKFAAAnagEAHgAJgAggBgAAAAAAwAAAAAAA AEYAAAAAVIUAAAEAAAAEAAAAOS4wAB4ACoAIIAYAAAAAAMAAAAAAAABGAAAA ADaFAAABAAAAAQAAAAAAAAAeAAuACCAGAAAAAADAAAAAAAAARgAAAAA3hQAA AQAAAAEAAAAAAAAAHgAMgAggBgAAAAAAwAAAAAAAAEYAAAAAOIUAAAEAAAAB AAAAAAAAAAsADYAIIAYAAAAAAMAAAAAAAABGAAAAAIKFAAABAAAACwA6gAgg BgAAAAAAwAAAAAAAAEYAAAAADoUAAAAAAAADADyACCAGAAAAAADAAAAAAAAA RgAAAAARhQAAAAAAAAMAPYAIIAYAAAAAAMAAAAAAAABGAAAAABiFAAAAAAAA CwBbgAggBgAAAAAAwAAAAAAAAEYAAAAABoUAAAAAAAADAFyACCAGAAAAAADA AAAAAAAARgAAAAABhQAAAAAAAAIB+A8BAAAAEAAAAG2VM5VqBItCmvWGhVtN P1UCAfoPAQAAABAAAABtlTOVagSLQpr1hoVbTT9VAgH7DwEAAACnAAAAAAAA ADihuxAF5RAaobsIACsqVsIAAFBTVFBSWC5ETEwAAAAAAAAAAE5JVEH5v7gB AKoAN9luAAAAQzpcRG9jdW1lbnRzIGFuZCBTZXR0aW5nc1xBZG1pbmlzdHJh dG9yLkdFTkVTSVNcTG9jYWwgU2V0dGluZ3NcQXBwbGljYXRpb24gRGF0YVxN aWNyb3NvZnRcT3V0bG9va1xvdXRsb29rLnBzdAAAAwD+DwUAAAADAA00/TcA AAIBfwABAAAAMAAAADxJTEVDSktQRk9MQkFHSU5JRkZGQktFREdDQUFBLmNy ZWlkQG5ldGJjZy5jb20+AAMABhBCdkXXAwAHECUCAAADABAQAAAAAAMAERAA AAAAHgAIEAEAAABlAAAASUFNRVhQRVJJTUVOVElOR1dJVEhMSUJQR0VBU1lQ Uk9CTEVNOldIRU5JQUNDRVNTQSJWQVJDSEFSKDMwKSJDT0xVTU5VU0lORyJE RUNMQVJFRk9SU0VMRUNUQ09MVU1ORlJPTQAAAACnhg== ------=_NextPart_000_0000_01C39ECA.6B71AC20--