Re: 21 bit number for sequence - Mailing list pgsql-general

From Christian Kratzer
Subject Re: 21 bit number for sequence
Date
Msg-id 20060415101508.W63374@vesihiisi.cksoft.de
Whole thread Raw
In response to Re: 21 bit number for sequence  ("Shoaib Mir" <shoaibmir@gmail.com>)
List pgsql-general
Hi,

On Sat, 15 Apr 2006, Shoaib Mir wrote:

> Actually that is the application requirment to use 21 bit numbers as porting
> it from Oracle where it used to work.

21 bits are no problem as bigints have 64 bits.  If you mean decimal
digits please explicitly say so. A bit is a binary digit.

> Yeah now i have decided to use a numeric data type in a table and use that
> to write my own nextval and currval functions for that purpose.

you could also try to fix you application which most certainly is
severly broken if it tries to store specific numbers in a sequence.

Greetings
Christian

--
Christian Kratzer                       ck@cksoft.de
CK Software GmbH                        http://www.cksoft.de/
Phone: +49 7452 889 135                 Fax: +49 7452 889 136

pgsql-general by date:

Previous
From: "Mavinakuli, Prasanna (STSD)"
Date:
Subject: HUGE Stack space is gettiing consumed
Next
From: Martijn van Oosterhout
Date:
Subject: Re: HUGE Stack space is gettiing consumed