| Lists: | pgsql-bugs |
|---|
| 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: | 20041228124926.GD11145@divine.migv.mot.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-bugs |
Configurations:
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
names.
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?
Thanks,
Sankar
Keywords: PostgreSQL, table, name, length, 32, 31, truncate, limit
Keywords: 8.0.0, 7.2.2
| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Sankaranarayanan K V <sankar(at)motorola(dot)com> |
| Cc: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: Table name length: differences b/w 7.2.2 and 8.0.0-RC2 ? |
| Date: | 2004-12-28 15:08:29 |
| Message-ID: | 29963.1104246509@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-bugs |
Sankaranarayanan K V <sankar(at)motorola(dot)com> writes:
> Is there any way by which I can impose the 32 char limit
> on the 8.0 database?
Rebuild with a different NAMEDATALEN.
> In which PGSQL release did the table name length limitation change?
RTF release notes.
regards, tom lane