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
