Re: Sequence postgres.

• Previous message: Andrus Adamchik: "Re: Problem with cayenne accessing mixed tables in Postgresql"
• In reply to: Pierre Lavignotte: "Re: Sequence postgres."
• Next in thread: Germán Mondragón: "Re: Sequence postgres."
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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

• Next message: Andrus Adamchik: "Re: Latest code snapshot breaks EJBQLQuery"
• Previous message: Andrus Adamchik: "Re: Problem with cayenne accessing mixed tables in Postgresql"
• In reply to: Pierre Lavignotte: "Re: Sequence postgres."
• Next in thread: Germán Mondragón: "Re: Sequence postgres."
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

This archive was generated by hypermail 2.0.0 : Fri Dec 05 2008 - 08:57:24 EST