| From: | Andreas Fitzner <fitzner(at)informatik(dot)hu-berlin(dot)de> |
|---|---|
| To: | pgsql-novice(at)postgresql(dot)org |
| Subject: | length(columnname)<=31 ? |
| Date: | 2002-01-13 20:27:01 |
| Message-ID: | 20020113212701.A25110@jazz.informatik.hu-berlin.de |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
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 (test int);
NOTICE: identifier "thisisareallyreallyreallyreallyreallyreallyreallyreallyreallyreallyreallyreallylongtablename" will be truncated to "thisisareallyreallyreallyreally"
CREATE
opensci=#
grateful for any hints,
regards Andreas
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andreas Fitzner | 2002-01-14 11:38:36 | length(columnname), solved |
| Previous Message | Al Dev | 2002-01-13 18:08:57 | Commercial: New Book!! PostgreSQL book is released into the market |