Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » EclipseLink » Default Allocation size for sequence(How to define default allocation size for sequence in Postgresql?)
Default Allocation size for sequence [message #842507] Thu, 12 April 2012 11:05 Go to next message
Miguel Goncalves is currently offline Miguel GoncalvesFriend
Messages: 3
Registered: April 2012
Location: Portugal
Junior Member
Hi,

How to define default allocation size for sequence in Postgresql?
By default EclipseLink assume 50. How can change this?
I'm using PostgreSQL 9.1, EclipseLink 2.3.2.

Thanks,

Miguel Goncalves
Re: Default Allocation size for sequence [message #846659 is a reply to message #842507] Mon, 16 April 2012 14:39 Go to previous message
James Sutherland is currently offline James SutherlandFriend
Messages: 1939
Registered: July 2009
Location: Ottawa, Canada
Senior Member

You set the INCREMENT of the sequence object to match the allocation size.

If EclipseLink is creating the sequence (DDL), it will do this automatically.


James : Wiki : Book : Blog : Twitter
Previous Topic:Composite Key OneToOne Join
Next Topic:Default strategy for PostgreSQL
Goto Forum:
  


Current Time: Sat Dec 20 04:40:53 GMT 2014

Powered by FUDForum. Page generated in 0.10237 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software