Обсуждение: length(columnname)<=31 ?

Поиск
Список
Период
Сортировка

length(columnname)<=31 ?

От
Andreas Fitzner
Дата:
Hi,

I tried to install OpenInteract (www.openinteract.org), but failed
because obviously postgresql seems to truncate the columnames to 31
character. Is there a way to have longer columnnames under postgresql?


opensci=# create table ThisIsAReallyReallyReallyReallyReallyReallyReallyReallyReallyReallyReallyReallyLongTableName
(testint); 
NOTICE:  identifier "thisisareallyreallyreallyreallyreallyreallyreallyreallyreallyreallyreallyreallylongtablename" will
betruncated to "thisisareallyreallyreallyreally" 
CREATE
opensci=#


grateful for any hints,
 regards Andreas