The project id is: 43353f5c-6fd8-4840-ad56-c1c28725e937

I'm basically not being able to execute a migration script iwthin my postgres database.

Are there any errors in your database logs?

And are you trying to run a migration script in your Dockerfile or during the build process?

Yeah...

After build process, manually

Are you trying to create a trigger?

No... this migration script fill up the DB with needed tables

What does your SQL script look like?

I'm gonna send you:

At the bottom you have a loop that creates the triggers. Try adding a DROP statement for the trigger before adding it.

The error is caused by trying to create preexisting triggers.

One thing that can be useful, is that i'm trying to apply this same script using dbeaver, from my local machine, and it simply runs... No error, nothing. But when i use the web interface, it don't apply the changes to database

I assume you're using the public URL?

Yep

Okay

Reviewing the script, now i've found one thing: I start the cript with begin (starting a new transaction), but the commit is missing.

Tcha!!!

It was that!

Good to know haha

We're done here. Thanks for your time and attention!!!

np