Re: Too short field

On 03/07/2019 23:30, Karl Martin Skoldebrand wrote:
>
> 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.
>
>
============================================================================================================================
>
Is there any reason to put a limit of the number of characters in the 
field in the database?

If not, consider using, the 'text' type.


Cheers,
Gavin