Re: [HACKERS] bug in 7.3.2

2006-03-02 Thread Jaime Casanova
On 2/28/06, Suvarna <[EMAIL PROTECTED]> wrote: > we are using postgresql 7.3.2 version. As somebody pointed out, that's not a bug... but i think you must upgrade at least to 7.3.14 even if you really found a bug nobody will fix it for 7.3.2 -- regards, Jaime Casanova "What they (MySQL) lose in

Re: [HACKERS] bug in 7.3.2

2006-03-01 Thread Michael Fuhr
On Wed, Mar 01, 2006 at 10:17:04AM +0530, Suvarna wrote: > actually the number which are missing are in the range of 20-30 and at the > max only 3 transactions are going on at any given point in time. > So if 3 numbers are missing then it was understood the missing numbers are > very large. The nu

Re: [HACKERS] bug in 7.3.2

2006-03-01 Thread Suvarna
- Original Message - From: "Tom Lane" <[EMAIL PROTECTED]> To: "Suvarna" <[EMAIL PROTECTED]> Cc: Sent: Tuesday, February 28, 2006 9:29 PM Subject: Re: [HACKERS] bug in 7.3.2 > "Suvarna" <[EMAIL PROTECTED]> writes: > > We are facing a proble

Re: [HACKERS] bug in 7.3.2

2006-03-01 Thread Suvarna
sday, February 28, 2006 8:56 PM Subject: Re: [HACKERS] bug in 7.3.2 Are you caching sequences? On 2/28/06, Suvarna <[EMAIL PROTECTED]> wrote: we are using postgresql 7.3.2 version. We are facing a problem in nextval of sequence. The problem is as follows,

Re: [HACKERS] bug in 7.3.2

2006-02-28 Thread Christopher Kings-Lynne
That's not a bug it's normal behaviour. Suvarna wrote: we are using postgresql 7.3.2 version. We are facing a problem in nextval of sequence. The problem is as follows, If the server shuts down abrupotly because of power failuar or any other cause then the sequences tend to skip few numbers. Aft

Re: [HACKERS] bug in 7.3.2

2006-02-28 Thread Tom Lane
"Suvarna" <[EMAIL PROTECTED]> writes: > We are facing a problem in nextval of sequence. The problem is as = > follows, > If the server shuts down abrupotly because of power failuar or any other > cause then the sequences tend to skip few numbers. This is not a bug, it is the designed behavior. It

Re: [HACKERS] bug in 7.3.2

2006-02-28 Thread Jonah H. Harris
Are you caching sequences?On 2/28/06, Suvarna <[EMAIL PROTECTED]> wrote: we are using postgresql 7.3.2 version. We are facing a problem in nextval of sequence. The problem is as follows, If the server shuts down abrupotly because of power failuar or any othercause then the sequences tend