|
1 | | -From ChrUllrich@gmx.de Fri Jun 18 15:01:15 1999 |
2 | | -Received: from mail2.gmx.net (qmailr@mail2.gmx.net [194.221.183.62]) |
3 | | -by candle.pha.pa.us (8.9.0/8.9.0) with SMTP id PAA02123 |
4 | | -for <maillist@candle.pha.pa.us>; Fri, 18 Jun 1999 15:01:13 -0400 (EDT) |
5 | | -Received: (qmail 1465 invoked by uid 0); 18 Jun 1999 18:40:59 -0000 |
6 | | -Received: from pc19f7c08.dip.t-online.de (HELO christian.ullrich.net) (193.159.124.8) |
7 | | - by mail2.gmx.net with SMTP; 18 Jun 1999 18:40:59 -0000 |
8 | | -Received: (from chris@localhost) |
9 | | -by christian.ullrich.net (8.9.3/8.9.3) id UAA02806 |
10 | | -for maillist@candle.pha.pa.us; Fri, 18 Jun 1999 20:33:54 +0200 |
11 | | -Date: Fri, 18 Jun 1999 20:33:54 +0200 |
12 | | -From: Christian Ullrich <ChrUllrich@gmx.de> |
13 | | -To: Bruce Momjian <maillist@candle.pha.pa.us> |
14 | | -Subject: Re: [GENERAL] Two questions about 6.5 |
15 | | -Message-ID: <19990618203354.A2716@christian.ullrich.net> |
16 | | -References: <19990617204118.B8536@christian.ullrich.net> <199906181631.MAA29003@candle.pha.pa.us> |
17 | | -Mime-Version: 1.0 |
18 | | -Content-Type: text/plain; charset=iso-8859-1 |
19 | | -Content-Transfer-Encoding: 8bit |
20 | | -X-Mailer: Mutt 0.95.6i |
21 | | -In-Reply-To: <199906181631.MAA29003@candle.pha.pa.us>; from Bruce Momjian on Fri, Jun 18, 1999 at 12:31:17PM -0400 |
22 | | -Status: RO |
23 | | - |
24 | | -On Fri, Jun 18, 1999 at 12:31:17PM -0400, Bruce Momjian wrote: |
25 | | - |
26 | | -> Does this work for you? It works here: |
27 | | -> |
28 | | -> test=> create table te(x int, y int); |
29 | | -> CREATE |
30 | | -> test=> create unique index i_te on te(x,y); |
31 | | -> CREATE |
32 | | -> test=> cluster i_te on te; |
33 | | -> CLUSTER |
34 | | - |
35 | | -It works. But why doesn't it work on my tables: |
36 | | - |
37 | | -create table prautor( |
38 | | -nr int4, |
39 | | -pi int4, |
40 | | -primary key(nr,pi)); |
41 | | - |
42 | | -create table prauflage( |
43 | | -nr int4, |
44 | | -au int4, |
45 | | -pl text, |
46 | | -be text, |
47 | | -st int4, |
48 | | -vh bool, |
49 | | -ex int4, |
50 | | -primary key(nr,au)); |
51 | | - |
52 | | -prd=> create unique index i_te on prauflage(nr,au); |
53 | | -CREATE |
54 | | -prd=> cluster i_te on prauflage; |
55 | | -ERROR: Cannot create unique index. Table contains non-unique values |
56 | | - |
57 | | --- |
58 | | -Christian Ullrich |
59 | | -Registrierter Linux-User #125183 |
60 | | - |
61 | | -"Sie k�nnen nach R'ed'mond fliegen -- aber Sie werden sterben" |
62 | | - |
63 | 1 | From owner-pgsql-hackers@hub.org Thu Apr 16 15:00:41 1998 |
64 | 2 | Received: from hub.org (hub.org [209.47.148.200]) |
65 | 3 | by candle.pha.pa.us (8.8.5/8.8.5) with ESMTP id PAA25361 |
|