public inbox for [email protected]  

help / color / mirror / Atom feed

From: Muhammad Ikram <[email protected]>
To: Peter Eisentraut <[email protected]>
Cc: PostgreSQL General <[email protected]>
Subject: Re: Identity column data type difference in PostgreSQL and Oracle
Date: Fri, 3 May 2024 16:11:27 +0500
Message-ID: <CAGeimVqcPM3m_CBxQSnvGpY5r7ZEcE1RJXXTVriu8Ga_wc8XSw@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <CAGeimVpSjtMuq_J8bL_U3qe4ZaH78sVc35sdjZWO9sqJyLtLnA@mail.gmail.com>
	<[email protected]>

Thanks for the advice.


On Fri, 3 May 2024 at 16:09, Peter Eisentraut <[email protected]> wrote:

> On 03.05.24 12:57, Muhammad Ikram wrote:
> > Tables which have an identity column in Oracle when migrated to
> > PostgreSQL, the data type of Identity column is changed to bigint from
> > number by the tools. This causes the size of column to be reduced to max
> > value supported by bigint which is way lower than the oracle  number max.
>
> Sequences in PostgreSQL are limited to bigint, there is nothing that can
> be changed about that.  But you are approximately the first person to
> complain that the range of ids provided by bigint is too small, so maybe
> it's worth reconsidering whether it would work for you.  If it really is
> too small, maybe a uuid would work.  But yes, you'll need to make some
> adjustments to the rest of your database or application code if you make
> such changes.
>
>

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: Identity column data type difference in PostgreSQL and Oracle
  In-Reply-To: <CAGeimVqcPM3m_CBxQSnvGpY5r7ZEcE1RJXXTVriu8Ga_wc8XSw@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox