On 10 Apr 2008, Julian Dunn wrote: > 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
PostgreSQL supports uppercase, but you have to quote the table names. See 4.21 at Postgres' FAQ: http://www.postgresql.org/docs/faqs.FAQ.html#item4.21 hth, - martin
signature.asc
Description: PGP signature