Skip to content

omero db script → psql: identifiers truncated #6211

@manics

Description

@manics

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

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions