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" <andru..bjectstyle.org>
Para: use..ayenne.apache.org
Enviados: Viernes, 5 de Diciembre 2008 10:56:27 (GMT-0400) Auto-Detected
Asunto: Re: Sequence postgres.
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:
> 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 <germa..elinux.cl>
> wrote:
>
>> 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
>>
>
>
>
> --
> Cordialement,
> Pierre Lavignotte
> Ingénieur Conception & Développement
> http://pierre.lavignotte.googlepages.com
This archive was generated by hypermail 2.0.0 : Fri Dec 05 2008 - 10:36:35 EST