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: [email protected] 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 <[EMAIL PROTECTED]> > 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
