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


Your name : Tim Webster
Your email address : tim@thecolorworks.com

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

Summary: can't create clusters for some tables

System Configuration
--------------------
Operating System : LinuxPPC, Release 4

PostgreSQL version : 6.4

Compiler used : gcc

Hardware:
---------
PPC, 64M RAM

Versions of other tools:
------------------------


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

Problem Description:
--------------------
Somewhere, somehow, the last characters of some (but not all) tables' names are dropped, causing the cluster command to fail, i.e.:

switchboard=> create index jobscoresidx on jobscores(jobnum);
CREATE
switchboard=> cluster jobscoresidx on jobscores;
ERROR: Relation jobscore Does Not Exist!


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

Test Case:
----------


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

Solution:
---------


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

Search Discussions

  • Bruce Momjian at Jun 10, 1999 at 11:31 pm
    Can't reproduce. Works here.

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


    Your name : Tim Webster
    Your email address : tim@thecolorworks.com

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

    Summary: can't create clusters for some tables

    System Configuration
    --------------------
    Operating System : LinuxPPC, Release 4

    PostgreSQL version : 6.4

    Compiler used : gcc

    Hardware:
    ---------
    PPC, 64M RAM

    Versions of other tools:
    ------------------------


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

    Problem Description:
    --------------------
    Somewhere, somehow, the last characters of some (but not all) tables' names are dropped, causing the cluster command to fail, i.e.:

    switchboard=> create index jobscoresidx on jobscores(jobnum);
    CREATE
    switchboard=> cluster jobscoresidx on jobscores;
    ERROR: Relation jobscore Does Not Exist!


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

    Test Case:
    ----------


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

    Solution:
    ---------


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


    --
    Bruce Momjian | http://www.op.net/~candle
    maillist@candle.pha.pa.us | (610) 853-3000
    + If your life is a hard drive, | 830 Blythe Avenue
    + Christ can be your backup. | Drexel Hill, Pennsylvania 19026

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouppgsql-ports @
categoriespostgresql
postedJun 10, '99 at 5:17p
activeJun 10, '99 at 11:31p
posts2
users2
websitepostgresql.org
irc#postgresql

2 users in discussion

Tim Webster: 1 post Bruce Momjian: 1 post

People

Translate

site design / logo © 2022 Grokbase