Re: Sequence postgres.

2008-12-05 Thread Germán Mondragón
Andrus, Pierre, It's working with our Custom Sequence and Cache size = 1,  with PK sequences stepping of 1. Thank you Germán - Mensaje original - De: "Andrus Adamchik" <[EMAIL PROTECTED]> Para: user@cayenne.apache.org Enviados: Viernes, 5 de Diciembre 2008 10:56:27 (GMT-0400) Auto-Detec

Re: Latest code snapshot breaks EJBQLQuery

2008-12-05 Thread Andrus Adamchik
Yeah, this part of the stack has undergone a major rework lately. Although the fact that you had to use this workaround to begin with is already suspect. Let me try this query out and see what's going on. Andrus On Dec 5, 2008, at 9:52 AM, Dave Dombrosky wrote: A query that runs fine for

Re: Sequence postgres.

2008-12-05 Thread Andrus Adamchik
Pierre is absolutely right. PostgreSQL will work the same way as Oracle in this respect. "Default" strategy is based on Cayenne- generated PK sequences with a step of 20, but you can change that with "Custom Sequence" strategy. Andrus On Dec 5, 2008, at 3:14 PM, Pierre Lavignotte wrote:

Re: Problem with cayenne accessing mixed tables in Postgresql

2008-12-05 Thread Andrus Adamchik
Interesting... Seems to be working for me. 1. I created a test project in CayenneModeler 2.0.4. Here is how the double quotes are saved - this is valid XML, and it loads back ok: 2. Since I don't have any 2.0 projects, I then switched to 3.0, and modified one of my exis

Re: Sequence postgres.

2008-12-05 Thread Pierre Lavignotte
Hello, With Oracle, you have to set the PK generation strategy to "Custom sequence" and the "Cache PK Size" to 1. Guess it will be the same with Postgres. Pierre On Fri, Dec 5, 2008 at 1:51 PM, Germán Mondragón <[EMAIL PROTECTED]> wrote: > Hello, > We need to know how to set the Cayenne with p

Sequence postgres.

2008-12-05 Thread Germán Mondragón
Hello, We need to know how to set the Cayenne with postgres to always make an insert realize a nextval on the sequence postgres. thank