[Openinteract-help] columnnames truncated, Basic problems installing OpenInteractiv with postgres

[Andreas F. <fi...@in...>]

Hi,

I tried to install OpenInteract with Postgres instead of MySQL as the
backend RDBMS.  everything went fine. I followed the steps in INSTALL.website.
	oi_manage test_db 
	    returns ok.
	oi_manage --driver=SPOPS::DBI::Pg change_spops_driver
	    also ok.
now, running 
	oi_manage --package=INITIAL install_sql 
gives me headaches. it seams postgres truncates the columnnames
to 31 characters.
I get
     Error: DBD::Pg::st execute failed: ERROR:  ExecAppend:
      Fail to add null value in not null attribute content_type_id at /usr/local/libdata
      /perl5/site_perl/SPOPS/SQLInterface.pm line 309.


                  List of relations
              Name               |   Type   | Owner
---------------------------------+----------+--------
 content_type                    | table    | oiuser
 
 content_type_content_type_i_seq | sequence | oiuser
                           ^<- HERE
 object_keys                     | table    | oiuser
 object_track                    | table    | oiuser
 object_track_objtrack_id_seq    | sequence | oiuser
 page                            | table    | oiuser
 page_content                    | table    | oiuser
 sessions                        | table    | oiuser
 sys_error                       | table    | oiuser
 sys_group                       | table    | oiuser
 sys_group_group_id_seq          | sequence | oiuser
 sys_group_user                  | table    | oiuser
 sys_security                    | table    | oiuser
 sys_security_sid_seq            | sequence | oiuser
 sys_user                        | table    | oiuser
 sys_user_user_id_seq            | sequence | oiuser
 template                        | table    | oiuser
 template_template_id_seq        | sequence | oiuser
 theme                           | table    | oiuser
 theme_prop                      | table    | oiuser
 theme_prop_themeprop_id_seq     | sequence | oiuser
 theme_theme_id_seq              | sequence | oiuser
(22 rows)

because there is no sequence content_type_content_type_id_seq (=32 character).

when i do 

opensci=# create table content_type_content_type_id_seq (test int); 
NOTICE:  identifier "content_type_content_type_id_seq" will be truncated to "content_type_content_type_id_se"
CREATE
opensci=# 

it will be truncated.


anyone who knows how to fix this? 
is there a tweak to let postgres accept longer columnnames?

OpenInteract ist not running without it.


grateful for any hints,
 sincerly Andreas