We do have an issue in JIRA:
http://objectstyle.org/jira/secure/ViewIssue.jspa?key=CAY-289
I guess table and column name translations should indeed be delegated to
DbAdapter. I am busy with other things at the moment, but if somebody
develops a patch, I'll be hapy to review and commit it.
Andrus
> I've just started playing around with PostgreSQL and I have to second
> your observations. Postgres does all kinds of strange things when you
> don't place table or column names in quotes. Other dbs also handle
> schema, table and column names in quotes well (e.g. FrontBase).
> Therefore I would appreciate if the ORM system would support this.
> (Hibernate does not, btw).
>
> -Will
>
> On 03.06.2005, at 16:40, Kevin Menard wrote:
>
>> I just found out I can't create a table named "user" in Postgres
>> because it's a keyword. However, if the name is wrapped in quotes, it
>> can be done. I think someone had raised a similar issue before
>> (except I think it
>> was table names with spaces) and had suggested that Cayenne quote the
>> table name.
>>
>> Would it be wise for the Postgres Adapter to take care of quoting
>> names? On the one hand, I don't think Cayenne should have to overcome
>> the limitations of every db system out there, but on the other, I
>> don't think I should have to worry about how I name my tables in an
>> ORM. Any one else have thoughts on this?
>>
>> --
>> Kevin
This archive was generated by hypermail 2.0.0 : Fri Jun 03 2005 - 11:02:22 EDT