The mailing list for listmasters using Sympa

[Edward Rynes <address@concealed>]

To complete the fix you also need to change the following:

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

new
    subscribed_admin        number        NULL    constraint  
cons_subscribed_admin CHECK (subscribed_admin in (0,1)),
    included_admin            number        NULL    constraint  
cons_included_admin  CHECK (included_admin in (0,1)),

You could leave off the constraints but it is probably safer to keep  
them.


On Jun 9, 2005, at 11:16 AM, Ivan Vecchia wrote:

> 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!