Return-Path: owner-postman Received: from localhost (localhost [127.0.0.1]) by nobozo.CS.Berkeley.EDU (8.6.4/8.6.3) with SMTP id PAA25279 for postgres-dist; Thu, 18 Nov 1993 15:13:05 -0800 Resent-From: POSTGRES mailing list Resent-Message-Id: <199311182313.PAA25279@nobozo.CS.Berkeley.EDU> Sender: owner-postman@postgres.Berkeley.EDU X-Return-Path: owner-postman Received: from faerie.CS.Berkeley.EDU (faerie.CS.Berkeley.EDU [128.32.149.14]) by nobozo.CS.Berkeley.EDU (8.6.4/8.6.3) with ESMTP id PAA25270 for ; Thu, 18 Nov 1993 15:13:04 -0800 Received: from localhost (localhost [127.0.0.1]) by faerie.CS.Berkeley.EDU (8.6.4/8.1B) with SMTP id PAA22742; Thu, 18 Nov 1993 15:12:59 -0800 Message-Id: <199311182312.PAA22742@faerie.CS.Berkeley.EDU> X-Authentication-Warning: faerie.CS.Berkeley.EDU: Host localhost didn't use HELO protocol From: aoki@postgres.Berkeley.EDU (Paul M. Aoki) To: John Peter Lee Cc: postgres@postgres.Berkeley.EDU Subject: Re: now, a question on field lengths In-reply-to: Your message of Thu, 18 Nov 1993 17:28:54 -0500 (EST) <199311182228.AA03879@cs.uml.edu> Date: Thu, 18 Nov 93 15:12:59 -0800 X-Sender: aoki@postgres.Berkeley.EDU Resent-To: postgres-dist@postgres.Berkeley.EDU X-Mts: smtp Resent-Date: Thu, 18 Nov 93 15:13:05 -0800 Resent-XMts: smtp John Peter Lee writes: > We think it is 15, not 16, as we had some problems retrieving > from a DB with a field name that was 16 characters long. the length of all identifiers is 16. the data structure that stores names is NOT null-terminated. there are several hunks of code written by people who did not understand this last (rather important) point. i personally don't use any identifier longer than 15 characters; this is a really embarrassing problem that is one of my pet peeves and one of our ongoing cleanup projects. -- Paul M. Aoki | CS Div., Dept. of EECS, UCB | aoki@postgres.Berkeley.EDU | Berkeley, CA 94720 | ...!uunet!ucbvax!aoki