Search Postgresql Archives

Re: Change column type from int to bigint - quickest way

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



> On Wed, Nov 16, 2016 at 7:49 AM, Merlin Moncure < mmoncure@xxxxxxxxx > wrote:

>> On Fri, Nov 11, 2016 at 9:30 AM, Andreas Brandl < mail@xxxxxxxxxxxxxxxxx >
>> wrote:

>> You just posted the same question a few days ago -- were the answers
>> there unsatisfactory?

> This seems to be a mail system provoked duplicate since Gmail is telling me
> this was sent 11/11 but I just received it yesterday. See my attribution
> quotes
> above.

My first post got bounced but re-appeared today - sorry about this.

The answers were very helpful indeed - thanks Tom and Merlin!

We ended up including the datatype change with the upgrade to 9.6. We're going to have a downtime for this anyways and with a dump-restore-style upgrade this is fairly easy to change.

Thanks again,
Andreas


-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux