Re: postgresql schema ignored when adding foreign key

2011-04-07 Thread Pascal Robert
Patch committed. Schemas don't work if you have the following property true com.webobjects.jdbcadaptor.PostgresqlExpression.enableIdentifierQuoting=true I have a patch to fix this in http://issues.objectstyle.org/jira/browse/WONDER-489 Postgresql PlugIn inconsistent application of

Re: postgresql schema ignored when adding foreign key

2011-04-07 Thread D Tim Cummings
Thanks Pascal Tim On 07/04/2011, at 21:53, Pascal Robert prob...@macti.ca wrote: Patch committed. Schemas don't work if you have the following property true com.webobjects.jdbcadaptor.PostgresqlExpression.enableIdentifierQuoting=true I have a patch to fix this in

Re: postgresql schema ignored when adding foreign key

2011-04-07 Thread Pascal Robert
Quick note: do your patches with Eclipse's Team - Create Patch, and use either .txt or .patch as the file extension. When using .diff, Jira will download it (and Safari will .rdp at the end) instead of showing the patch in the browser. It looks like it's just fundamentally broken, FKs and

Re: postgresql schema ignored when adding foreign key

2011-04-07 Thread Pascal Robert
Patch committed. It looks like it's just fundamentally broken, FKs and unique indexes just don't work in other schemas for postgtgres. For my fixes if you're curious. http://issues.objectstyle.org/jira/browse/WONDER-696 Thanks Tim this info. was helpful. -Mike On Apr 6, 2011, at

Re: postgresql schema ignored when adding foreign key

2011-04-06 Thread Michael Gargano
It looks like it's just fundamentally broken, FKs and unique indexes just don't work in other schemas for postgtgres. For my fixes if you're curious. http://issues.objectstyle.org/jira/browse/WONDER-696 Thanks Tim this info. was helpful. -Mike On Apr 6, 2011, at 12:14 AM, D Tim Cummings

postgresql schema ignored when adding foreign key

2011-04-05 Thread Michael Gargano
EOSchemaGeneration foreignKeyConstraintStatementsForRelationship() seems to ignore schemas. Anyone else have problems with that when using addForeignKey() in a migration with tables with non-default schemas? I tried to fix it on my own, but either my brain is too small or wonder is too

Re: postgresql schema ignored when adding foreign key

2011-04-05 Thread D Tim Cummings
Schemas don't work if you have the following property true com.webobjects.jdbcadaptor.PostgresqlExpression.enableIdentifierQuoting=true I have a patch to fix this in http://issues.objectstyle.org/jira/browse/WONDER-489 Postgresql PlugIn inconsistent application of identifier quoting to table