I'm not sure if there was a particular reason for this choice, but you could rebuild from source and change them in the archiva-model/src/main/mdo/archiva-base.xml file.
However, is there a configuration option for psql that might allow this? Or is using another tool like squirrel sql an option? Cheers, Brett On 11/04/2008, Julian Dunn <[EMAIL PROTECTED]> wrote: > Hi again all, > > I'm using PostgreSQL, rather than Derby, as the data store for Archiva. > However, all the table names were created upper case for some reason: > > > archivadata=# \dt > List of relations > Schema | Name | Type | Owner > --------+------------------------------+-------+--------- > public | ARCHIVA_ARTIFACT | table | archiva > public | ARCHIVA_ARTIFACT_REFERENCE | table | archiva > > (etc.) > > Is there any reason for this? It means that "psql" cannot run SQL > queries against these tables: > > archivadata=# select * from SEQUENCE_TABLE; > ERROR: relation "sequence_table" does not exist > > > > - Julian > -- Brett Porter Blog: http://blogs.exist.com/bporter/
