Table

Started by Mihai Gheorghiualmost 26 years ago2 messagesgeneral
Jump to latest
#1Mihai Gheorghiu
tanhq@bigplanet.com

I created an index on a 12krows, 6.5M table, using pgAccess. When I wanted
to cluster it, I got an error mesage (fatal error) and the next time I
opened the database, the table is no longer shown. The table is in the
directory, all right. What could be the cause and how can I avoid this in
the future?

Thanks,

Mihai

#2Bruce Momjian
bruce@momjian.us
In reply to: Mihai Gheorghiu (#1)
Re: Table

Upgrade to 7.0.1 or later. We fixed a major CLUSTER bug in that release.

[ Charset ISO-8859-1 unsupported, converting... ]

I created an index on a 12krows, 6.5M table, using pgAccess. When I wanted
to cluster it, I got an error mesage (fatal error) and the next time I
opened the database, the table is no longer shown. The table is in the
directory, all right. What could be the cause and how can I avoid this in
the future?

Thanks,

Mihai

-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  pgman@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