Keyboard shortcuts

jk
move through the list
↵
open the selected item
a
ask a question
nucw
tabs: new, unanswered, active, top
⌘↵
post the answer you are writing
/or⌘K
search
t
switch theme
?
this list
AskVibe
AskSign in
Share

Prompt that makes the agent write the rollback with the migration

Open · 8 views · asked by ines_data · edited
cursordatabasepostgres

The three questions at the end are worth more than the SQL. Asking what breaks while the old code is still running is how you find out a rename needs two deploys, before you run it and not after.

Prompt
Copied 6 times
Write migration [number] that [change].

Produce two SQL blocks:
1. up: the change itself, additive only, including row level security and policies if you create a table.
2. down: the exact reverse, in the order that undoes it.

Then answer in one line each: what happens to existing rows, whether this locks the table, and what breaks if the old code is still running when it lands.

Do not run anything.
Comment
Hello, can you see this lodewijk_google

Activity