openmicroscopy icon indicating copy to clipboard operation
openmicroscopy copied to clipboard

omero db script → psql: identifiers truncated

Open manics opened this issue 4 years ago • 0 comments

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

manics avatar Feb 03 '20 16:02 manics