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

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

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 (view raw or flat)
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:
---------


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


pgsql-bugs by date

Next:From: Roberto Joao Lopes GarciaDate: 1999-02-11 14:28:02
Subject: date_part() BUG?
Previous:From: bugsbunyDate: 1999-02-09 20:12:43
Subject: Re: info

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