From: | Unprivileged user <nobody> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | General Bug Report: create table with long tablename with unique index having long fieldname fails |
Date: | 1999-02-10 23:22:12 |
Message-ID: | 199902102322.SAA08850@hub.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
============================================================================
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:
---------
--------------------------------------------------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | Roberto Joao Lopes Garcia | 1999-02-11 14:28:02 | date_part() BUG? |
Previous Message | bugsbuny | 1999-02-09 20:12:43 | Re: info |