Thread: General Bug Report: create table with long tablename with unique index having long fieldname fails
General Bug Report: create table with long tablename with unique index having long fieldname fails
From
Unprivileged user
Date:
============================================================================ POSTGRESQL BUG REPORT TEMPLATE ============================================================================ Your name : Al Dev Your email address : alavoor@yahoo.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: --------- --------------------------------------------------------------------------