RE: [QUESTIONS] Re: [HACKERS] Bug or Short between my brain and t he keyboard?

Started by Jackson, DeJuanover 27 years ago1 messages

djackson@cpsgroup.com

over 27 years ago

Yep, its a bug. Not sure about the cause, but will look into it in
the
next few weeks.

Thanks Bruce, I was beginning to feel as neglected as a cross-eyed
foster child who had contracted leprosy. But I realized you guys were
busy with the 3.6.2 release/freeze. I wish I could help with the
development.

-DEJ

Show quoted text

Just thought I'd try the cluster command. What am I doing wrong.
ReadHat 5.0
6.3.1 rpm's

[djackson@www]$ psql template1
Welcome to the POSTGRESQL interactive sql monitor:
Please read the file COPYRIGHT for copyright terms of POSTGRESQL

type \? for help on slash commands
type \q to quit
type \g or terminate with semicolon to execute query
You are currently connected to the database: template1

template1=> \d
Couldn't find any tables, sequences or indices!
template1=> \l
datname |datdba|datpath
---------+------+---------
template1| 100|template1
postgres | 100|postgres
(2 rows)

template1=> create database test;
CREATEDB
template1=> \connect test
connecting to new database: test
test=> create table list (k int2);
CREATE
test=> insert into list values (1);
INSERT 33769 1
test=> insert into list select max(k)+1;
.
.
.
test=> select * from list;
k
-
1
2
3
4
5
6
(6 rows)

test=> create table list2 (k1 int2 NOT NULL, k2 int2 NOT NULL);
CREATE
test=> create UNIQUE INDEX l1 ON list2(k1, k2);
CREATE
test=> create UNIQUE INDEX l2 ON list2(k2, k1);
CREATE
test=> insert into list2 select l1.k, l2.k from list as l1, list as

l2;

INSERT 0 36
test=> select * from list2;
k1|k2
--+--
1| 1
2| 1
3| 1
.
.
.
4| 6
5| 6
6| 6
(36 rows)

test=> vacuum verbose analyze list2;
NOTICE: Rel list2: Pages 1: Changed 0, Reapped 0, Empty 0, New 0;

Tup

36: Vac 0, Crash 0, UnUsed 0, MinLen 44, MaxLen 44; Re-using:
Free/Avail. Space 0/0; EndEmpty/Avail. Pages 0/0. Elapsed 0/0 sec.
NOTICE: Ind l2: Pages 2; Tuples 36. Elapsed 0/0 sec.
NOTICE: Ind l1: Pages 2; Tuples 36. Elapsed 0/0 sec.
VACUUM
test=> cluster l1 on list2;
ERROR: Cannot create unique index. Table contains non-unique values
test=> cluster l2 on list2;
PQexec() -- Request was sent to backend, but backend closed the

channel

before responding.
This probably means the backend terminated abnormally before

or

while processing the request.
-- 
Bruce Momjian                          |  830 Blythe Avenue
maillist@candle.pha.pa.us              |  Drexel Hill, Pennsylvania
19026
+  If your life is a hard drive,     |  (610) 353-9879(w)
+  Christ can be your backup.        |  (610) 853-3000(h)
--
Official WWW Site: http://www.postgresql.org
Online Docs & FAQ: http://www.postgresql.org/docs
Searchable Lists: http://www.postgresql.org/mhonarc