openmicroscopy
openmicroscopy copied to clipboard
omero db script → psql: identifiers truncated
Use psql to load the sql file generated by omero db script
. Redirect stdout to /dev/null
so only stderr is shown. These warnings are generated:
$ psql -hlocalhost -p 15432 -Uomero < OMERO5.4__0.sql > /dev/null
NOTICE: identifier "fkcontraststretchingcontext_codomainmapcontext_id_codomainmapcontext" will be truncated to "fkcontraststretchingcontext_codomainmapcontext_id_codomainmapco"
NOTICE: identifier "fklogicalchannel_photometricinterpretation_photometricinterpretation" will be truncated to "fklogicalchannel_photometricinterpretation_photometricinterpret"
NOTICE: identifier "fkreverseintensitycontext_codomainmapcontext_id_codomainmapcontext" will be truncated to "fkreverseintensitycontext_codomainmapcontext_id_codomainmapcont"
see also: https://trello.com/c/Dcu5xeLo/241-omero-db-script-creates-identifiers-that-are-too-long