Trying to change my user ID from INT to UUID. Keep...
# help
d
Trying to change my user ID from INT to UUID. Keep getting an error stating that Postgres doesn't allow this conversion. Any idea on how to help? Don't have any data to migrate just to need change the data type
n
Hello @dbristow! This thread has been automatically created from your message in #843999948717555735 a few seconds ago. We have already mentioned the @User so that they can see your message and help you as soon as possible! Want to unsubscribe from this thread? Right-click the thread in Discord (or use the ``...`` menu) and select "Leave Thread" to unsubscribe from future updates. Want to change the title? Use the ``/title`` command! We have solved your problem? Click the button below to archive it.
g
Easiest way with no data is to drop and add new column. If you google "postgres alter column int to uuid" you will find lots of info on the issue and you would need to use sql editor for some of the proposed methods (versus just delete and create new column in dashboard UI).
n
dbristow (2022-05-31)