The mailing list for listmasters using Sympa

[Ivan Vecchia <address@concealed>]

Oracle 9 does not like this:

         included_admin          number('0','1'),



Olivier Salaün - CRU wrote:

> You are right.
> We did a mistake in the create_db.Oracle and it looks like we don't have 
> that many users using Oracle...
>
> Here is a patch from the CVS stable branch :
> http://sourcesup.cru.fr/cgi/viewcvs.cgi/sympa/src/etc/script/create_db.Oracle.diff?r1=1.9&r2=1.9.8.1&cvsroot=sympa&only_with_tag=sympa-5_0-branch 
>
>
> Thanks for reporting this.
>
> address@concealed wrote:
>
> > Am I the only one having trouble creating the admin_table on an Oracle 
> > DB?
> >
> > Our Oracle DBA insists that there is no such thing as an enum in 
> > Oracle and that the provided table creation parameters are just plain 
> > wrong.  Since I can not create the table as suggested I assume he
> > is correct.
> >
> > In particular, the line:
> >
> >    role_admin              number('listmaster','owner','editor') NOT 
> > NULL,
> >
> > is not valid in an Oracle database.
> >
> > What am I missing here?  Has anyone managed to get Sympa running with 
> > an Oracle DB (with the enums needed in the admin_table)
> >
> > thanks!
> >