Re: postgresql schema ignored when adding foreign key

[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 12:14 AM, D Tim Cummings wrote:
> 
>> 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 
>> names with schemas - Migrations don't work
>> 
>> 
>> Regards
>> 
>> Tim Cummings
>> 
>> On 06/04/2011, at 2:27 AM, Michael Gargano wrote:
>> 
>>> 
>>> 
>>> 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 complex... maybe both.  :p
>>> 
>>> -Mike
>>> 
>>> ___
>>> Do not post admin requests to the list. They will be ignored.
>>> Webobjects-dev mailing list  (Webobjects-dev@lists.apple.com)
>>> Help/Unsubscribe/Update your Subscription:
>>> http://lists.apple.com/mailman/options/webobjects-dev/tim%40triptera.com.au
>>> 
>>> This email sent to t...@triptera.com.au
>> 
> 
> ___
> Do not post admin requests to the list. They will be ignored.
> Webobjects-dev mailing list  (Webobjects-dev@lists.apple.com)
> Help/Unsubscribe/Update your Subscription:
> http://lists.apple.com/mailman/options/webobjects-dev/probert%40macti.ca
> 
> This email sent to prob...@macti.ca

 ___
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list  (Webobjects-dev@lists.apple.com)
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com

This email sent to arch...@mail-archive.com

Re: postgresql schema ignored when adding foreign key

[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 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 wrote:
> 
>> 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 
>> names with schemas - Migrations don't work
>> 
>> 
>> Regards
>> 
>> Tim Cummings
>> 
>> On 06/04/2011, at 2:27 AM, Michael Gargano wrote:
>> 
>>> 
>>> 
>>> 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 complex... maybe both.  :p
>>> 
>>> -Mike
>>> 
>>> ___
>>> Do not post admin requests to the list. They will be ignored.
>>> Webobjects-dev mailing list  (Webobjects-dev@lists.apple.com)
>>> Help/Unsubscribe/Update your Subscription:
>>> http://lists.apple.com/mailman/options/webobjects-dev/tim%40triptera.com.au
>>> 
>>> This email sent to t...@triptera.com.au
>> 
> 
> ___
> Do not post admin requests to the list. They will be ignored.
> Webobjects-dev mailing list  (Webobjects-dev@lists.apple.com)
> Help/Unsubscribe/Update your Subscription:
> http://lists.apple.com/mailman/options/webobjects-dev/probert%40macti.ca
> 
> This email sent to prob...@macti.ca

 ___
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list  (Webobjects-dev@lists.apple.com)
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com

This email sent to arch...@mail-archive.com

Re: postgresql schema ignored when adding foreign key

[D Tim Cummings]

Thanks Pascal

Tim



On 07/04/2011, at 21:53, Pascal Robert  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 
>> 
>> http://issues.objectstyle.org/jira/browse/WONDER-489
>> Postgresql PlugIn inconsistent application of identifier quoting to table 
>> names with schemas - Migrations don't work
>> 
>> 
>> Regards
>> 
>> Tim Cummings
>> 
>> On 06/04/2011, at 2:27 AM, Michael Gargano wrote:
>> 
>>> 
>>> 
>>> 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 complex... maybe both.  :p
>>> 
>>> -Mike
>>> 
>>> ___
>>> Do not post admin requests to the list. They will be ignored.
>>> Webobjects-dev mailing list  (Webobjects-dev@lists.apple.com)
>>> Help/Unsubscribe/Update your Subscription:
>>> http://lists.apple.com/mailman/options/webobjects-dev/tim%40triptera.com.au
>>> 
>>> This email sent to t...@triptera.com.au
>> 
>> ___
>> Do not post admin requests to the list. They will be ignored.
>> Webobjects-dev mailing list  (Webobjects-dev@lists.apple.com)
>> Help/Unsubscribe/Update your Subscription:
>> http://lists.apple.com/mailman/options/webobjects-dev/probert%40macti.ca
>> 
>> This email sent to prob...@macti.ca
> 
 ___
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list  (Webobjects-dev@lists.apple.com)
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com

This email sent to arch...@mail-archive.com

Re: postgresql schema ignored when adding foreign key

[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 identifier quoting to table 
> names with schemas - Migrations don't work
> 
> 
> Regards
> 
> Tim Cummings
> 
> On 06/04/2011, at 2:27 AM, Michael Gargano wrote:
> 
>> 
>> 
>> 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 
>> complex... maybe both.  :p
>> 
>> -Mike
>> 
>> ___
>> Do not post admin requests to the list. They will be ignored.
>> Webobjects-dev mailing list  (Webobjects-dev@lists.apple.com)
>> Help/Unsubscribe/Update your Subscription:
>> http://lists.apple.com/mailman/options/webobjects-dev/tim%40triptera.com.au
>> 
>> This email sent to t...@triptera.com.au
> 
> ___
> Do not post admin requests to the list. They will be ignored.
> Webobjects-dev mailing list  (Webobjects-dev@lists.apple.com)
> Help/Unsubscribe/Update your Subscription:
> http://lists.apple.com/mailman/options/webobjects-dev/probert%40macti.ca
> 
> This email sent to prob...@macti.ca

 ___
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list  (Webobjects-dev@lists.apple.com)
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com

This email sent to arch...@mail-archive.com

Re: postgresql schema ignored when adding foreign key

[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 wrote:

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 names 
with schemas - Migrations don't work


Regards

Tim Cummings

On 06/04/2011, at 2:27 AM, Michael Gargano wrote:



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 complex... maybe both.  
:p

-Mike

___
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list  
(Webobjects-dev@lists.apple.com)
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/tim%40triptera.com.au

This email sent to t...@triptera.com.au


 ___
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list  (Webobjects-dev@lists.apple.com)
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com

This email sent to arch...@mail-archive.com

Re: postgresql schema ignored when adding foreign key

[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 names 
with schemas - Migrations don't work


Regards

Tim Cummings

On 06/04/2011, at 2:27 AM, Michael Gargano wrote:

> 
> 
> 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 
> complex... maybe both.  :p
> 
> -Mike
> 
> ___
> Do not post admin requests to the list. They will be ignored.
> Webobjects-dev mailing list  (Webobjects-dev@lists.apple.com)
> Help/Unsubscribe/Update your Subscription:
> http://lists.apple.com/mailman/options/webobjects-dev/tim%40triptera.com.au
> 
> This email sent to t...@triptera.com.au



smime.p7s
Description: S/MIME cryptographic signature
 ___
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list  (Webobjects-dev@lists.apple.com)
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com

This email sent to arch...@mail-archive.com