FAQ
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

Search Discussions

Discussion Posts

Previous

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 2 of 2 | next ›
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