During a run of my synchronising script for a postrgresdb, i run into an error, and i have no idea how to solve this:
´´
“Caused by: org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL
grammar [create or replace view app_institution_class_detail_vw”,
“as”,
“with class_detail as (“,
“select instnumber”,
“, classnumber”,
“, min(type) as type”, “,
min(code) as code”, “,
count(1) as numberids”,
“from class_desc ki1”,
“group by instnumber, classnumber”,
“)”,
“select aic.id as id”,
“, ai.id as app_institution_id”,
“, cd.classnumber”,
“, cd.type”,
“, cd.code”,
“, cd.numberids”,
“, (aik.id is not null) as active”,
“from class_detail cd”,
“inner join”,
“app_insitution ai”,
“on ai.instnumber = cd.instnumber”,
“left join”,
“app_institution_class aic”,
“on ( aik.applicatiepakket_instelling_id = ai.id”,
“and aic.classnumber = cd.classnumber”,
“)”,
“]; nested exception is org.postgresql.util.PSQLException: ERROR: permission denied for tablespace ilo”,´
´´
I am trying to create a view in the database, but i run into a permission denied error. What could be the problem