General Bug Report: create table with long tablename with unique index having long fieldname fails

============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================

Your name : Al Dev
Your email address : alavoor(at)yahoo(dot)com

Category : runtime: back-end: SQL
Severity : critical

Summary: create table with long tablename with unique index having long fieldname fails

System Configuration
--------------------
Operating System : Redhat5.2 Linux 2.0.36

PostgreSQL version : 6.4.2

Compiler used : gcc 2.7

Hardware:
---------

Versions of other tools:
------------------------
gmake, flex

--------------------------------------------------------------------------

Problem Description:
--------------------
I am creating a table having name more than 30 chars
and a unique index on a field whose name is also more than
30 chars. The create table statement fails and gives error -

hos=> create table longtablename (DATE_TIME_STAMP datetime not null,
hos-> UNIQUE (DATE_TIME_STAMP));
ERROR: parser: unable to construct implicit index for table longtablename; name too long
hos=> \q

--------------------------------------------------------------------------

Test Case:
----------
$ psql mydatabase
hos=> create table longtablename (DATE_TIME_STAMP datetime not null,
hos-> UNIQUE (DATE_TIME_STAMP));
ERROR: parser: unable to construct implicit index for table longtablename; name too long
hos=> \q

--------------------------------------------------------------------------

Solution:
---------

--------------------------------------------------------------------------