trouble with object names ...

Hi,

I always hated the fact that Oracle limits the object names to
31 characters. Why is pgsql doing the same? I thought the cool
thing about pgsql was that it made no difference how big a
string value is and varchar limits were more or less a backwards-
compatibility "feature". Why this constraint on names?

This is a real problem with the automatic name comer-upper for
things like constraingts. For instance:

CREATE TABLE Clinical_variable (
value_quantitative_low_bound char
CHECK (value_quantitative_low_bound IN ('[', '(');
value_quantitative_high_bound
CHECK (value_quantitative_high_bound IN (']', ')');
)

which leads to:

ERROR: Duplicate CHECK constraint name: 'clinical_variab_value_quantitat'

apparently it simply concatenates the table name and column
name then truncates to fit. That is never safe. I could fix
the name generator but I really would prefer no length
contraints instead. Is that a big deal?

regards
-Gunther

--
Gunther Schadow, M.D., Ph.D. gschadow(at)regenstrief(dot)org
Medical Information Scientist Regenstrief Institute for Health Care
Adjunct Assistant Professor Indiana University School of Medicine
tel:1(317)630-7960 http://aurora.regenstrief.org