Re: Truncation of object names - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Truncation of object names
Date
Msg-id 8350.987198352@sss.pgh.pa.us
Whole thread Raw
In response to Re: Truncation of object names  (ncm@zembu.com (Nathan Myers))
Responses RE: Truncation of object names  ("Christopher Kings-Lynne" <chriskl@familyhealth.com.au>)
List pgsql-hackers
ncm@zembu.com (Nathan Myers) writes:
> On Fri, Apr 13, 2001 at 04:27:15PM -0400, Tom Lane wrote:
>> Have you thought about simply increasing NAMEDATALEN in your
>> installation?  If you really are generating names that aren't unique
>> in 31 characters, that seems like the way to go ...

> We discussed that, and will probably do it (too).

> One problem is that, having translated "foo.bar.baz" to "foo_bar_baz", 
> you have a problem when you encounter "foo.bar_baz" in subsequent code.

So it's not really so much that NAMEDATALEN is too short for your
individual names, it's that you are concatenating names as a workaround
for the lack of schema support.

FWIW, I believe schemas are very high on the priority list for 7.2 ...
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: pg_dump problem
Next
From: The Hermit Hacker
Date:
Subject: Tag'd, packaged and ready to go ...