Skip site navigation (1) Skip section navigation (2)

Table name length: differences b/w 7.2.2 and 8.0.0-RC2 ?

From: Sankaranarayanan K V <sankar(at)motorola(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Table name length: differences b/w 7.2.2 and 8.0.0-RC2 ?
Date: 2004-12-28 12:49:26
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs

A: PostgreSQL 7.2.2 on a RedHat Linux 6.2
B: Windows PostgreSQL 8.0.0 RC2

(A) truncates table names with length >32 characters 
to 32 characters.

I have some legacy application which relies on this fact.
This code uses 32+ chars for creating the schema but
uses 32- chars for querying. This works fine with 7.2.2.

However, it doesn't work with (B) which expects complete

My application needs to work with both the databases.

Is there any way by which I can impose the 32 char limit
on the 8.0 database?

In which PGSQL release did the table name length limitation change? 


Keywords: PostgreSQL, table, name, length, 32, 31, truncate, limit
Keywords: 8.0.0, 7.2.2 


pgsql-bugs by date

Next:From: longDate: 2004-12-28 15:05:10
Subject: BUG #1361: errors in install
Previous:From: PEDRO LOPEZDate: 2004-12-28 06:21:56
Subject: function return type for triggers in postgresql 8.0 rc2

Privacy Policy | About PostgreSQL
Copyright © 1996-2018 The PostgreSQL Global Development Group