Create Index?

Started by John Cusickover 27 years ago3 messagesgeneral

jcusick@exotrope.net

over 27 years ago

I've recently upgraded to version 6.4 which was compiled on RedHat Linux
ver 5.1
with no apparent problems.

and with a test table;

create table partref
(partnum varchar(15) not null, desc varchar(15), vnum varchar(60));

then;

create index indpart on partref (partnum);

returns;

ERROR: partind: cannot extend

This worked fine w/version6.3 on the same system.

I looked around in the changes and re-checked the man page.
Am I missing something way to obvious??

John Cusick
jcusick@exotrope.net

bruce@momjian.us

over 27 years ago

In reply to: John Cusick (#1)

Re: [SQL] Create Index?

create index indpart on partref (partnum);

returns;

ERROR: partind: cannot extend

This worked fine w/version6.3 on the same system.

I looked around in the changes and re-checked the man page.
Am I missing something way to obvious??

You have run out of disk space.

-- 
  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

Kaare Rasmussen

kar@webline.dk

over 27 years ago

In reply to: Bruce Momjian (#2)

Typed fields

I can INHERIT a table, but there's no way to TYPE a field? E.g. I want
to use the same type for all amounts field, so I want to make a TYPE
amount DECIMAL(9,2) and then use that for all amount fields in the
database?