Column name truncation

From: Frank Voellmann <fvoellma(at)cisco(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Column name truncation
Date: 2004-08-04 19:30:43
Message-ID: 4.3.2.7.2.20040804151932.02805330@funnel.cisco.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

I've upgraded postgresl from 7.1 to 7.3 and am having an issue with the
following:

7.1 would truncate column names greater than 31 characters to 31.

7.3 does not do this, so that backups previously done via pg_dump in 7.1
don't play nicely with my code accessing 7.3

Is there a way to force 7.3 to truncate at 31 characters too?
Or,
Is there a way to test whether a (truncated) column name is in a table? and
if true, rename the column name to it's full (pre-truncated) name?

Thanks

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message David Norris 2004-08-04 22:10:01 UNICODE and regex character classes
Previous Message Skeets 2004-08-04 19:11:14 Newbie Instal Problem