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 OAA24859 for postgres-dist; Thu, 18 Nov 1993 14:29:00 -0800 Resent-From: POSTGRES mailing list Resent-Message-Id: <199311182229.OAA24859@nobozo.CS.Berkeley.EDU> X-Authentication-Warning: nobozo.CS.Berkeley.EDU: Host localhost didn't use HELO protocol Sender: owner-postman@postgres.Berkeley.EDU X-Return-Path: owner-postman Received: from cs.uml.edu (cs.uml.edu [129.63.1.11]) by nobozo.CS.Berkeley.EDU (8.6.4/8.6.3) with SMTP id OAA24850 for ; Thu, 18 Nov 1993 14:28:59 -0800 Received: by cs.uml.edu id AA03879 (5.67a+/IDA-1.5 for postgres@nobozo.CS.Berkeley.EDU); Thu, 18 Nov 1993 17:28:57 -0500 From: John Peter Lee Message-Id: <199311182228.AA03879@cs.uml.edu> Subject: now, a question on field lengths To: postgres@postgres.Berkeley.EDU Date: Thu, 18 Nov 1993 17:28:54 -0500 (EST) X-Mailer: ELM [version 2.4 PL22] Content-Type: text Content-Length: 1041 Resent-To: postgres-dist@postgres.Berkeley.EDU Resent-Date: Thu, 18 Nov 93 14:29:00 -0800 Resent-XMts: smtp Hi: I know that Postgres has a limit of 16 characters for relations. We have made relations with 16-character names in the past. What is the limit for field names within a relation ??? 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 error received was: artiste> !mon mon Finance Welcome to the C POSTGRES terminal monitor Go * retrieve (comp_real_data.all)\g Error: Unexpected identfier in dump_data: p We made the 16-char string a 15-char string at relation create, and did not get the error upon a retrieve. Can you please clarify this ? thanks, jp ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ JP Lee Institute for Visualization and Perception Research jlee@cs.uml.edu University of Massachusetts at Lowell (508) 934-3384 1 University Ave. Lowell, MA 01854 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~