liquibase.exception.DatabaseException: Error executing SQL UPDATE file_metadata m SET toolbox_input_file = getglobalattribute(file_id, 'toolbox_input_file'): ERROR: function getglobalattribute(bigint, unknown) does not exist

GitHub | lbesnard | 5 months ago
  1. 0

    getglobalattribute psql function not exist

    GitHub | 5 months ago | lbesnard
    liquibase.exception.DatabaseException: Error executing SQL UPDATE file_metadata m SET toolbox_input_file = getglobalattribute(file_id, 'toolbox_input_file'): ERROR: function getglobalattribute(bigint, unknown) does not exist
  2. 0

    wfs:imos:aatams_biologging_shearwater_data is not working

    GitHub | 1 year ago | danfruehauf
    liquibase.exception.DatabaseException: Error executing SQL ALTER TABLE aatams_biologging_shearwater_map ALTER COLUMN start_date TYPE timestamp with time zone, ALTER COLUMN end_date TYPE timestamp with time zone: ERROR: cannot alter type of a column used by a view or rule Detail: rule _RETURN on view report_test.aatams_biologging_all_deployments_view depends on column "start_date": Caused By: Error executing SQL ALTER TABLE aatams_biologging_shearwater_map ALTER COLUMN start_date TYPE timestamp with time zone, ALTER COLUMN end_date TYPE timestamp with time zone: ERROR: cannot alter type of a column used by a view or rule Detail: rule _RETURN on view report_test.aatams_biologging_all_deployments_view depends on column "start_date": Caused By: ERROR: cannot alter type of a column used by a view or rule Detail: rule _RETURN on view report_test.aatams_biologging_all_deployments_view depends on column "start_date"
  3. 0

    Talend: Write data to PostgreSQL database error

    Stack Overflow | 5 years ago | Tjekkles
    org.postgresql.util.PSQLException: ERROR: zero-length delimited identifier at or near """"
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    erro: MappedDouble is not mapped to 'double precision' datatype in PostgreSQL?

    Google Groups | 7 years ago | JanWillem Tulp
    org.postgresql.util.PSQLException: ERROR: type "double" does not exist
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. org.postgresql.util.PSQLException

    ERROR: function getglobalattribute(bigint, unknown) does not exist

    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse()
  2. PostgreSQL JDBC Driver
    AbstractJdbc2Statement.execute
    1. org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1592)
    2. org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1327)
    3. org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:192)
    4. org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:451)
    5. org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:336)
    6. org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:328)
    6 frames
  3. Liquibase Core
    Liquibase.update
    1. liquibase.executor.jvm.JdbcExecutor$1ExecuteStatementCallback.doInStatement(JdbcExecutor.java:92)
    2. liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)
    3. liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:104)
    4. liquibase.database.AbstractDatabase.execute(AbstractDatabase.java:1091)
    5. liquibase.database.AbstractDatabase.executeStatements(AbstractDatabase.java:1075)
    6. liquibase.changelog.ChangeSet.execute(ChangeSet.java:317)
    7. liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:27)
    8. liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:58)
    9. liquibase.Liquibase.update(Liquibase.java:114)
    9 frames
  4. anmn_metadata.anmn_metadata_harvester_0_1
    ANMN_metadata_harvester.main
    1. anmn_metadata.anmn_metadata_harvester_0_1.ANMN_metadata_harvester.iPostgresqlDbUpdate_1Process(ANMN_metadata_harvester.java:1393)
    2. anmn_metadata.anmn_metadata_harvester_0_1.ANMN_metadata_harvester.iUpdateIndex_2Process(ANMN_metadata_harvester.java:1091)
    3. anmn_metadata.anmn_metadata_harvester_0_1.ANMN_metadata_harvester.runJobInTOS(ANMN_metadata_harvester.java:4012)
    4. anmn_metadata.anmn_metadata_harvester_0_1.ANMN_metadata_harvester.main(ANMN_metadata_harvester.java:3840)
    4 frames