Search Postgresql Archives

Too short field

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

 



Hi,

 

We solved the problem of yesterday where I was looking at sequences. It eventually turned that sequence was irrelevant (at least in the PostgreSQL sense) to the problem.

Now, we have a bug in another application that prevents an automatic tool to enter certain users in the database. The organisational field is varchar(60) while the actual Organisation “abbreviation” may be as long as 70 characters (don’t ask why).

What happens to data if I simple redefine the table field as varchar(80) (or something, at least 70+). Does “everything” break database side or can I just go on running the app as is.

Do we need to restart databases or something else that requires an interrupted service?

 

Best regards,

Martin S

============================================================================================================================

Disclaimer:  This message and the information contained herein is proprietary and confidential and subject to the Tech Mahindra policy statement, you may review the policy at http://www.techmahindra.com/Disclaimer.html externally http://tim.techmahindra.com/tim/disclaimer.html internally within TechMahindra.

============================================================================================================================


[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